Moving MySQL/Windows to same version of MySQL/Linux

Moving MySQL/Windows to same version of MySQL/Linux. You can mysqldump all the databases as follows:

C:\> mysqldump -uroot -p --routines --triggers --flush-privileges --all-databases > MySQLData.sql

Move MySQLData.sql to Linux box and run the reload

mysql -uroot -p < MySQLData.sql
Share

Leave a Reply