Posted by Martin Mandl - m2m tech support on 03/19/07 09:07

On Mar 19, 5:22 am, Man-wai Chang <toylet.toy...@gmail.com> wrote:
> > Why are you asking this in a PHP newsgroup? It has nothing at all to do
> > with PHP.
>
> What's wrong about using PHP to mirror a MySQL table? :)
>
> --
> iTech Consulting Services Limited
> Expert of ePOS solutions
> Website:http://www.itech.com.hk(IE only)
> Tel: (852)2325 3883 Fax: (852)2325 8288

Dear Man-Wai,

I guess it would be much slower than using the MySQL functionality
(e.g. mysqldump) directly. With php you would have to lock your host
database, dump the data, unlock the host database, lock the slave
database, upload the data, unlock the slave database ... MySQL has
even some functions toee directly synchronize host & slave without
having to generate the dump ...

Good luck
Martin


------------------------------------------------
online accounting on bash bases
Online Einnahmen-Ausgaben-Rechnung
http://www.ea-geier.at
------------------------------------------------
m2m server software gmbh
http://www.m2m.at

• Next in forum: Re: Kind of projects to develop in php.
• Prev in forum: Re: Retrieving MySQL server's port value with PHP
• Thread view: Re: How to mirror MySQL database on two servers with PHP?

[Reply to this message]