mysql 使用命令备份数据库

windos

cd C:\Program Files\MySQL\MySQL Server 8.0\bin>
//备份数据库  project_test 是数据库名字
mysqldump -u root -p project_test > C:\sflogs\mydatabase_backup.sql
//恢复数据库  project_test1  是要恢复的数据库名字
mysql -u root -p root --default-character-set=utf8 project_test1 < C:\sflogs\mydatabase_backup.sql

linux

mysqldump -u root -p123456 project_test > /home/backup/mydatabase_backup.sql

mysql -u root -p root --default-character-set=utf8 project_test1 <  /home/backup/mydatabase_backup.sql