MYSQL database corrupt

**Nookster** · 02-24-2007, 12: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, 12: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, 01: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, 01: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, 01:10 PM

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, 01:10 PM

Is there also a way of fixing this by phpmyadmin ?

**Subway** · 02-24-2007, 01:11 PM

Originally posted by Nookster

Have you tried doing a simple export yet??

Export doesn't work anymore

**darling2** · 02-24-2007, 01: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, 01:50 PM

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.

MYSQL database corrupt

MYSQL database corrupt

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment