Welcome to Geeklog, Anonymous Monday, October 14 2024 @ 10:31 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
I ran the toinnodb script, but is there an easy way to convert back to MyISAM?
Thx
6
6
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Untested, but if you change the line
in the script to
and run it again, it should convert everything back to MyISAM tables.
Or you could use phpMyAdmin to do it.
bye, Dirk
Text Formatted Code
DB_query ("ALTER TABLE $A[0] TYPE=InnoDB");Text Formatted Code
DB_query ("ALTER TABLE $A[0] TYPE=MyISAM");Or you could use phpMyAdmin to do it.
bye, Dirk
4
7
Quote
All times are EDT. The time is now 10:31 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