![]() |
MYSQL database corrupt
How can i repair this, is there a neat piece of software for ?
|
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. |
I didn't know that could happen.
By corrupt, do you mean the actual data or the index to the data? |
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 |
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 |
Quote:
|
Is there also a way of fixing this by phpmyadmin ?
|
Quote:
|
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 |
Quote:
|
All times are GMT -7. The time now is 07:52 AM. |
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123