Printable Version of Topic

Click here to view this topic in its original format

Ventrino Forum for Walker Scripts _ Ventrino FAQ _ How do I recover a corrupt database or table

Posted by: Martyn Feb 11 2006, 03:52 PM

SYMPTOMS

You see errors at random and not all the tables in your database seem to be available, you might see test similar to the following in places:-

Invalid query_last: Duplicate entry

[MySQL][ODBC 3.51 Driver][mysqld-4.0.12-nt]Can't open file: 'vtp_members.MYI'. (errno: 145)

CAUSE

A database table has been damaged or corrupted.

SOLUTION

1. There are two possible solutions. First go BCP/System Optimiser and set "Run table repairs" to Yes then click the Run button.

This can take some time, especially if you have a busy site so please wait until the screen says it is safe to continue.

2. If the above does not work you need to run a repair on just the table that has the problem, this is done by login into your phpMyAdmin, and then selecting the damaged table by placing a check mark against it and choosing Repair from the dropdown list (see image below).



To identify a table that needs repair phpMyAdmin places the words "in use" across several of the right hand columns.



This process can also take some time so please be patient!

Where do I find PhpMyAdmin?
Login to your hosting control panel, select phpMyAdmin from the databases section

 

Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)