On Wed, 3 Jan 2001, Edwin Linux Fan wrote:
..
> I've got this nagging question.
> I'm developing a database in one computer.
> Eventually I'll put it in the production computer.
> How do I transer a MySQL database to the OTHER computer?
> What directories should I copy?
> Can you refer me to a document for this?
> Is it safe?
assuming same block size (e.g. same filesystem) you can just copy the data
files AFTER SHUTDOWN. (oh yeah it goes without saying.. same OS)
Else, do a mysqldump (produces a text file) then pipe it thru mysql client
on the new computer to recreate everything.
--
---------------------------------------------------------------------
Orlando Andico <[EMAIL PROTECTED]> POTS Phone: +63 (2) 937-2293
Mosaic Communications, Inc. GSM Mobile: +63 (917) 531-5893
I'm not suffering from insanity -- I'm enjoying every minute of it!!
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
