Tuesday, July 23, 2013

Mysql dump backup and restore all database

Backup:

  mysqldump --flush-privileges --all-database -p > mysqldump.all.database.20130723.sql


Restore:

  mysql -u root -p < mysqldump.all.database.20130723.sql

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.