MySQL利用mysqldump进行数据库备份及还原
备份
C:\Users\Administrator>mysqldump -u root -p1234 -B testforbackup > d:\backtest.sql
还原
C:\Users\Administrator>mysql -uroot -p1234 --default-character-set=utf8 < d:\backupups.sql
备份
C:\Users\Administrator>mysqldump -u root -p1234 -B testforbackup > d:\backtest.sql
还原
C:\Users\Administrator>mysql -uroot -p1234 --default-character-set=utf8 < d:\backupups.sql