This blog has some error last week. Some pages were not build correctly.
I diagnosed it and found the template was broken. A bunch of codes were missing.
I want to find the backup of MySQL database.
Go to Dreamhost Web Panel > Goodies > Manage MySQL
Next to the database name, there are four links. One of them is Restore DB.
dh_mysql

Click Restore DB, and go the following page.
dh_restore_db


So, I saw last six days backups of MySQL database. When I restore I can choose which backup I like and which table I want and the restored table(s) new name.
After restore it. I go to the PhpMyAdmin tool provided by Dreamhost.
It is easy to use the PhpMyAdmin. I copy the content of template backup to replace the current corrupted one. Then rebuild the whole site. Everything comes back.
Thanks to Dreamhost automatic database backup.

facebookShare on Facebook
TwitterTweet

Related posts:

Install MovableType 4 on Dreamhost 503 error when save MT template at Dreamhost Upgrade my blog from Movable Type 4.01a to MovableType 4.1 on Dreamhost Server Upgrade and Database moveing Schedule Backup MySQL database and FTP offsite in Centos Large mySQL database transferring Solution of Dreamhost memory limitation

David Yin

David is a blogger, geek, and web developer — founder of FreeInOutBoard.com. If you like his post, you can say thank you here

Leave a Reply

Your email address will not be published. Required fields are marked *