Import and export all MySQL databases on Windows and Mac


Under Windows, you can very easily all data with one command export in MySQL using mysqldump:

cd C:\xampp\mysql\bin
mysqldump.exe -u root -p --opt --all-databases --verbose > C:\export.sql

 

Explanation:

 –opt:Export all DBs, without “System” databases like mysql, INFORMATION_SCHEMA, performance_schema and test

 –verbose: to log messages to show on the screen, There are not many, so that does not affect the performance is great