Exporting MYSQL Table to file using PHP -


i got code on website, can't working.

$file = 'backups/mytable.sql';  $result = mysql_query("select * outfile '".$file."' ##table##"); 

i modified it:

$file = "backups/mytable.sql";  $result = mysqli_query("select * outfile '".$file."' comments") or die ("query died: exporting"); 

the query dies, no php error. using xampp.

i need asap.

thank you

do have permission this?

the priviledge attribute 'file' , works both ways, reading , writing files.


Comments