How do I recover a corrupt database or table, and how to identify a corrupt database or table |
How do I recover a corrupt database or table, and how to identify a corrupt database or table |
Feb 11 2006, 03:52 PM
Post
#1
|
|
WSF Commander Group: Admin Posts: 4,662 Joined: 26-August 05 Member No.: 10 |
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
Attached File(s)
|
|
|
Lo-Fi Version | Time is now: 30th October 2024 - 03:23 AM |