Many thanks for this plugin.
The conversion plugin at
To make it super easy for you:
Download my plugin from
http://cagewebdev.com/rvg-innodb-myisam/rvg-innodb-myisam.zip
Install it and run it.
Good luck!
Rolf
is — 404
however opening a page with the code at this link (also by this plugin’s author) http://web20bp.com/kb/author/webtwoze_kb/
works
BUT
do change line 11 from
mysql_select_db ($sv_database_name);
to
mysql_select_db ($sv_db_name);
This works with single and multisite.
there is also another link to the plugin on that page
Is this a good thing to do ?
If so, why ?
Plugin Contributor
cageehv
(@cageehv)
Hey valuser,
Yes, the $sv_database_name was a typo…
And yes again, I moved the plugin from cagewebdev.com to my CAGE knowledge base (http://web20bp.com/kb/)
So, you can download it now from:
http://web20bp.com/kb/wp-content/uploads/2015/09/rvg-innodb-myisam.zip
It’s just a quick and dirty plugin I wrote for my own convenience. It hasn’t been officially released.
Enjoy!
Rolf
Again many many thanks!
Just a tiny query ?
Changing all the tables to MyISAM ? Are there disadvantages as compared to InnoDB ?
Plugin Contributor
cageehv
(@cageehv)
Forget all this php crap. The risk of breakage is higher due to the two extra layers that may fail (php and web server).
The command (in Linux) is:
To MyISAM:
D=voksenbasen; for t in $(mysql $D -B -e ‘SHOW TABLES’); do mysql $D -e “ALTER TABLE $t ENGINE=MyISAM”; done
To InnoDB:
D=voksenbasen; for t in $(mysql $D -B -e ‘SHOW TABLES’); do mysql $D -e “ALTER TABLE $t ENGINE=InnoDB”; done
