IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
How do I recover a corrupt database or table, and how to identify a corrupt database or table
Martyn
post 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).

Attached File  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.

Attached File  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)
Attached File  SNAG_0033.gif ( 7.74K ) Number of downloads: 171
 
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 28th March 2024 - 11:59 AM