<?php

//database name
$databaseName = '' . '.';
//array of table names to be renamed
$from = array();
//the array of table names to be renamed to
$to = array();

foreach($from as $tableNameFrom)
{
   foreach($to as $tableNameTo)
   {
      if(strtolower($tableNameTo) == strtolower($tableNameFrom))
      {
         echo "RENAME TABLE <br />\n";
         echo $databaseName . $tableNameFrom . ' TO ' . $databaseName . $tableNameFrom . "_B,<br />\n";
         echo $databaseName . $tableNameFrom . '_B TO ' . $databaseName . $tableNameTo . "<br />\n";
         echo ';';
      }
   }
}

?>

$file = file_get_contents('mysqldump.sql');

$fixed[0] = "ArchiveWidget";
$fixed[1] = "BlogEntry";
$fixed[2] = "BlogEntry_Live";
$fixed[3] = "Blogentry_versions";
$fixed[4] = "BlogHolder";
$fixed[5] = "BlogHolder_live";
$fixed[6] = "BlogHolder_versions";
$fixed[7] = "BlogTree";
$fixed[8] = "BlogTree_live";
$fixed[9] = "BlogTree_versions";
$fixed[10] = "ContactPage";
$fixed[11] = "ContactPage_live";
$fixed[12] = "ContactPage_versions";
$fixed[13] = "Email_BounceRecord";
$fixed[14] = "ErrorPage";
$fixed[15] = "ErrorPage_live";
$fixed[16] = "ErrorPage_versions";
$fixed[17] = "File";
$fixed[18] = "Gallery";
$fixed[19] = "Group";
$fixed[20] = "Group_Members";
$fixed[21] = "Group_Roles";
$fixed[22] = "HomePage";
$fixed[23] = "HomePage_Live";
$fixed[24] = "HomePage_versions";
$fixed[25] = "LoginAttempt";
$fixed[26] = "Member";
$fixed[27] = "MemberPassword";
$fixed[28] = "MageComment";
$fixed[29] = "Panel";
$fixed[30] = "Permission";
$fixed[31] = "PermissionRole";
$fixed[32] = "PermissionRoleCode";
$fixed[35] = "Products";
$fixed[36] = "ProductsPage";
$fixed[37] = "ProductsPage_Live";
$fixed[38] = "ProductsPage_versions";
$fixed[39] = "Products_Live";
$fixed[40] = "Products_versions";
$fixed[41] = "QueuedEmail";
$fixed[42] = "RedirectorPage";
$fixed[43] = "RedirectorPage_Live";
$fixed[44] = "RedirectorPage_versions";
$fixed[45] = "RSSWidget";
$fixed[46] = "SiteConfig";
$fixed[47] = "SiteConfig_CreateTopLevelGroups";
$fixed[48] = "SiteConfig_EditorGroups";
$fixed[49] = "SiteConfig_ViewerGroups";
$fixed[50] = "SiteTree";
$fixed[51] = "SiteTree_EditorGroups";
$fixed[52] = "SiteTree_ImageTracking";
$fixed[53] = "SiteTree_LinkTracking";
$fixed[54] = "SiteTree_Live";
$fixed[55] = "SiteTree_versions";
$fixed[56] = "SiteTree_ViewerGroups";
$fixed[57] = "TagCloudWidget";
$fixed[59] = "TrackBackPing";
$fixed[60] = "VirtualPage";
$fixed[61] = "VirtualPage_Live";
$fixed[62] = "VirtualPage_versions";
$fixed[63] = "Widget";
$fixed[64] = "WidgetArea";

foreach($fixed as $word) {
   $file = str_replace(strtolower($word), $word, $file);
}

print $file;