Check and repair the database Mysql
Published October 12th, 2008 in Science.Well I still have bases in 4.1 and restore, I realized that I had a table in error in my backup. To repair all of your database, you just run the following command:
mysqlcheck-auto-repair-u "user"-p "Name of your Database"
Then you can perform a full backup of your database and with greater safety by locking the tables.
Locks on all tables before starting the export.
You can add the-f option to continue even if error is important in particular cron. It would be silly to make a partial restoration.
mysqldump-lock-tables-u "user"-p "Name of your Database"> database.sql

























1 Response to "Check and repair the database Mysql"
Please Wait
Leave a Reply