Hello Ow Mun,
there are various ways to backup InnoDB tables
1. SELECT ... INTO OUTFILE statement for your tables and reimport them
2. ibbackup (a commercial tool to copy InnoDB Databases while the server is
running
3. Stop the server, copy the innodb tablespace files and logfiles to the new
loc
On Fri, 2006-10-13 at 08:22 +0200, Rocco Di Leo wrote:
> Hello Ow Mun,
>
> there are various ways to backup InnoDB tables
>
> 1. SELECT ... INTO OUTFILE statement for your tables and reimport them
> 2. ibbackup (a commercial tool to copy InnoDB Databases while the
> server is running
> 3. Stop t
On Thu, 2006-10-12 at 23:43 -0500, Brian Ivins wrote:
> If the tables are myisam (not innodb), and you're moving them to a system
> with the same or newer version of mysql,
> it should work. You have the best chance of it working if the tables aren't
> being accessed, and you do a "flush tables
Ian Sales said:
> Randy Paries wrote:
>
>>
>>The problem is I get this wonderfully verbose :-( error message
>>:::ERROR at line 362701
>>
>>
>>
>>
> - MySQL can't parse something on line 362701 of your dump file. One
> possibility is an index named with a keyword, which 3.23.x appears to
> allow bu
Randy Paries wrote:
The problem is I get this wonderfully verbose :-( error message
:::ERROR at line 362701
- MySQL can't parse something on line 362701 of your dump file. One
possibility is an index named with a keyword, which 3.23.x appears to
allow but 4.0.x doedsn't. Edit the dump file a
TECTED]
Subject: Re: moving DB from one box to another.
At 23:21 -0600 12/15/04, Randy Paries wrote:
>hello,
>I have built a new DB box.
>Orig db is mysqld Ver 3.23.58
>New DB is mysqld Ver 4.0.20
>I want to move the data from one box to another.
>I have a couple of really large tab
At 23:21 -0600 12/15/04, Randy Paries wrote:
hello,
I have built a new DB box.
Orig db is mysqld Ver 3.23.58
New DB is mysqld Ver 4.0.20
I want to move the data from one box to another.
I have a couple of really large tables with longtext fields. This data is a
bunch of HTML
My plan was to do a m
You didn't say which version of MySQL you are using, or if you are using
InnoDB tables. I'll assume you are using MyISAM tables, and are **adding** a
drive to the system.
1. Install / mount the new drive so it is available to the O/S and assign it
a drive letter.
2. Stop the MySQL Server (in DOS:
