not sure about the Linux guys, but if you're using Windows just copy the directory for your database (in the mysql\data directory) to the new server.
Restart MySQL Server on new machine Cheers Dave -----Original Message----- From: Jack [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 10:05 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: How to Load a Database to other Server Dear all I had a mysql Database in one of my Server, now i want to transfer this whole Database to another Server, what should i do? 1. How i can export this Database to a file 2. How i can Load this File into my another Server which create a database exactly same as the old Server? Thx a lot! Jack [EMAIL PROTECTED] --------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. --------------------------------------------------------------------- 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