阅读:13
1. mysqldump命令 # 备份整个数据库 mysqldump -u root -p dbname >backup.sql # 备份选择的表 mysqldump -u root -p dbname table1 table2 >backup.sql # 压缩备份文件 mysqldump -u root -p dbname | gzip >backup.sql.gz # 恢复备份 mysql -u root -p dbname< backup.sql2. mysqlhotcopy命令 # 备份整个数据库 mysqlhotcopy -u root -p dbname /path/to/backup# 备份指定表 mysqlhotcopy -u root -p -d dbname table1 table2 /path/to/backup3. 复制命令 # 复制整个数据库 mysql -u root -p -e "CREATE DATABASE dbname2; GRANT ALL PRIVILEGES ON dbname2.* TO 'username'@'%' IDENTIFIED BY 'password';" mysqldump -u root -p dbname | mysql -u username -p dbname2 # 复制指定表 mysql -u root -p -e "CREATE DATABASE dbname2; GRANT ALL PRIVILEGES ON dbname2.* TO 'username'@'%' IDENTIFIED BY 'password';" mysqldump -u root -p dbname table1 table2 | mysql -u username -p dbname24. mysqlpump命令 # 备份整个数据库 mysqlpump -u root -p dbname >backup.sql # 备份指定表 mysqlpump -u root -p --tables dbname table1 table2 >backup.sql# 压缩备份文件 mysqlpump -u root -p dbname | gzip >backup.sql.gz # 恢复备份 mysql -u root -p dbname< backup.sql