Welcome to Geeklog, Anonymous Monday, October 14 2024 @ 10:31 pm EDT

Geeklog Forums

undo toinnodb conversion

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

Anonymous

Hi,

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

Thx

6 6 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

4 7 Quote

All times are EDT. The time is now 10:31 pm.