MYSQL database corrupt - GoFuckYourself.com

Subway · 02-24-2007, 02:51 PM

How can i repair this, is there a neat piece of software for ?

Nookster · 02-24-2007, 02:54 PM

you should have made backups yo, that would have fixed your problem.
i'll search around for you but i haven't ever been able to fix a corrupt dbase yet.

interracialtoons · 02-24-2007, 02:58 PM

I didn't know that could happen.

By corrupt, do you mean the actual data or the index to the data?

psili · 02-24-2007, 03:02 PM

Can you do a mysqldump [db] > textfile.sql ?

Or is it really fucked?

Regardless, here's the MySQL doc on checking databases:

http://dev.mysql.com/doc/refman/5.0/en/repair.html

Subway · 02-24-2007, 03:04 PM

I don't know what or where it's wrong, everything works still fine but when i want to make a backup the admin panel says

Error while backing up database webx555k_blognld

Nookster · 02-24-2007, 03:10 PM

Quote:

Originally Posted by Subway

I don't know what or where it's wrong, everything works still fine but when i want to make a backup the admin panel says

Error while backing up database webx555k_blognld

Have you tried doing a simple export yet?? If the data is still able to be pulled from the database and shown on pages you should be able to export the data fine.

Subway · 02-24-2007, 03:10 PM

Is there also a way of fixing this by phpmyadmin ?

Subway · 02-24-2007, 03:11 PM

Quote:

Originally Posted by Nookster

Have you tried doing a simple export yet??

Export doesn't work anymore

darling2 · 02-24-2007, 03:49 PM

you can use the repair table command.

1. log into your server via ssh.
2. then use the mysql client to connect to the database like:
mysql -uYourUserNAme -pYourPassword YourDatabasename

3. issue this command for every broken table:
repair table YourTableName;

After this all your tables will be fixed and you can export them

StuartD · 02-24-2007, 03:50 PM

Quote:

Originally Posted by darling2

you can use the repair table command.

1. log into your server via ssh.
2. then use the mysql client to connect to the database like:
mysql -uYourUserNAme -pYourPassword YourDatabasename

3. issue this command for every broken table:
repair table YourTableName;

After this all your tables will be fixed and you can export them

Can also be done in phpMyAdmin pretty easily if that's on there.

02-24-2007, 02:51 PM	#1
Subway Confirmed User Industry Role: Join Date: Apr 2004 Location: Here Posts: 584	MYSQL database corrupt How can i repair this, is there a neat piece of software for ?

02-24-2007, 02:54 PM	#2
Nookster Confirmed IT Professional Industry Role: Join Date: Nov 2005 Location: Hollywood, CA Posts: 3,744	you should have made backups yo, that would have fixed your problem. i'll search around for you but i haven't ever been able to fix a corrupt dbase yet. __________________ The Best Affiliate Software, Ever.

02-24-2007, 02:58 PM	#3
interracialtoons Confirmed User Join Date: May 2006 Posts: 1,910	I didn't know that could happen. By corrupt, do you mean the actual data or the index to the data? __________________ Done.

02-24-2007, 03:02 PM	#4
psili Confirmed User Join Date: Apr 2003 Location: Loveland, CO Posts: 5,526	Can you do a mysqldump [db] > textfile.sql ? Or is it really fucked? Regardless, here's the MySQL doc on checking databases: http://dev.mysql.com/doc/refman/5.0/en/repair.html __________________ Your post count means nothing.

02-24-2007, 03:04 PM	#5
Subway Confirmed User Industry Role: Join Date: Apr 2004 Location: Here Posts: 584	I don't know what or where it's wrong, everything works still fine but when i want to make a backup the admin panel says Error while backing up database webx555k_blognld

02-24-2007, 03:10 PM	#7
Subway Confirmed User Industry Role: Join Date: Apr 2004 Location: Here Posts: 584	Is there also a way of fixing this by phpmyadmin ?

02-24-2007, 03:49 PM	#9
darling2 Confirmed User Join Date: Jul 2006 Posts: 345	you can use the repair table command. 1. log into your server via ssh. 2. then use the mysql client to connect to the database like: mysql -uYourUserNAme -pYourPassword YourDatabasename 3. issue this command for every broken table: repair table YourTableName; After this all your tables will be fixed and you can export them