Re: table to output "into outfile"

[Vesa Kilpiäinen]

I've got same problem, here's my code:

<?php...

$query = "SELECT * INTO OUTFILE 'backup/test.sql' FROM dev_users";
$result = mysql_query($query) or die('MySQL error: outfile');

...?>

So how can I make mysql to save the backup file in a directory which I choose, not in /var/lib/mysql/<database name>/backup/?