InnoDB 2 MyISAM PHP

Display error is on for us to be notified if there ' s something wrong ini_set ( ' display_errors ', ' on ' ); Error_reporting (E_all); Config, change this variables $dbServer = "localhost"; $dbUser = "account number"; $dbPass = "Password"; $dbName = $_get[' dbName '); Set a connection for our database $link = mysql_connect ($dbServer, $dbUser, $dbPass) or die ( "Unable to connect to mSQL server:" . Mysql_error ()); Select our Database mysql_select_db ($dbName, $link) or die ( "Unable to select database ' db ':" . Mysql_error ()); $result = mysql_query ( "Show Tables" ); if (! $result) { die ( ' query failed: ' ); } Use and loop to convert all tables to MyISAM while ( $row = mysql_fetch_array ($result) ) { /Command reference:alter TABLE tableName Engine=myisam echo "ALTER TABLE" . $row [0]. "ENGINE=MYISAM; ".' '; Mysql_query ( "ALTER TABLE") . $row [0]. "ENGINE=MYISAM; " ); } ?> Invoke page Display error is on for us to be notified if there ' s something wrong ini_set ( ' display_errors ', ' on ' ); Error_reporting (E_all); Config, change this variables $dbServer = "localhost"; $dbUser = "account number"; $dbPass = "Password"; Set a connection for our database $link = mysql_connect ($dbServer, $dbUser, $dbPass) or die ( "Unable to connect to mSQL server:" . Mysql_error ()); $result = mysql_query ( "show databases;" ); if (! $result) { die ( ' query failed: ' ); } Use and loop to convert all tables to MyISAM while ( $row = mysql_fetch_array ($result) ) { echo '. $row [0]. ' " > '. $row [0].' '; } ?> Display error is on for us to be notified if there ' s something wrong Ini_set (' display_errors ', ' on '); Error_reporting (E_all); Config, change this variables $dbServer = "localhost"; $dbUser = "account Number"; $dbPass = "password"; $dbName = $_get[' dbName '); Set a connection for our database $link = mysql_connect ($dbServer, $dbUser, $dbPass) or die ("Unable to connect to mSQL server:". Mysql_error ()); Select our Database mysql_select_db ($dbName, $link) or die ("Unable to select database ' db ':". Mysql_error ()); $result = mysql_query ("Show Tables"); if (! $result) { Die (' Query failed: '); } Use and loop to convert all tables to MyISAM while ($row = Mysql_fetch_array ($result)) { Command reference:alter TABLE tableName Engine=myisam echo "ALTER TABLE". $row [0]. "Engine=myisam;". '; mysql_query ("ALTER TABLE"). $row [0]. "ENGINE=MYISAM;"); } ?> Invoke page Display error is on for us to be notified if there ' s something wrong Ini_set (' display_errors ', ' on '); Error_reporting (E_all); Config, change this variables $dbServer = "localhost"; $dbUser = "account Number"; $dbPass = "password"; Set a connection for our database $link = mysql_connect ($dbServer, $dbUser, $dbPass) or die ("Unable to connect to mSQL server:". Mysql_error ()); $result = mysql_query ("show databases;"); if (! $result) { Die (' Query failed: '); } Use and loop to convert all tables to MyISAM while ($row = Mysql_fetch_array ($result)) { Echo '. $row [0]. ' '; } ?> Copy Code

