MYSQL database corrupt

[Subway]

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

[Nookster]

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]

I didn't know that could happen.

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

[psili]

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]

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]

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]

Is there also a way of fixing this by phpmyadmin ?

[Subway]

Have you tried doing a simple export yet??

Export doesn't work anymore

[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

[StuartD]

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.