innoDB

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

Thank you!
So for instance ALTER TABLE wp_cptch_whitelist ENGINE=MyISAM;
run in Run SQL query/queries on database

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

Excellent
thank you

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;

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

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

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

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
https://cagewebdev.com/rvg-innodb-myisam/rvg-innodb-myisam.zip
Install it and run it.

Good luck!

Rolf

Hi Rolf

I dont know what i am doing wrong

https://puresteel.dk/rvg-innodb-myisam.php

try and see

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

Hi Rolf My Man

You are 100 % Super, thanks alot from, little me in Denmark…

I love your plugin

Hej Uffe,

You already owed me a beer in Copenhagen, so make it TWO or THREE or MORE ??

Glad I could help you.

Rolf

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

Thanks for the stars (and no you didn’t give them before, because you only can rate the same plugin once ;-))