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"
> before you tar up the TEST_DB directory.

The tables are innodb.
I can stop the daemon before I do anything if it's needed.
I know that some other RDBMs has the feature whereby one can just copy
and attach the DB from A -> B system

>
> On Fri, Oct 13, 2006 at 12:11:24PM +0800, Ow Mun Heng wrote:
> > Subject: Moving DB to another System
> > From: Ow Mun Heng <Ow.Mun.Heng@wdc.com>
> > To: mysql@lists.mysql.com
> > Date: Fri, 13 Oct 2006 12:11:24 +0800
> > X-Mailer: Evolution 2.6.2
> >
> > Hi All,
> >
> > Wondering if it's possible for me to just tar up the DB (eg: TEST_DB)
> > and then move it AS IS to another system?
> >
> > Is this possible or will I have to do a mysqldump (inclusive of create
> > tables / data etc)??
> >
> > It would be good if I can just copy (tar) the DB to another system and
> > then re-attach the DB to the new system.
> >
> > Thanks
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=b...ngconcepts.com