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