mysqldump from Mysql8 Linux version ready for Mysql8 Windows version

发布于 作者 量尺寸留下评论

mysqldump -u root -p –routines –triggers –single-transaction –add-drop-table –databases YOURDATABASE > YOURDATABASE_FULL.sql

If you need mysqldump from mysql8 Window version ready for mysql8 Linux version:

“C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe” -u root -p –default-character-set=utf8mb4 –routines –triggers –events –single-transaction –hex-blob –skip-lock-tables –set-gtid-purged=OFF YOUR_DATABASE > D:\YOUR_DATABASE.sql

run those command on Linux:

dos2unix YOURDATABASE.sql

mysql -u root -p -e “CREATE DATABASE YOURDATABASE CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;”
mysql -u root -p YOURDATABASE < /path/to/YOURDATABASE.sql

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注