MySQL export/import database

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

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.