Welcome to Geeklog, Anonymous Friday, December 06 2024 @ 05:10 am EST

Geeklog Forums

undo toinnodb conversion

01/02/05 09:38am (Read 1,450 times)

Anonymous

Hi,

I ran the toinnodb script, but is there an easy way to convert back to MyISAM?

Thx

7 7 Quote

01/02/05 01:18pm

Status: offline

Site Admin

Admin

Registered: 01/12/02

Posts: 13073

Location:Stuttgart, Germany

Untested, but if you change the line

Text Formatted Code
DB_query ("ALTER TABLE $A[0] TYPE=InnoDB");

in the script to

Text Formatted Code
DB_query ("ALTER TABLE $A[0] TYPE=MyISAM");

and run it again, it should convert everything back to MyISAM tables.

Or you could use phpMyAdmin to do it.

bye, Dirk

6 8 Quote

All times are EST. The time is now 05:10 am.