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

[Alex Hempton-Smith]

Thanks, I added my IP to the list of allowed hosts in the Dreamhost mySQL
admin.
:)

-- Alex


On Sat, Nov 29, 2008 at 2:55 PM, Viper007Bond <viper at viper007bond.com>wrote:

> 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/
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>