MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Gavin Towey Date:July 15 2009 8:16pm
Subject:RE: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to
myisam data offline
View as plain text  
Or you could just do an export with
mysqldump --single-transaction > backup.sql

Then replace all the ENGINE=InnoDB with ENGINE=MyIsam in the .sql file.

-----Original Message-----
From: mos [mailto:mos99@stripped]
Sent: Wednesday, July 15, 2009 11:58 AM
To: mysql@stripped
Subject: Re: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline

At 07:53 AM 7/15/2009, you wrote:
>hi all,
>
>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.

Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


The information contained in this transmission may contain privileged and confidential
information. It is intended only for the use of the person(s) named above. If you are not
the intended recipient, you are hereby notified that any review, dissemination,
distribution or duplication of this communication is strictly prohibited. If you are not
the intended recipient, please contact the sender by reply email and destroy all copies of
the original message.
Thread
Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offlineOscar15 Jul
  • Re: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files tomyisam data offlinemos15 Jul
    • RE: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files tomyisam data offlineGavin Towey15 Jul