The easiest way to export is use syntax in command prompt (cmd):
mysqldump -u USER -p PASSWORD DATABASE > filename.sql
To import the same file, the syntax is:
mysql -u USER -p PASSWORD DATABASE < filename.sql
Tech Tips and Tricks
The easiest way to export is use syntax in command prompt (cmd):
mysqldump -u USER -p PASSWORD DATABASE > filename.sql
To import the same file, the syntax is:
mysql -u USER -p PASSWORD DATABASE < filename.sql