Swati, You can also use mysqldump to be part of the mechanism to move the database(s) from one computer to another. Something like:
Prompt> mysqldump --add-drop-table databasename -uuserid -ppassword | mysql --host=your.new.host.IP databasename -uuserid -ppassword -----Original Message----- From: Swati K [mailto:[EMAIL PROTECTED] Sent: Saturday, November 15, 2003 5:41 AM To: [EMAIL PROTECTED] Subject: Database Dump Hi All I have just started working on MYSQL. Can ne one help on How to take a database Backup? and how does one transfer the MYSQL database from one Comp to another one? Regards Swati kalia http://www.mecklai.com where risk meets its match *************************************** This message is intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]