views:

30

answers:

1

How it is possible to update localhost MySql database with server mysql database at particular interval. Web application is made in PHP and database should be in MySql.

Suppose I have a Database at Hosting site Now i want to update my database at regular interval with Local Host Database at my Local Computer.Please suggest me ??

+2  A: 

Sounds like you need to use MySQL's replication feature. Here's a walkthrough and here's the manual for reference.

It's worth noting that replication over the internet (rather than a local network) can be slow and you can end up with a slave that's minutes, even hours behind a busy master. Another option could be to periodically mysqldump the master database and copy it back to your local machine, although if your master is very busy you'll lock databases and hang queries, and if it's very large this process will take a long time.

Andy