FUDforum: How To » MYSQL MESS AFTER HOSTING SERVICE CRASH

Home » FUDforum » How To » MYSQL MESS AFTER HOSTING SERVICE CRASH

Show: Today's Messages :: Polls :: Message Navigator

Re: MYSQL MESS AFTER HOSTING SERVICE CRASH [message #21041 is a reply to message #21037]

Wed, 10 November 2004 06:13

creamywf

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.

Report message to a moderator

[Message index]

		MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Tue, 09 November 2004 05:11
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: Ilia on Tue, 09 November 2004 13:58
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Tue, 09 November 2004 17:48
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Tue, 09 November 2004 18:16
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: Ilia on Tue, 09 November 2004 18:18
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Wed, 10 November 2004 06:13
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: Ilia on Wed, 10 November 2004 14:10
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Wed, 10 November 2004 19:11
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: Ilia on Wed, 10 November 2004 20:48
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: Ilia on Tue, 09 November 2004 18:17
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Thu, 11 November 2004 01:10
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Thu, 11 November 2004 01:11
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: Ilia on Thu, 11 November 2004 01:15
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Thu, 11 November 2004 04:36
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Thu, 11 November 2004 04:38
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Thu, 11 November 2004 04:39
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Thu, 11 November 2004 05:23
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Thu, 11 November 2004 05:35
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: Ilia on Thu, 11 November 2004 13:33
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Thu, 11 November 2004 18:39
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: Ilia on Thu, 11 November 2004 20:05
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: creamywf on Wed, 17 November 2004 20:59
		Re: MYSQL MESS AFTER HOSTING SERVICE CRASH By: Ilia on Wed, 17 November 2004 21:39

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) ] [

]

Current Time: Thu Sep 19 21:58:05 GMT 2024

Total time taken to generate the page: 0.05205 seconds