Selective Backup FAILS !

[♥sandwick]

When I modify the backup.php script to perform a selective backup it fails with ...

 

I am using version 1.01 Selective backup ...

 

1064 - You have an error in your SQL syntax near '15' at line 1

show fields from 15

[TEP STOP]

 

Changing the code from

 

line 45

   $tables_query = tep_db_query('show tables');
	while ($tables = tep_db_fetch_array($tables_query)) {
	  list(,$table) = each($tables);

 

to this

 

// BOF selective backup by PATRIOT
	$table_files = array(DIR_FS_CATALOG. 'includes/database_tables.php', DIR_WS_INCLUDES. 'database_tables.php');
	foreach ($table_files as $table_file){
		$file = file($table_file);
		while (list(, $line) = each($file)){
			$line = trim($line);
			if (substr($line, 0, 6) != 'define') continue;
			$line = str_replace(' ', '', $line);
			$begin = strpos($line, "','")+3;
			$len = strrpos($line, "'") - $begin;
			$database_tables[] = substr($line, $begin, $len);
		}
	}
	$database_tables = array_unique($database_tables);

	foreach ($database_tables as $table){
// EOF selective backup by PATRIOT

 

causes my backup to fail ...

 

Any suggestions ?

[spooks]

Don`t know that, you could try these.

 

AutoBackup Database in Admin http://addons.oscommerce.com/info/2314

Database backup manager http://addons.oscommerce.com/info/5769

[♥sandwick]

I will look at the other contribs.

 

 

Makes it hard when you just need to back up 2M of tables, and to do full backup it is 80M.

 

 

thanks Spooks ! <_<