List:General Discussion« Previous MessageNext Message »
From:Todd Lyons Date:July 16 2009 9:52pm
Subject:Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data
offline
View as plain text  
On Wed, Jul 15, 2009 at 11:58 AM, mos<mos99@stripped> wrote:
>> I have backup all the database files(innodb engine).
>> Now I want to recover it as myisam engine offline.
>> Any suggestions?
>
> Why can't you copy the InnoDb files to another machine and open the database
> with another MySQL server? (You could do it on your current server but it
> will be CPU & disk intensive).
>
>  Then do a:
> create table MyTable1 engine=MYISAM select * from InnoTable1;
>
> If these tables are large, then you could use:
> create table MyTable1 engine=MYISAM select * from InnoTable1 limit 0;
> insert into MyTable1 select * from InnoTable1 limit 0,100000;
> insert into MyTable1 select * from InnoTable1 limit 100000,100000;
> to import just 100k rows at a time.
> Now build the indexes for MyTable1.

Could do it easier I would think:
ALTER TABLE t1 ENGINE = MyISAM

Repeat for each table.  Script it if it's more than a few tables.
Note that foreign keys will break if your InnoDB table uses them.

--
Regards...      Todd
Thread
Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offlineTodd Lyons17 Jul
  • Re: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files tomyisam data offlinemos17 Jul