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:\wamp\mysql\data\, 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