This article illustrates how to back up your MySQL databases hosted with DreamHost.
DreamHost provides a handful of backup methods for MySQL databases, with the actions ranging from extremely simple to mildly technical. The tools offered include the DreamHost panel, the provided phpMyAdmin interface, and using the server command line to generate a backup available for FTP downloading.
Backing up using the panel backup tool
The account backup tool is located on your (Panel > 'Billing & Account' > 'Backup Your Account') page. It downloads all the data in your account, including all users, mailboxes, and databases (MySQL stored procedures are captured as well), in a series of .zip archive files.
You can read more about this in the following article:
Backing up using phpMyAdmin
phpMyAdmin is a MySQL database administration tool that provides a (relatively) easy-to-use UI through a web browser. View the following article for instructions on how to backup your database:
Backing up via SSH
View the following article for details on how to backup your database using a shell user:
Migrating your database to DreamHost
View the following article for detailed instructions: