Benjamin Pflugmann wrote:
Look up mysqldump and mysql in the manual. You want to do something
like this:
targethost$ mysqladmin create new_database
targethost$ mysqldump -h oldhost some_database | mysql new_database
at least if he hasn't used innodb with foreign keys
AFAIK mysqldump is not clever enough to dump the tables in the right
order so that referential integrity doesn't stop the reimport of the data
or maybe I'm to stupid to make it do it the right way
---------------------------------------------------------------------
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
