How to make MySQL database backup on FreeBSD
Creating a backup of an entire database using mysqldump command.
To create a backup of one database:
mysqldump -u DATABASE_USER -pPASSWORD DATABASE_NAME > backup.sql
To create a backup of all databases on MySQL server:
mysqldump -u DATABASE_USER -pPASSWORD -A > databases_backup.sql
To create a backup of a single table from a database:
mysqldump -u DATABASE_USER -pPASSWORD DATABASE_NAME TABLE_NAME > table_backup.sql