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
What platform (Win32, Linux, BSD, etc.) are you using?
If you have Win32 machine in the mix (doesn't need to be a server), suggest
you use the Export tool in MySQL-Front (http://www.anse.de/mysqlfront/).
We've replicated databases from Win32 to Linux and Linux to Linux with it
many times.
Gerald
On Thu, 16 May 2002 17:05:25 +0800
"Jack" <[EMAIL PROTECTED]> wrote:
> 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
If your DB server (source) is not runni
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: [