Import/export MySQL in SSH

Created on 2010-Oct-04
Updated on 2010-Oct-04

Export:

mysqldump -u USERNAME -p DATABASENAME > backupfile.sql

Import :

mysql -u USERNAME -p DATABASENAME  < backupfile.sql

Connect:

mysql -uusername -p DATABASENAME

Tags: ssh mysql