导出

  • 导出数据和表结构
1
$ mysqldump -u[usermae] -p [dbname] > [dbname].sql
  • 只导出表结构
1
$ mysqldump -u[usermae] -p -d [dbname] > [dbname].sql

导入

  • 创建一个空数据库
1
mysql> create database [dbname] character set utf8;
  • 创建MySQL用户并授权
1
2
CREATE USER '[username]'@'localhost' IDENTIFIED BY '[password]';
GRANT ALL PRIVILEGES ON [dbname].* TO '[username]'@'localhost';
  • 导入数据表和数据
1
$ mysql -u[username] -p [dbname] < /path/to/[dbname].sql