Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 10:33 pm EDT

Geeklog Forums

undo toinnodb conversion


geeklog-fan

Anonymous
Hi,

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

Thx
 Quote

Status: offline

Dirk

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
 Quote

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

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content