Code for Migration Assistant

WARNING! WARNING!: Again you use this code at your own risk. This code poses a serious security issue if you leave it published to your Geeklog 1.5.x site for any period of time. In short if you use it, do so and remove the page immediately. And, one more time, be sure to back up your database.

<?php if ($_POST['migrate'] == 1) { require '../db-config.php'; global $_DB_host, $_DB_name, $_DB_user, $_DB_pass, $_DB_table_prefix, $_DB_dbms; $tableName = $_DB_table_prefix . 'conf_values'; $sqlFormat = "UPDATE $tableName SET value = '%s' WHERE name = '%s'"; $settings = array('site_url','site_admin_url','path_html','path_themes','path_log','path_language'); $conn = mysql_connect($_DB_host, $_DB_user, $_DB_pass); if (!mysql_select_db($_DB_name, $conn)) { die('error selecting database'); }; foreach ($settings as $curSetting) { $sql = sprintf($sqlFormat, serialize($_POST[$curSetting]), $curSetting); echo "Executing following query:<br/>$sql<br/>"; $result = mysql_query($sql, $conn); if (!$result) die("Last query failed. Hope you did a backup because you'll need to do a restore!"); } echo "Looks like the migration is done. Enjoy!"; } else { ?> <html> <head><title>Geeklog Migration Assitant</title></head> <body> <h2>Geeklog Migration Assistant</h2> <p><font color="red"><b>NOTE:</b> You must back-up your database before running this script. You've been warned</font></p> <p>This is a very simple utility that allows you to easily migrate your Geeklog site from one environment to another or from one server to another. This is *not* a tool to upgrade your Geeklog site from one version to another (e.g. 1.4 to 1.5.1).</p> <form method="POST" action="<?php echo $_SERVER['PHP_SELF'];?>" /> <input type="hidden" name="migrate" value="1" /> <table> <tr><td>Site Url:</td><td><input type="text" name="site_url" /></td></tr> <tr><td>Admin Url:</td><td><input type="text" name="site_admin_url" /></td></tr> <tr><td>HTML Path:</td><td><input type="text" name="path_html" /></td></tr> <tr><td>Themes Path:</td><td><input type="text" name="path_themes" /></td></tr> <tr><td>Log Path:</td><td><input type="text" name="path_log" /></td></tr> <tr><td>Language Path:</td><td><input type="text" name="path_language" /></td></tr> <tr><td colspan="2" align="center"><br/><input type="submit" value="Save Changes" /></td></tr> </table> </form> </body> </html> <?php } ?>

Last Updated: Tuesday, October 07 2008 @ 04:27 PM EDT|

Resources

Getting started

Support

Development

Topics

User Functions

What's New

Stories

Comments last 2 days

Trackbacks last 2 days

Links last 2 weeks

NEW FILES last 14 days

Code for Migration Assistant

Who's Online

Need Help?