Today, my customer asked me how to backup MySql database on dreamhost, I said you can use php script or some plugin for wordpress(he want to install wordpress on his website), then he asked how did I backup my database, I said I am so lazy that have not backup any database.
I have bought the hosting service from dreamhost over 1 year, but never backup my database, it seems it is not a good idea. so I decide to study how to backup my database.
The easiest way is searching google to get the answer for me. the keyword is “dreamhost mysql backup”, and I got many result, and I tried this one, it works.
reference links,
- How to: Backup MySQL database & email results using PHP
- How to: Backup MySQL database & email results using BASH