PHP Uncategorized

How to Convert all Mysql Tables to InnoDB Script

<?php // Connect to database // ... // Get all databases $Result = @mysql_query(&#x22;show databases&#x22;); $cnt = @mysql_num_rows($Result);
 while ($cnt) { $cnt--;
 if (!($Row = @mysql_fetch_array($Result))) {
 continue;

 } 
$database = $Row[0]; 
if (Strcasecmp($database,&#x27;information_schema&#x27;)==0) continue;
 echo &#x22;+ Converting [$database]rn&#x22;; 
flush(); 
// Select database if (!@mysql_select_db($database)) continue;
 // Iterate through all tables converting them one by one $Result1 = @mysql_query(&#x22;SHOW TABLES FROM $database&#x22;); 
$cnt1 = @mysql_num_rows($Result1); 
while ($cnt1) { $cnt1--; if (!($Row1 = @mysql_fetch_array($Result1))) { continue;
 } $tablename = $Row1[0]; @mysql_query(&#x22;alter table $database.$tablename engine=innodb&#x22;);
 } } ?&#x3E;

Related Articles

techfolks php tutorials logo
Excel Using PHP Excel Using PHP and Mysql Mysql PHP Sample Programs

Export to Excel Using PHP and Mysql

viveik

Below simple program will export mysql data values to excel sheet without using any PHP libraries. Export to Excel Using PHP and Mysql Note: IF you get errors or in excel all the data is in one column, then instead t tab space use, comma ‘,’.
Mysql PHP

Best way to loop through a PHP mysql Resultset

viveik

If you want to loop throuh the mysql result set twice then use below way. $result = mysql_query(“SELECT * FROM my_table”);while($row = mysql_fetch_assoc($result)) {// inside the loop} The problem is, if you want to loop through the same result set again, you will get an error because the internal pointer is currently at the end […]
Uncategorized

Best Sidebar Social Plugin Code

viveik

Tweet