Home / server / Questions / 641057
In Process
JCCyC
Asked: 2014-10-31 21:19:05 +0800 CST

Can I restore the "mysql" system database along with another from a mysqldump backup?

  • 772

Basically, what I did is:

mysqldump -uroot -pxxx <some_options> --result-file Backup.sql --databases mysql customappdb

Is it sane to later do

mysql -uroot -pxxx < Backup.sql

Or do I need to take special precautions? I'm running 5.1.73-community.

mysql

2 Answers

  1. The only way you could mysqldump a mysql system database from one MySQL instance into another without any issues is if the major versions of MySQL are the same.

    • You can mysqldump MySQL 5.0.x systems tables and load into MySQL 5.0.x
    • You can mysqldump MySQL 5.1.x systems tables and load into MySQL 5.1.x
    • You can mysqldump MySQL 5.5.x systems tables and load into MySQL 5.5.x
    • You can mysqldump MySQL 5.6.x systems tables and load into MySQL 5.6.x

    You cannot do this to higher versions or lower versions because the mysql.user table layout changes with every major release of MySQL.

    See my posts on why and how to dump the system tables separately

    • 2

  2. Importing the mysql dump file 'backup.sql' would restore the system databases "mysql" along with the database customappdb.It would remove the existing system "mysql" database if it is already present there.

    Regarding the import command for mysql,your syntax is correct and you can go ahead.

    • 0