备份一个数据库
mysqldump -hhostname -uusername -pmypwd databasename > /path to backup/bakname.sql 备份并压缩 mysqldump -hhostname -uusername -pmypwd databasename ｜ gzip > /path to backup/bakname.sql.gz 备份多个数据库
mysqldump -hhostname -uusername -pmypwd databases databasename1 databasename2 databasename3 > /path to
backup/bakname.sql
备份数据库一些表
mysqldump -hhostname -uusername -pmypwd databasename table1 table2 table3 > /path to backup/bakname.sql
仅备份数据库结构
mysqldump -no-data -databases databasename1 databasename2 databasename3 > /path to backup/bakname.sql
备份所有数据库
mysqldump -all-databases > /path to backup/bakname.sql
更多内容