<?php

 // Parameters
 $backup_dirpath = '';
 $db_name = '';
 $tables = '';
 $user = '';
 $pw = '';

 // Internal
 $date = date('ymd_his');
 $fname = '';
 $backup_path = '';

 $fname = $dbname . '_backup_' . $date . '.sql';

 if ( !system("mysqldump --add-drop-table -u $_u -p $_p $dbname $tables > $path/$fname", $result) )
 {
  die("system mysqldump failed -- aborting backup `$date`");
 }

 if ( !system("gzip $path/$fname", $result) )
 {
  die("system gzip failed -- aborting backup `$date`");
 }
 else
 {
  $backup_path = $fname . '.gz';
  echo "DB `$dbname`, tables `$tables`, backed up to `$backup_path`";
 }

?>
 

 
 // connect to DB
 
 $_DATA['BACK_TABLES'] = array('table1', 'table2');
 
 foreach ( $_DATA['BACK_TABLES'] as $_table )
 {
  $_SQL['select_all'] = "SELECT * FROM $_table";
  $_sqlr = mysql_query($_SQL['select_all']);
  if ( @mysql_num_rows($_sqlr) )
  {
   while ( $_ROW = mysql_fetch_array($_sqlr))
   {
    foreach ( $_ROW as $_key => $_value )
    {
     $_COL[] = $_key;
     $_VAL[] = addslashes($_value);
    }
 echo "INSERT INTO $_table (" . implode(',',$_COL) . ") VALUES ('" . implode('', '', $_VAL) . "'); n";
   }
  }
 }