It is very easier with mysql replication concipt, this automatic
replication from Master server to Slave server and real time. I wonder
how you do not know about this.
http://dev.mysql.com/doc/mysql/en/replication.html
Love kumar ..
[EMAIL PROTECTED] wrote:
SQLyog Enterprise's Database Sync Tool is the answer
for your queries.
www.webyog.com
Rgds,
Karam
--- Paul Godard <[EMAIL PROTECTED]> wrote:
> Hi
>
> I use mysql/php on several client web sites (each
> client has its own
> db). For development purpose, I have a local web
> server with
> php/mysql. When a web site is still in development,
> this is the
> master db, even if a copy has been uploaded on the
> live web server at
> my isp. When a site is completed, the web db
> becomes the master (as
> clients and visitors are updating data on the web
> db).
>
> My problem is that I would like to keep the local db
> synchronized
> with the web db (at least for the tables that are
> regularly updated
> on the web). Manually I would do a dump (data
> export only) of these
> web tables onto a local file, then empty the local
> equivalent tables
> and then running the sql statements of the dump file
> (insert).
>
> I don't do a systematic download of the whole web db
> as it is
> sometimes too big and besides not all the tables are
> updated by the
> client/visitors.
>
> My idea is to dynamically build a mysql script via
> php that can do
> the job for each client web sites for each of the
> tables contained in
> an array and be executed from a simple click on a
> button on the local
> server of course.
>
> As I am not a mysql/php guru, I would appreciate
> suggestions to do
> this as simple as possible.
>
> Please copy the reply to my email address. Thanks
> in advance.
> --
>
> Kind regards, Paul.
>
> Gondwana
> [EMAIL PROTECTED]
> http://www.gondwanastudio.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
The information transmitted is intended only for the person or entity
to whom it is addressed and may contain confidential and / or
privileged Material. Any review, re-transmission, dissemination or
other use of or taking of any action in reliance upon, this
information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the
sender and delete the material from your computer. Thank you for your
understanding & co-operation.
