re: Re: Moving a database accross a platform

2002-12-29 Thread Victoria Reznichenko
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

Re: Moving a database accross a platform

2002-12-28 Thread Andreas
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

Moving a database accross a platform

2002-12-27 Thread Chimpy
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

Re: Moving a database accross a platform

2002-12-27 Thread Benjamin Pflugmann
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