2017/03/23

Import/Export SQL file under command line

It tells how to import/export SQL file under command line.

Import SQL file.

[command]
mysql -u USERNAME -p DATABASE_NAME < SQL_FILE_NAME
---------------------------------------------------------------

Export SQL file.

[command]
mysqldump -u USERNAME -p DATABASE_NAME > SQL_FILE_NAME

No comments:

Post a Comment