> -Original Message-
> From: David Barron [mailto:[EMAIL PROTECTED]
> Sent: 06 August 2004 17:10
> To: Mark Pittam; [EMAIL PROTECTED]
> Subject: RE: Moving a database
>
> How do I recreate the database on the new server? Do I have to
recreate
> each table aga
Don't forget to copy the my.cnf file, and make any changes neccesary
(due to different directory/disk structures).
If you are using InnoDB, and can shut down the database, you should just
be able to move the files in
data/ or var/
like Mark said below (InnoDB stores files there as well).
Also,
IL PROTECTED]
> Subject: RE: Moving a database
>
> > -Original Message-
> > From: David Barron [mailto:[EMAIL PROTECTED]
> > Sent: 06 August 2004 14:56
> > To: [EMAIL PROTECTED]
> > Subject: Moving a database
> >
> > Good morning,
> >
&
> -Original Message-
> From: David Barron [mailto:[EMAIL PROTECTED]
> Sent: 06 August 2004 14:56
> To: [EMAIL PROTECTED]
> Subject: Moving a database
>
> Good morning,
>
> What's the best way to move a database and all of its tables from one
> server to another?
>
> Thanks
You can use
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
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
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.
