WF AQ

Knowledge base

Export and import mysql database through command line

EXPORT

mysqldump -uUSERNAME -pPASSWORD -hHOSTNAME DATABASE > FILENAME.sql

IMPORT

mysql -uUSERNAME -pPASSWORD -hHOSTNAME DATABASE < FILENAME.sql