Re: Synchronize MYSQL
| From: | Neil | Date: | Fri, 20 Jun 2003 15:04:56 +0000 |
| Subject: | Re: Synchronize MYSQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-152309@lists.php.net to get a copy of this message | ||
Khuram Noman wrote:
Dear Members How to Synchronize two MYSQL databases in php Thanks khuram noman __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.comHello as usual there are a few ways to do tackle this job. My preference is to stop mysql and use rsync to transfer the data , then restart it. Mysql4+ supports clustering also. If you do not stop mysql while u do the sync you risk a corruption of copied data. See man rsync and mysql.com for details of each way. The clustering seems like allot of work to me , it depends how up to date you need to keep Cheers Neil