Save 15% on Instant Deploy Bare-Metal Servers in 26 Global Markets with Coupon Code: EdgeSave

Backup a database from the shell prompt

Another technique for backing up a database is to use the mysqldump program or the mysqlhotcopy script.

Create a full backup of your database:

shell> mysqldump --tab=/path/to/some/dir --opt db_name


shell> mysqlhotcopy db_name /path/to/some/dir

You can a

Share on Twitter
Share on Facebook