Home / Tips / BSD / FreeBSD / How to make MySQL database backup on FreeBSD

How to make MySQL database backup on FreeBSD

FreeBSD
FreeBSD
  • Currently 0 out of 5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Rating: 0/5 (0 votes cast)

Thank you for rating!

You have already rated this page, you can only rate it once!

Your rating has been changed, thanks for rating!

Log in or create a user account to rate this page.


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


Read also

Install MySQL server on FreeBSD

Install MySQL server on FreeBSD

Install Apache in FreeBSD

Install Apache in FreeBSD

Log in or create a user account to post a comment.

easyos.net
117217982212577402640

Quick navigation

General navigation