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;
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;