On Mon, 8 Jul 2002 [EMAIL PROTECTED] wrote:
> Todd Cary writes:
>
> > Is there a quick and simple way to move a MySQL DB from one server to another
> > MySQL server? Can I just copy the tables?
> >
>
> for as far i know, you can just copy the directory ( DB ) from one server to
> the other.
> i've done it a couple times. and it stil works :)
I use mysqldump to create dumps of all the databases/tables, ftp or sftp
them to the other server, create new databases there using mysqladmin and
then pipe the dump into mysql, eg:
cat database.dump | mysql -u root -pxxxx database
Andy
---------------------------------------------------------------------
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