How do I recover a corrupt database or table, and how to identify a corrupt database or table Options

[Martyn]

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).

 SNAG_0032.gif ( 18.56K ) Number of downloads: 221

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

 inuse.gif ( 7.72K ) Number of downloads: 216

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

Attached File(s)

 SNAG_0033.gif ( 7.74K ) Number of downloads: 171