"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. [EMAIL PROTECTED] 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 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 Professionals – www.phparch.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
