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
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:
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 running ...
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.