[wp-hackers] Keep local DB in sync with remote DB
hempsworth at googlemail.com
Sat Nov 29 15:06:11 GMT 2008
Would I be able to define the wordpress URL and the blog URL from inside the
I want an if statement that could recognize I'm accessing the site from
localhost, and then define those URLs as 'localhost', at the moment I can't
login because WP is obviously sending me to the URLs from inside the DB,
mydomain.com instead of localhost.
On Sat, Nov 29, 2008 at 3:01 PM, Alex Hempton-Smith <
hempsworth at googlemail.com> wrote:
> Thanks, I added my IP to the list of allowed hosts in the Dreamhost mySQL
> -- 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
>> 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
>> > 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
More information about the wp-hackers