|
Revision 551, 1.7 KB
(checked in by michiel, 17 months ago)
|
|
implement automatic backup for MySQL and sqlite.
Postgresql support is lacking at the moment.
Re #124
|
| Line | |
|---|
| 1 | <?php |
|---|
| 2 | |
|---|
| 3 | |
|---|
| 4 | |
|---|
| 5 | |
|---|
| 6 | |
|---|
| 7 | |
|---|
| 8 | |
|---|
| 9 | |
|---|
| 10 | |
|---|
| 11 | |
|---|
| 12 | |
|---|
| 13 | |
|---|
| 14 | |
|---|
| 15 | |
|---|
| 16 | |
|---|
| 17 | |
|---|
| 18 | |
|---|
| 19 | |
|---|
| 20 | |
|---|
| 21 | |
|---|
| 22 | |
|---|
| 23 | if (array_key_exists("mode", $_REQUEST)) |
|---|
| 24 | $mode = $_REQUEST["mode"]; |
|---|
| 25 | else |
|---|
| 26 | $mode = ""; |
|---|
| 27 | |
|---|
| 28 | require_once("common/mvblog_upgrade.php"); |
|---|
| 29 | $updater = new Mvblog_upgrade(); |
|---|
| 30 | |
|---|
| 31 | if (array_key_exists("dbversion", $updater->settings)) |
|---|
| 32 | $latest_version = $updater->settings["dbversion"]; |
|---|
| 33 | else |
|---|
| 34 | $latest_version = 0; |
|---|
| 35 | |
|---|
| 36 | echo "looking up files for db type <b>".$updater->db->phptype."</b> starting at version <b>".$latest_version."</b>...<br />"; |
|---|
| 37 | |
|---|
| 38 | |
|---|
| 39 | $patches = $updater->get_patchfiles($mode); |
|---|
| 40 | if (!count($patches)) |
|---|
| 41 | die("nothing to do. Your mvblog is already up-to-date."); |
|---|
| 42 | |
|---|
| 43 | echo "Creating backup of your current database<br />"; |
|---|
| 44 | $backup = $updater->create_backups(); |
|---|
| 45 | |
|---|
| 46 | foreach ($patches as $patch) { |
|---|
| 47 | if (!$updater->apply_dbpatch($patch, $mode)) |
|---|
| 48 | die("something went wrong with patchfile $patch. Rollback to backup."); |
|---|
| 49 | echo "applied patchfile $patch. <br>"; |
|---|
| 50 | |
|---|
| 51 | if ($updater->lastpatch > $latest_version) |
|---|
| 52 | $latest_version = $updater->lastpatch; |
|---|
| 53 | } |
|---|
| 54 | $updater->set_latest_version($latest_version); |
|---|
| 55 | echo "Your MvBlog installation is updated. Have fun."; |
|---|
| 56 | ?> |
|---|