5 messages in com.mysql.lists.win32Re: How to Load a Database to other S...
FromSent OnAttachments
Jack16 May 2002 02:05 
Dave Watkinson16 May 2002 02:31 
Dicky Wahyu Purnomo16 May 2002 03:10 
Gerald R. Jensen16 May 2002 04:41 
problem17 May 2002 15:02 
Subject:Re: How to Load a Database to other Server
From:Dicky Wahyu Purnomo (dick@1rstwap.com)
Date:05/16/2002 03:10:36 AM
List:com.mysql.lists.win32

On Thu, 16 May 2002 17:05:25 +0800 "Jack" <nedc@nedcor.com.hk> 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 ... you can do it with file copy way. But if you do it on a running DB server, you can use "mysqldump"

2. How i can Load this File into my another Server which create a database exactly same as the old Server?

copy to file : mysqldump -A -p > dumpfile from file to db : mysql -p < dumpfile

-- Let's call it an accidental feature. -- Larry Wall