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 <[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: [email protected]
> > > 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]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
