> -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
Also, in the my.cnf, look to see if any datafiles are specified. If so,
you need to move those files, plus the log files to the new server.
David
Mark Pittam wrote:
-Original Message-
From: David Barron [mailto:[EMAIL PROTECTED]
Sent: 06 August 2004 14:56
To: [EMAIL PROTECTED]
Subject: Mov
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
Good morning,
What's the best way to move a database and all of its tables from one server to
another?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, 24 Sep 2003 09:14:33 EDT
[EMAIL PROTECTED] wrote:
> Has anyone ever had to move a database from one machine to another? I tried
> to just copy all the files from /var/lib/mysql/db1 to another machine into
> /var/lib/mysql/db2. Although I can see the tables using SHOW TABLES, I get an
Has anyone ever had to move a database from one machine to another? I tried
to just copy all the files from /var/lib/mysql/db1 to another machine into
/var/lib/mysql/db2. Although I can see the tables using SHOW TABLES, I get an
error 13 trying to access or repair them.
Is it possible to move
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.
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
11 matches
Mail list logo
