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
