X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=dump_sql.php;h=a6d799519fef9bed6d8ca05a70428637334a195f;hb=0920d9c71a0d99e093a8fffc3aea3db864a89e1f;hp=efa005dca0f9a46d3abc6761738cc89c112d8565;hpb=cdfce7c291830a69e3e91aac21f75c4fd3f09448;p=mirrors%2FSokoMan.git

diff --git a/dump_sql.php b/dump_sql.php
index efa005d..a6d7995 100755
--- a/dump_sql.php
+++ b/dump_sql.php
@@ -1,4 +1,15 @@
 #!/usr/bin/php
 <?php
+if(isset($_SERVER['REQUEST_METHOD'])) die('Not for you');
+$nodump = array('item','model','barcode','lock','bank');
 require_once('sklad.conf.php');
-system('mysqldump -u'.DB_USER.' -p'.DB_PASS.' '.DB_NAME);
+
+$ignore = '';
+$nodata = '';
+foreach($nodump as $t) {
+	$ignore .= ' --ignore-table='.DB_NAME.'.'.$t;
+	$nodata .= ' '.$t;
+}
+
+system('mysqldump -u'.DB_USER.' -p'.DB_PASS.' '.DB_NAME.$ignore);
+if($nodata != '') system('mysqldump -u'.DB_USER.' -p'.DB_PASS.' '.DB_NAME.' --skip-comments --no-data'.$nodata);