Windows使用CMD下备份,用powershell备份库的话,在Linux上恢复时有些库出现了
ERROR: ASCII '\0' appeared in the statement
mysqldump备份:
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqldump.exe --single-transaction -u root -p -A >E:\all_20181228.sql
MySQL8.0使用mysqldump不能使用-p直接带密码,会出现
mysqldump: [Warning] Using a password on the command line interface can be insecure.
--single-transaction与事物隔离RR级别类似,即备份过程中新提交的数据不会被备份。
mysqldump恢复:
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql.exe -u root -p autoclub_db < E:\autoclub_db_20181228.sql