[wp-hackers] Keep local DB in sync with remote DB

Viper007Bond viper at viper007bond.com
Sat Nov 29 14:55:37 GMT 2008


99.9% of hosts block remote MySQL connections. Unless they have the option
to enable it so that you can set up a cron/scheduled task to make a copy of
your remote DB and import it into your localhost MySQL server, you're SOL.

On Sat, Nov 29, 2008 at 6:47 AM, Alex Hempton-Smith <
hempsworth at googlemail.com> wrote:

> Hi,
> I'm moving my development over to a local WAMP server, instead of uploading
> files and checking the changes every time.
> How would I keep my local mySQL database in sync with my remote mySQL
> database?
>
> The remote database is hosted at Dreamhost, so the database has a
> mysql.mydomain.com
>  address, rather than localhost, but when I use that on the local WAMP
> server it shows "Error establishing a database connection".
> Many thanks,
> Alex
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>



-- 
Viper007Bond | http://www.viper007bond.com/ | http://www.finalgear.com/


More information about the wp-hackers mailing list