How to Backup Databases in MYSQL

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]