Overview
This article explains how to back up your MySQL databases hosted with DreamHost.
Background
DreamHost provides several methods to back up your MySQL databases. The tools offered include the DreamHost panel, the provided phpMyAdmin interface, and command line options to generate a backup.
How to back up your database
You can use any of the following methods to back up a database.
Using the panel backup tool
The account backup tool is located on your Manage 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. See this article for more information.
Using phpMyAdmin
phpMyAdmin is a MySQL database administration tool that provides an easy-to-use UI through a web browser. See this article for instructions on how to backup your database using this tool.
Backing up via SSH
You can also back up your database by running a command or creating a script via SSH. See this article for further details.