Re: Synchronize MYSQL
| From: | Jim McNeely | Date: | Fri, 20 Jun 2003 16:09:00 +0000 |
| Subject: | Re: Synchronize MYSQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-152316@lists.php.net to get a copy of this message | ||
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 creates the db, the second dumps the data to it. You can also take the update log which records deletes, inserts, updates, etc. as SQL statements, and pipe those to another MySQL server in a similar manner.
HTH
Jim McNeely
Envision Data
Custom, intuitive, practical software for your business.
jim@envisiondata.com
http://www.envisiondata.com
On Friday, June 20, 2003, at 07:00 AM, John W. Holmes wrote:
khuram noman wrote:Dear Members How to Synchronize two MYSQL databases in php Thanks khuram nomanDon'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 Professionals – www.phparch.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php