error in backing up mysql database through php

Question

What's wrong with this code?I'm currently calling the code below using a link. Is there anything else needed for this to work? The error is specifically in this line:

$backupdir = 'C:\wampbackup\x.sql';

What might be a possible solution to this. I'm a beginner so please bear with my lack of knowledge.

  $host= 'localhost';          
  $user= 'root';                
  $pass= ''; 
  $db=   'hospital; 

  $backupdir = 'C:\wampbackup\x.sql';    

  // Compute day, month, year, hour and min. 
  $today = getdate(); 
  $day = $today[mday]; 
  if ($day < 10) { 
      $day = "0$day"; 
  } 
  $month = $today[mon]; 
  if ($month < 10) { 
      $month = "0$month"; 
  } 
  $year = $today[year]; 
  $hour = $today[hours]; 
  $min = $today[minutes]; 
  $sec = "00"; 


  // Execute mysqldump command. 
  // It will produce a file named $db-$year$month$day-$hour$min.gz 
  // under $DOCUMENT_ROOT/$backupdir 
  system(sprintf( 
    'mysqldump --opt -h %s -u %s -p%s %s | gzip > %s/%s/%s-%s%s%s-%s%s.gz',                                                  
    $host, 
    $user, 
    $pass, 
    $db, 
    getenv('DOCUMENT_ROOT'), 
    $backupdir, 
    $db, 
    $year, 
    $month, 
    $day, 
    $hour, 
    $min 
  ));  
  echo '+DONE';  
?>

Sarfraz · Accepted Answer · 2010-02-20 08:21:12Z

1

Change this line:

$backupdir = 'C:\wampbackup\x.sql';

into:

$backupdir = 'C:\\wampbackup\\x.sql';

You need to escape back-slashes with another \ back-slash. :)

answered Feb 20, 2010 at 8:21

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user225269 Over a year ago

still not working after following your advice. Where would the backup suppose to go?

Sarfraz Over a year ago

it will be saved in C:\wampbackup\x.sql. Make sure that you have write permission for the folder C:\wampbackup

soulmerge · Accepted Answer · 2010-02-20 08:21:29Z

1

You should actually post your error message along with your code. But if it is not a copy-paste error, I found your bug: It's on line 4, the closing apostrophe is missing

$db=   'hospital;

answered Feb 20, 2010 at 8:21

soulmerge

76.3k20 gold badges122 silver badges161 bronze badges

Comments

Marc B · Accepted Answer · 2010-02-21 14:24:50Z

0

As a minor aside, you could skip the entirety of

if ($day < 10) { 
    $day = "0$day"; 
}

Later on you're using those values in a sprintf() call, which can do such formatting automatically. Simply change the matching %s with %02d (print a decimal padded to 2 spaces with the 0 character).

answered Feb 21, 2010 at 14:24

Marc B

362k44 gold badges433 silver badges508 bronze badges

Collectives™ on Stack Overflow

error in backing up mysql database through php

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related