don't forget to check the grant's!

-----Original Message-----
From: Dave Watkinson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 12:32 PM
To: Jack; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: How to Load a Database to other Server


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.


---------------------------------------------------------------------
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

Reply via email to