diff options
| author | Christian Weiske <cweiske@cweiske.de> | 2010-10-08 16:59:04 +0200 |
|---|---|---|
| committer | Christian Weiske <cweiske@cweiske.de> | 2010-10-08 16:59:04 +0200 |
| commit | cd023dea530870a047ca87405fedc3ddbc06d787 (patch) | |
| tree | aa02ba5c6e821176f47143cdd47485655c210971 | |
| parent | 8e3daac73e324368a414fc0e9406dcbe43ffba29 (diff) | |
| download | semanticscuttle-cd023dea530870a047ca87405fedc3ddbc06d787.tar.gz semanticscuttle-cd023dea530870a047ca87405fedc3ddbc06d787.tar.bz2 | |
scripts to dump and restore the semanticscuttle database quickly - useful to keep the database even when running unit tests
| -rw-r--r-- | .gitignore | 1 | ||||
| -rw-r--r-- | scripts/database-dump.php | 26 | ||||
| -rw-r--r-- | scripts/database-restore.php | 37 |
3 files changed, 64 insertions, 0 deletions
@@ -1,3 +1,4 @@ dist/ build.properties package.xml +semanticscuttle-dump.sql diff --git a/scripts/database-dump.php b/scripts/database-dump.php new file mode 100644 index 0000000..f4f04ac --- /dev/null +++ b/scripts/database-dump.php @@ -0,0 +1,26 @@ +<?php +/** + * Dumps the semanticscuttle database into a file using mysqldump. + * + * 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 + */ +require_once dirname(__FILE__) . '/../src/SemanticScuttle/header-standalone.php'; + +passthru( + 'mysqldump' + . ' -h' . escapeshellarg($GLOBALS['dbhost']) + . ' -u' . escapeshellarg($GLOBALS['dbuser']) + . ' -p' . escapeshellarg($GLOBALS['dbpass']) + . ' ' . escapeshellarg($GLOBALS['dbname']) + . ' > semanticscuttle-dump.sql' +); +?>
\ No newline at end of file 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 |