JZTXT

mysql 备份还原命令备忘

发布时间 2024-01-03 11:32:51作者: 长虫山小木屋

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;