我想创建一个sql文件说test.sql,可以导入到MysqL数据库.

mycode的：

$con=MysqLi_connect("localhost","root","","mydatabase");

$tableName  = 'test';
$backupFile = '/opt/lampp/htdocs/practices/PHPTest/test.sql';
$query      = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName WHERE id BETWEEN 10 AND 500";

$result = MysqLi_query($con,$query);

这会创建一个test.sql文件,但是当我尝试导入它时会出现错误#1064
我的脚本只创建一个文件,其中的行包含列名和表sturcute或插入查询.