Title: innoDB
Last modified: August 30, 2016

---

# innoDB

 *  Resolved [mrppp](https://wordpress.org/support/users/mrppp/)
 * (@mrppp)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/innodb-2/)
 * If i want to change my tables to myisam from innoDB, can i go into phpmyadmin,
   then from operations just change it there?
    Does it matter what the Collation
   field has in it?
 * [https://wordpress.org/plugins/rvg-optimize-database/](https://wordpress.org/plugins/rvg-optimize-database/)

Viewing 15 replies - 1 through 15 (of 22 total)

1 [2](https://wordpress.org/support/topic/innodb-2/page/2/?output_format=md) [→](https://wordpress.org/support/topic/innodb-2/page/2/?output_format=md)

 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619620)
 * Hey Mrppp,
 * Save the following script as a .php file and open it on your website (first fill
   in your db credentials!):
 *     ```
       <?php
       	// CREATE SCRIPT TO CONVERT ALL INNODB TABLES TO MYISAM
               // Connect your database here first
       	$sv_db_host     = '';
       	$sv_db_user     = '';
       	$sv_db_password = '';
       	$sv_db_name     = '';
   
       	$connect =
               mysql_connect($sv_db_host,$sv_db_user,$sv_db_password);
       	mysql_select_db ($sv_database_name);
   
           $sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
               WHERE TABLE_SCHEMA = '".$sv_db_name."'
               AND ENGINE = 'INNODB'";
   
           $rs = mysql_query($sql);
   
           while($row = mysql_fetch_array($rs))
           {
               $tbl = $row[0];
       	echo "ALTER TABLE <code>$tbl</code> ENGINE=MyISAM;<br />";
           }
       ?>
       ```
   
 * This will generate SQL statements for changing all the InnoDB tables to MyISAM.
 * Execute the SQL statements in PHPMyAdmin and you’re done!
 * peace,
    Rolf
 *  Thread Starter [mrppp](https://wordpress.org/support/users/mrppp/)
 * (@mrppp)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619634)
 * Thank you!
    So for instance **ALTER TABLE wp_cptch_whitelist ENGINE=MyISAM;**
   run in **Run SQL query/queries on database**
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619637)
 * Hey Mrppp,
 * You can just copy the whole list of statements into the PHPMySQL SQL box and 
   run them all with one click 😉
 * Good luck!
    Rolf
 *  Thread Starter [mrppp](https://wordpress.org/support/users/mrppp/)
 * (@mrppp)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619644)
 * Excellent
    thank you
 *  [ufferichter](https://wordpress.org/support/users/ufferichter/)
 * (@ufferichter)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619873)
 * Here the result but still the same
 * ALTER TABLE wp_bwg_album ENGINE=MyISAM;
    ALTER TABLE wp_bwg_album_gallery ENGINE
   =MyISAM; ALTER TABLE wp_bwg_gallery ENGINE=MyISAM; ALTER TABLE wp_bwg_image ENGINE
   =MyISAM; ALTER TABLE wp_bwg_image_comment ENGINE=MyISAM; ALTER TABLE wp_bwg_image_rate
   ENGINE=MyISAM; ALTER TABLE wp_bwg_image_tag ENGINE=MyISAM; ALTER TABLE wp_bwg_option
   ENGINE=MyISAM; ALTER TABLE wp_bwg_shortcode ENGINE=MyISAM; ALTER TABLE wp_bwg_theme
   ENGINE=MyISAM; ALTER TABLE wp_commentmeta ENGINE=MyISAM; ALTER TABLE wp_comments
   ENGINE=MyISAM; ALTER TABLE wp_links ENGINE=MyISAM; ALTER TABLE wp_options ENGINE
   =MyISAM; ALTER TABLE wp_postmeta ENGINE=MyISAM; ALTER TABLE wp_posts ENGINE=MyISAM;
   ALTER TABLE wp_term_relationships ENGINE=MyISAM; ALTER TABLE wp_term_taxonomy
   ENGINE=MyISAM; ALTER TABLE wp_terms ENGINE=MyISAM; ALTER TABLE wp_usermeta ENGINE
   =MyISAM; ALTER TABLE wp_users ENGINE=MyISAM; ALTER TABLE wp_wfBadLeechers ENGINE
   =MyISAM; ALTER TABLE wp_wfBlockedIPLog ENGINE=MyISAM; ALTER TABLE wp_wfBlocks
   ENGINE=MyISAM; ALTER TABLE wp_wfBlocksAdv ENGINE=MyISAM; ALTER TABLE wp_wfConfig
   ENGINE=MyISAM; ALTER TABLE wp_wfCrawlers ENGINE=MyISAM; ALTER TABLE wp_wfFileMods
   ENGINE=MyISAM; ALTER TABLE wp_wfHits ENGINE=MyISAM; ALTER TABLE wp_wfHoover ENGINE
   =MyISAM; ALTER TABLE wp_wfIssues ENGINE=MyISAM; ALTER TABLE wp_wfLeechers ENGINE
   =MyISAM; ALTER TABLE wp_wfLockedOut ENGINE=MyISAM; ALTER TABLE wp_wfLocs ENGINE
   =MyISAM; ALTER TABLE wp_wfLogins ENGINE=MyISAM; ALTER TABLE wp_wfNet404s ENGINE
   =MyISAM; ALTER TABLE wp_wfReverseCache ENGINE=MyISAM; ALTER TABLE wp_wfScanners
   ENGINE=MyISAM; ALTER TABLE wp_wfStatus ENGINE=MyISAM; ALTER TABLE wp_wfThrottleLog
   ENGINE=MyISAM; ALTER TABLE wp_wfVulnScanners ENGINE=MyISAM;
 *  [ufferichter](https://wordpress.org/support/users/ufferichter/)
 * (@ufferichter)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619874)
 * no here
 * Fejl
 * Der ser ud til at være en fejl i din SQL-forespørgsel. MySQL-serverens fejlmelding
   der følger herunder, hvis der er nogen, kan også hjælpe dig med at finde problemet
 * ERROR: Ukendt tegnsætnings-streng @ 1
    STR: <? SQL: <?php // CREATE SCRIPT TO
   CONVERT ALL INNODB TABLES TO MYISAM // Connect your database here first $sv_db_host
   = ‘localhost’;
 * SQL-forespørgsel:
 * <?php // CREATE SCRIPT TO CONVERT ALL INNODB TABLES TO MYISAM // Connect your
   database here first $sv_db_host = ‘localhost’;
 * MySQL returnerede: Dokumentation
    #1064 – You have an error in your SQL syntax;
   check the manual that corresponds to your MySQL server version for the right 
   syntax to use near ‘<?php // CREATE SCRIPT TO CONVERT ALL INNODB TABLES TO MYISAM//
   Connec’ at line 1
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619875)
 * Hey Uffe,
 * Okay, fine so far 😉
 * – Open PHPMyAdmin
    – Select your database – Click on the SQL tab (second tab 
   from the left) – Copy and paste the ALTER TABLE statements in the input box –
   Click ‘Go’
 * Good luck!
 * Rolf
 *  [ufferichter](https://wordpress.org/support/users/ufferichter/)
 * (@ufferichter)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619876)
 * Hi Again
 * I got this error when i do this
 * Fejl
 * Der ser ud til at være en fejl i din SQL-forespørgsel. MySQL-serverens fejlmelding
   der følger herunder, hvis der er nogen, kan også hjælpe dig med at finde problemet
 * ERROR: Ukendt tegnsætnings-streng @ 1
    STR: <? SQL: <?php // CREATE SCRIPT TO
   CONVERT ALL INNODB TABLES TO MYISAM // Connect your database here first $sv_db_host
   = ‘localhost’;
 * SQL-forespørgsel:
 * <?php // CREATE SCRIPT TO CONVERT ALL INNODB TABLES TO MYISAM // Connect your
   database here first $sv_db_host = ‘localhost’;
 * MySQL returnerede: Dokumentation
    #1064 – You have an error in your SQL syntax;
   check the manual that corresponds to your MySQL server version for the right 
   syntax to use near ‘<?php // CREATE SCRIPT TO CONVERT ALL INNODB TABLES TO MYISAM//
   Connec’ at line 1
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619877)
 * Hey Uffe,
 * Sounds like you are trying to paste .php code into a MySQL query…
    That won’t
   work.
 * To make it super easy for you:
    Download my plugin from [http://cagewebdev.com/rvg-innodb-myisam/rvg-innodb-myisam.zip](http://cagewebdev.com/rvg-innodb-myisam/rvg-innodb-myisam.zip)
   Install it and run it.
 * Good luck!
 * Rolf
 *  [ufferichter](https://wordpress.org/support/users/ufferichter/)
 * (@ufferichter)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619878)
 * Hi Rolf
 * I dont know what i am doing wrong
 * [http://puresteel.dk/rvg-innodb-myisam.php](http://puresteel.dk/rvg-innodb-myisam.php)
 * try and see
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619879)
 * No, no, no 😉
 * Go to your WP admin panel.
    Go to the plugins page. Click ‘add new’. Click ‘upload
   plugin’ Choose the rvg-innodb-myisam.zip file on your local computer… Activate
   plugin (after uploading). Go to ‘tools’ and click ‘InnoDB from / to MyISAM’ Click
   the ‘InnoDB to MyISAM’ button. DONE!
 * Rolf
 *  [ufferichter](https://wordpress.org/support/users/ufferichter/)
 * (@ufferichter)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619880)
 * Hi Rolf My Man
 * You are 100 % Super, thanks alot from, little me in Denmark…
 * I love your plugin
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619881)
 * Hej Uffe,
 * You already owed me a beer in Copenhagen, so make it TWO or THREE or MORE 😉
 * Glad I could help you.
 * Rolf
 *  [ufferichter](https://wordpress.org/support/users/ufferichter/)
 * (@ufferichter)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619882)
 * Hi Rolf
 * I totally forgot that, i think we have a hold boks of beer of Denamrks best quality……
 * I did give you some stars, i am not sure if i give them to you before…,
 * Thanks again
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/innodb-2/#post-6619883)
 * Thanks for the stars (and no you didn’t give them before, because you only can
   rate the same plugin once ;-))

Viewing 15 replies - 1 through 15 (of 22 total)

1 [2](https://wordpress.org/support/topic/innodb-2/page/2/?output_format=md) [→](https://wordpress.org/support/topic/innodb-2/page/2/?output_format=md)

The topic ‘innoDB’ is closed to new replies.

 * ![](https://ps.w.org/rvg-optimize-database/assets/icon-256x256.png?rev=3350597)
 * [Optimize Database after Deleting Revisions](https://wordpress.org/plugins/rvg-optimize-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/rvg-optimize-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/rvg-optimize-database/)
 * [Active Topics](https://wordpress.org/support/plugin/rvg-optimize-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/rvg-optimize-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/rvg-optimize-database/reviews/)

 * 22 replies
 * 5 participants
 * Last reply from: [cageehv](https://wordpress.org/support/users/cageehv/)
 * Last activity: [10 years, 1 month ago](https://wordpress.org/support/topic/innodb-2/page/2/#post-6619941)
 * Status: resolved