GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   MYSQL database corrupt (https://gfy.com/showthread.php?t=709257)

Subway 02-24-2007 02:51 PM

MYSQL database corrupt
 
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 (Post 11968755)
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 (Post 11968777)
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 (Post 11968874)
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.


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