mysql --all-database

<pre name="code" class="sql">mysqldump -uroot -p'123456'  -R --single-transaction --master-data=2 --all-database >a.sql

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql` /*!40100 DEFAULT CHARACTER SET latin1 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `plmsdb` /*!40100 DEFAULT CHARACTER SET latin1 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `zjzb` /*!40100 DEFAULT CHARACTER SET utf8 */;

会自动重建数据库