Check and repair the database Mysql

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

Ca te plait then sharing:
  • Sphinn
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • Scoopeo
  • Wikio FR
  • MisterWong FR




1 Response to "Check and repair the database Mysql"

    1. on Oct 27th, 2008 at 1:06 pm 1 Migration wordpress 1.0 to 2.6 MU

    Leave a Reply