MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

Re: Backup one of the sections in innodb table
Posted by: Rick James
Date: February 24, 2011 08:59AM

A possibility... (Caveat: I have no first-hand knowledge whether this will work!)
http://dev.mysql.com/doc/refman/5.1/en/alter-table.html
1. Copy the .ibd file of the partition you are getting rid of to somewhere.
2. DISCARD TABLESPACE
3. REORGANIZE -- to deal with the now-missing partition.
4. REORGANIZE and IMPORT TABLESPACE -- move the .ibd file into another, similarly declared, TABLE.

As I read the docs, that should be an efficient way to move partition(s) from one table to another.

Note: DISCARD and IMPORT are required because of ids buried in ibdata1 that deal with partitions. (Or something like that.)

Please let us know if this works.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Backup one of the sections in innodb table
4272
Pavel Dobryakov
February 09, 2011 06:37AM
Re: Backup one of the sections in innodb table
1460
Dave Walker
February 09, 2011 02:36PM
Re: Backup one of the sections in innodb table
1355
Pavel Dobryakov
February 10, 2011 12:45AM
Re: Backup one of the sections in innodb table
1421
Pavel Dobryakov
February 10, 2011 07:29AM
Re: Backup one of the sections in innodb table
1502
Rick James
February 22, 2011 03:53PM
Re: Backup one of the sections in innodb table
1877
Pavel Dobryakov
February 24, 2011 04:11AM
Re: Backup one of the sections in innodb table
1916
Rick James
February 24, 2011 08:59AM
Re: Backup one of the sections in innodb table
1378
Pavel Dobryakov
February 24, 2011 09:02AM
Re: Backup one of the sections in innodb table
1478
Rick James
February 24, 2011 08:58PM
Re: Backup one of the sections in innodb table
1469
Pavel Dobryakov
February 25, 2011 12:16AM
Re: Backup one of the sections in innodb table
1482
Rick James
February 25, 2011 07:45AM
Re: Backup one of the sections in innodb table
1301
Pavel Dobryakov
February 25, 2011 07:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.