[mirrors/SokoMan.git] / dump_sql.php

#!/usr/bin/php
<?php
if(isset($_SERVER['REQUEST_METHOD'])) die('Not for you');
$nodump = array('item','model','barcode','lock','transaction');
require_once('sklad.conf.php');

$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);
Commit	Line	Data
cdfce7c2 TM	1	#!/usr/bin/php
cdfce7c2 TM	2	<?php
e2329917	3	if(isset($_SERVER['REQUEST_METHOD'])) die('Not for you');
52cd5728	4	$nodump = array('item','model','barcode','lock','transaction');
cdfce7c2	5	require_once('sklad.conf.php');
7f332543 TM	6
	7	$ignore = '';
	8	$nodata = '';
	9	foreach($nodump as $t) {
	10	$ignore .= ' --ignore-table='.DB_NAME.'.'.$t;
	11	$nodata .= ' '.$t;
	12	}
	13
	14	system('mysqldump -u'.DB_USER.' -p'.DB_PASS.' '.DB_NAME.$ignore);
	15	if($nodata != '') system('mysqldump -u'.DB_USER.' -p'.DB_PASS.' '.DB_NAME.' --skip-comments --no-data'.$nodata);