- 备份真个数据库(仅包含表结构)
mysqldump --no-data -h localhost -u root -ppassword mydatabase > mydatabase_backup.sql
- 备份部分表(仅包含表结构)
mysqldump --no-data -h localhost -u root -ppassword mydatabase table1 table2 > mydatabase_backup.sql
- 在执行mysqldump命令是,如果报如下错误:
第一种方法:添加single-transaction参数1044 Access denied when using LOCK TABLES
第二种方法:赋予用户锁表的权限mysqldump --single-transaction -u user -p DBNAME > backup.sql
mysql -u root -p mysql> GRANT SELECT,LOCK TABLES ON DBNAME.* TO 'username'@'localhost';
- 显示字段注释
SHOW FULL COLUMNS FROM <tablename>