[PHP] Synchronize MYSQL

2003-06-20 Thread khuram noman
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.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] Synchronize MYSQL

2003-06-20 Thread John W. Holmes
khuram noman wrote: Dear Members How to Synchronize two MYSQL databases in php Thanks khuram noman Don't use PHP, just use the replication that's already built into MySQL. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ PHP|Architect: A magazine for PHP

Re: [PHP] Synchronize MYSQL

2003-06-20 Thread Jim McNeely
From Paul Dubois's MySQL book: If you are dumping a database so that you can transfer the database to another server: (on the unix command line or in a shell script) % mysqladmin -h boa.snake.net create samp_db % mysqldump samp_db | mysql -h boa.snake.net samp_db the first command obviously