MySQL Backup

planetsim

Im currently trying to get this MySQL BackUp to work and only get a 255 error, the file isnt being created either

<?php

include '../config.php';
$command = "mysqldump -h".$config['dbhost']." -u".$config['user']." --password=".$config['pass']." ".$config['dbname']." | >backup.sql";
passthru($command,$error);
if ($error) {
  echo $error;
}

?>

mtimdog

If you echo out your command you might see that you need some spaces in it.😃 😃

planetsim

There are spaces where they are nessacary. That isnt the problem that exact code is working in dos and creating the file.

Here is a newer version which is just creating the blank file

<?php

include '../config.php';
$command = "path/to/mysql/mysqldump --opt -h".$config['dbhost']." -u".$config['user']." --password=".$config['pass']." ".$config['dbname']." > backup.sql";
passthru($command,$error);
if ($error) {
  echo "Error: ". $error;
}

?>

mtimdog

so, what does it echo???

It looks like it would echo

path/to/mysql/mysqldump --opt -hdbhost -uuser --password=pass dbname > backup.sql

What i'm asking is should there be spaces after -h and -u??

Try this

path/to/mysql/mysqldump --opt --host=dbhost -u user --password=pass dbname

Weedpacket

What do you get from perror for that code?

planetsim

Okay ive given up on mysqldump and created my own backup which is quite bulky compared to using mysqldump.

Ill try and post it in the Code Critique.