innoDB

Many thanks for this plugin.

The conversion plugin at

To make it super easy for you:
Download my plugin from
https://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) https://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 ?

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 (https://web20bp.com/kb/)

So, you can download it now from:
https://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 ?

Hey valuser,

You can read the details here:
https://www.rackspace.com/knowledge_center/article/mysql-engines-myisam-vs-innodb

peace,
Rolf

Thanks again!

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

Thanks ppehrson!