备份数据库

备份数据和表结构

mysqldump -h yourhostnameorIP -u root -pPASSWORD  dbname > dbdata.sql

只备份表结构 来源：https://stackoverflow.com/questions/6175473/mysql-export-schema-without-data

mysqldump -h yourhostnameorIP -u root -pPASSWORD --no-data dbname > schema.sql

恢复数据库

参考：https://www.liquidweb.com/kb/mysql-backup-database/

创建数据库

mysql -u  database_username  database_name -pPASSWORD -e "create database new_db_name"

恢复数据

mysql -u  database_username  database_name -pPASSWORD < database_backup_file.sql