PHP - Moved: Mysqldump

<?php
$pathToMysqldump = "C:\xampp\mysql\bin";
$user= "root";
$pass= "";
$namedb= "test";
$output= "C:\xampp\htdocs\test\test.sql

//backup saved
exec("$pathToMysqldump --user=$user--password=$pass $namedb> $output");

//header('Location: http://localhost/test);
exit;

Hi people, i cant do it work, I use xampp and back dont creat the file .sql.

Thanks a lot.

 

 

Hello guys. I was thinking on posting this under the mysql thread. but i think this can be solved by php.. anyway, i want to dump mysql data on the client side whenever a user logs out. how can i do this? thanks in advance.

Any help on this would be greatly appreciated.  I am trying to run a mysqldump from my site for my client when they want to back up.  They basically will jsut click a button to run the backup. 

With my script below, the backup file is genrated, but there is no table data in the file.  There are the headers in the file with the server IP, linux versin, etc..., but there is no data in the file.  Does this look right?  Thank you for helping me out.

Ryan

Code: [Select]
ini_set ("display_errors", "1");
error_reporting(E_ALL);

$dbhost = 'localhost';
$dbuser = 'databaseuser';
$dbpass = 'password';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

$dbname = 'database';
mysql_select_db($dbname);

$tableName  = 'lots';
$backupFile1 = '/home/stuff/wwwroot/stuff/appnew/backup/';
$backupFile = $backupFile1.$dbname . date("Y-m-d-H-i-s") . '.gz';
$command = "mysqldump --opt -h$dbhost -u$dbuser -p$dbpass $dbname | gzip > $backupFile";
system($command);
$result = mysql_query($command);

This topic has been moved to mod_rewrite.

http://www.phpfreaks.com/forums/index.php?topic=356314.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=318465.0