\n"; $link_id = mysql_connect($DB_HOST, $DB_USER, $DB_PASSWORD) or die('Error establishing a database connection'); echo 'Connected' ."\n"; mysql_select_db($DB_DATABASE, $link_id); echo 'Selected database' ."\n"; echo 'Getting tables:' ."\n"; $resource = mysql_query("SHOW TABLES", $link_id); while ( $result = mysql_fetch_row($resource) ) { if (in_array($result[0], $GB_TBL)) { $tables[] = $result[0]; echo ' - ' . $result[0] ."\n"; } } if ( !empty($tables) ) { echo 'Starting process' ."\n"; foreach ( (array) $tables as $table ) { echo 'Working on table "' . $table . '"'; $resource = mysql_query("EXPLAIN $table", $link_id); while ( $result = mysql_fetch_assoc($resource) ) { if ( preg_match('/(char)|(text)|(enum)|(set)/', $result['Type']) ) $tables_with_fields[$table][$result['Field']] = $result['Type'] . " " . ( "YES" == $result['Null'] ? "" : "NOT " ) . "NULL " . ( !is_null($result['Default']) ? "DEFAULT '". $result['Default'] ."'" : "" ); echo '.'; } echo "\n"; } // Change all text/string fields of the tables to their corresponding binary text/string representations. echo 'Altering tables to binary character set'; foreach ( (array) $tables as $table ) { mysql_query("ALTER TABLE $table CONVERT TO CHARACTER SET binary", $link_id); echo '.'; } echo "\n"; // Change database and tables to UTF-8 Character set. echo 'Altering tables to utf8 character set'; mysql_query("ALTER DATABASE " . $DB_DATABASE . " CHARACTER SET utf8", $link_id); foreach ( (array) $tables as $table ) { mysql_query("ALTER TABLE $table CONVERT TO CHARACTER SET utf8", $link_id); echo '.'; } echo "\n"; // Return all binary text/string fields previously changed to their original representations. echo 'Altering binary text/string fields to original representation'; foreach ( (array) $tables_with_fields as $table => $fields ) { foreach ( (array) $fields as $field_type => $field_options ) { mysql_query("ALTER TABLE $table MODIFY $field_type $field_options", $link_id); } echo '.'; } echo "\n"; // Optimize tables and finally close the mysql link. echo 'Optimizing tables' . "\n"; foreach ( (array) $tables as $table ) mysql_query("OPTIMIZE TABLE $table", $link_id); mysql_close($link_id); echo "DONE\n\n"; echo "Please remove this script from your server!"; } else { die('There are no tables?'); } ?>