FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » MYSQL MESS AFTER HOSTING SERVICE CRASH
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: MYSQL MESS AFTER HOSTING SERVICE CRASH [message #21041 is a reply to message #21037] Wed, 10 November 2004 06:13 Go to previous messageGo to previous message
creamywf is currently offline  creamywf   United States
Messages: 54
Registered: April 2002
Karma:
Member
Here is the info from the person who tried to repair the database, it seems he is at an impasse. Any ideas on where to go from here that I can relay to him????

To clarify on the repair methods I have attempted with your database.

Method 1.
1. Logging into MySQL.
2. Running: mysqlcheck -B aag522_FUDforum -e -a -u root -p
3. Running: mysqlcheck -B aag522_FUDforum -e -r -u root -p
4. Running: mysqlcheck -B aag522_FUDforum -e -c -u root -p

Method 2.
1. Shutting down MySQL server process.
2. Running the following commands.
a. cd /var/lib/mysql/aag522_FUDforum
b. myisamchk -e -r -f *.MYI

Method 3.
1. Created a new database.
2. Created all tables and moved all *.MYD and *.frm files over to new
database.
3. Recreated *.MYI files via logging into MySQL and running 'REPAIR TABLE
[TABLE_NAME] USE_FRM;' for each table.

The errors would go along with what you have been told--that there is partial written or invalid data in the database. Unfortunately I have found no method to locate and cleanup/remove this invalid data. I am still looking and any additional information you locate I will look over and
attempt if viable.
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Can Profile defaults for "Select Notification" and "Private Message Notification"
Next Topic: can't create categories
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 09 16:42:07 GMT 2024

Total time taken to generate the page: 0.04759 seconds