SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:33 PM
| ||||
| ||||
 Moving DB to another System 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      |
|
02-27-2008, 09:33 PM
| |||
| |||
| Re: Moving DB to another System 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 |
|
02-27-2008, 09:33 PM
| |||
| |||
| Re: Moving DB to another System 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 <Ow.Mun.Heng@wdc.com> 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 <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 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=r...ileo@gmail.com > > |
|
02-27-2008, 09:33 PM
| ||||
| ||||
| Re: Moving DB to another System 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 the server, copy the innodb tablespace files and logfiles to > the new location > Option 1 will be too load intensive I guess :-) Option 2, while good, there isn't a need for. Option 3, NOW you're talking. So.. just to be clear, the files I would need to copy is... /mysql/TEST_TABLE -> db.opt -- > *.ibd -- > *.frm /mysql/ib_logfile0 /mysql/ib_logfile1 /mysql/ibdata1 I use innodb_file_per_table = 1 Thanks > Option 3 is probably what you want to do. > > greets > Rocco > > On 10/13/06, Ow Mun Heng <Ow.Mun.Heng@wdc.com> 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 <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 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=r...ileo@gmail.com > > |
Linear Mode
