re: Re: Moving a database accross a platform
On Sunday 29 December 2002 05:38, Andreas wrote: 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 If he used InnoDB with foreign key constraints, he can just use SET FOREIGN_KEY_CHECKS=0. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Re: Moving a database accross a platform
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
Moving a database accross a platform
I looked through the documentation, but I couldn't find anything relevant to this, so here goes... I have MySQL with databases running on a Solaris machine, and MySQL with different databases running on an Irix machine. I want to integrate some of the databases from the Solaris machine into the Irix machine (as the Solaris machine will no longer be used).. Is there any simple way to do this? - 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
Re: Moving a database accross a platform
Hi. On Fri 2002-12-27 at 17:19:26 -0800, [EMAIL PROTECTED] wrote: I looked through the documentation, but I couldn't find anything relevant to this, so here goes... I have MySQL with databases running on a Solaris machine, and MySQL with different databases running on an Irix machine. I want to integrate some of the databases from the Solaris machine into the Irix machine (as the Solaris machine will no longer be used).. Is there any simple way to do this? 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 HTH, Benjamin. -- [EMAIL PROTECTED] - 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