backing up a table

[russthebarber]

Hi, I've been trying for several hours now to backup a table to a .sql file using php. The php code seems to be running but nothing at all is happening and no file is created in my "backups" folder. Can anyone help show me where I am going wrong? Thanks. Code below:

<?php
$dbhost = "localhost";
$dbuser = "myusername";
$dbpass = "mypassword";
$dbname = "mydbname";
$dbtable = "divs";
//Connect to MySQL Server
mysql_connect($dbhost, $dbuser, $dbpass);
//Select Database
mysql_select_db($dbname) or die(mysql_error());

$backupFile = 'backups/backupTest.sql';
$query      = "SELECT * INTO OUTFILE '$backupFile' FROM $dbtable";
$result = mysql_query($query);

echo $backupFile;
?>

[The Little Guy]

why don't you use mysqldump?

 

mysqldump -u myuser --password=mypassword mydatabase mytable > backups/backupTest.sql