summaryrefslogtreecommitdiff
path: root/scripts/database-restore.php
diff options
context:
space:
mode:
Diffstat (limited to 'scripts/database-restore.php')
-rw-r--r--scripts/database-restore.php37
1 files changed, 37 insertions, 0 deletions
diff --git a/scripts/database-restore.php b/scripts/database-restore.php
new file mode 100644
index 0000000..6516e71
--- /dev/null
+++ b/scripts/database-restore.php
@@ -0,0 +1,37 @@
+<?php
+/**
+ * Restores the semanticscuttle database from a given file.
+ *
+ * This file is part of
+ * SemanticScuttle - your social bookmark manager.
+ *
+ * PHP version 5.
+ *
+ * @category Bookmarking
+ * @package SemanticScuttle
+ * @author Christian Weiske <cweiske@cweiske.de>
+ * @license GPL http://www.gnu.org/licenses/gpl.html
+ * @link http://sourceforge.net/projects/semanticscuttle
+ */
+
+if (!isset($argv[1])) {
+ echo "Please pass the sql file to restore\n";
+ exit(1);
+}
+$file = $argv[1];
+if (!file_exists($file)) {
+ echo "The file does not exist\n";
+ exit(2);
+}
+
+require_once dirname(__FILE__) . '/../src/SemanticScuttle/header-standalone.php';
+
+passthru(
+ 'mysql'
+ . ' -h' . escapeshellarg($GLOBALS['dbhost'])
+ . ' -u' . escapeshellarg($GLOBALS['dbuser'])
+ . ' -p' . escapeshellarg($GLOBALS['dbpass'])
+ . ' ' . escapeshellarg($GLOBALS['dbname'])
+ . ' < ' . escapeshellarg($file)
+);
+?> \ No newline at end of file