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 leas

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 cl

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.

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 th