Mirroring database

Unlimited Shared hosting & Unlimited Disk Space from $5.95 - Dreamhost
Solid Managed VPS with 4 IP's from $60 - Liquid Web
Lightning Fast Dedicated Servers & 1GB RAM from $149 - Liquid Web
#1 Domain Registration with WHOIS Privacy - Just $9.95

This Dreamhost support thread was started by dandies on 2009-07-22 20:27:24:

Post Reply? Hi All, I want to mirorring my mysql database on dreamhost with my local server, so my client cant access locally (wich is fast) and online (public can access too). I have plan to use rsync to do that. The problem is: 1. I know that in my local server (using xp pro sp2 with wamp server) database was saved in c:wampmysqldata, but I dont know where dreamhost saved my database. 2. Im not sure if I have access permission to my database directory to access with my rsync command. 3. kchrist have other solution to this, below is his post, ===== Posted by: kchrist Posted on: 2005-09-12 09:19:00 There’s no need to delete the database; look into mysqldump and mysqlimport. A two-line shell script that dumps one and imports it into the other, run from cron, would do the trick. PHP seems like a strange choice of languages for something like this. ===== but I think that with rsync capabilities (only download any newer or changed files from the server) rsync will do the mirroring faster. Anyone can help? ps: Im sorry 4 my bad English, Im from Indonesia

Join in on the original post at the Dreamhost Forum, Get a Dreamhost Plan or view our Dream Host Review.