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 location Option 3 is probably what you want to do. greets Rocco On 10/13/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
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 <[EMAIL PROTECTED]> > > 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
