Make sure you have MySql running on the second machine! mysqldump -h sourcehost -v -uroot --opt --compress sourcedb | mysql -h targethost -uroot -C -w sourcedbCopy
More examples in the manual... http://www.mysql.com/documentation/mysql/full/manual_toc.html#Upgrading-to-a rch http://www.mysql.com/documentation/mysql/full/manual_toc.html#Backup http://www.mysql.com/documentation/mysql/full/manual_toc.html#mysqldump -----Original Message----- From: Sai D Burra [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 4:04 PM To: Mysql list Subject: Database Transfer Hi all i have a mysql database running on linux machine..i would like to have the complete database to be transfered with all its properties and settings into another linux machine.. how can i do that.. can anyone help me... thanks in advance Sai D Burra _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php