From: Todd Lyons
Date: July 16 2009 9:52pm
Subject: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data 
	offline
List-Archive: http://lists.mysql.com/mysql/218225
Message-Id: <48b1344b0907161452r30d7c917q8512c00a33eee2a1@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 datab=
ase
> with another MySQL server? (You could do it on your current server but it
> will be CPU & disk intensive).
>
> =A0Then do a:
> create table MyTable1 engine=3DMYISAM select * from InnoTable1;
>
> If these tables are large, then you could use:
> create table MyTable1 engine=3DMYISAM 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 =3D MyISAM

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

--
Regards... =A0 =A0 =A0Todd