Project

General

Profile

« Previous | Next » 

Revision 189

Added by ryan about 19 years ago

Worked on backup-sql.php

View differences:

backup-sql.php
34 34 
$admin = new admin('Settings', 'settings_advanced', false);
35 35 

  		




  36
  36
  
    
// Begin output var


  		




  37
  
  
    
$output = "\n".


  		




  
  37
  
    
$output = "".


  		




  38
  38
  
    
"#\n".


  		




  39
  
  
    
"# Website Baker ".WB_VERSION." Backup (SQL)\n".


  		




  40
  
  
    
"# ".gmdate(TIME_FORMAT, mktime()+TIMEZONE)." ".gmdate(TIME_FORMAT, mktime()+TIMEZONE)."\n".


  		




  
  39
  
    
"# Website Baker ".WB_VERSION." Database Backup\n".


  		




  
  40
  
    
"# ".WB_URL."\n".


  		




  
  41
  
    
"# ".gmdate(DATE_FORMAT, mktime()+TIMEZONE)." ".gmdate(TIME_FORMAT, mktime()+TIMEZONE)."\n".


  		




  41
  42
  
    
"#".


  		




  42
  43
  
    
"\n";


  		




  43
  44
  
    

  		




  ......




  51
  52
  
    
	// Start creating sql-backup


  		




  52
  53
  
    
	$out = $query->fetchRow();


  		




  53
  54
  
    
	$sql_backup .= $out['Create Table'].";\r\n\r\n";


  		




  54
  
  
    
	$sql_backup .= "# Dump data\r\n\r\n";


  		




  
  55
  
    
	$sql_backup .= "# Dump data for ".$row['Name']."\r\n\r\n";


  		




  55
  56
  
    
	$sql = "SELECT * FROM ".$row['Name'];


  		




  56
  57
  
    
	// SQL code to select everything


  		




  57
  58
  
    
	$out = $database->query($sql);


  		












Also available in:  Unified diff