MySQL DB import/export command line

 1) mysqldump -u [honnikery] –p[password]  [honnikery] > (dump_honnikery.sql)


Backup MySQL Database Structure Only

2) mysqldump -u [honnikery] –p[password] –no-data [honnikery] > (dump_honnikery.sql)


Backup MySQL Database Data Only

3) mysqldump -u [honnikery] –p[password] –no-create- [honnikery] > [dump_honnikery.sql]


Backup Multiple MySQL Databases into a Single File


4) mysqldump -u [honnikery] –p[password] –all-database > [dump_honnikery.sql]

MySQL Database  to import

mysql -u username -p databasename < filename.sql 

 mysql --u [username] --password=[password] [database name] < [dump file]