mysql 备份还原命令备忘

1、备份

mysqldump -u username -p databasename tableName > backupfile.sql

2、还原

mysql -u username -p password databasename < backupfile.sql

3、查看

mysql -u username -p databasename
show tables;