1.mysql全量导出命令 dbname 是数据库名称,dbname.sql是导出后的名称,需要在mysql安装目录下的bin目录执行
mysqldump -u root -p password dbname > ./dbname.sql
2.导入
登录mysql,执行如下命令
1.mysqldump -u root -p password
2.use dbname;
3.source /www/server/mysql/bin/dbname.sql
标签:mysql,导出,导入,mysqldump,sql,dbname From: https://www.cnblogs.com/hjieone/p/17377493.html