php - SQLSTATE [HY000] : General error

Question

我在尝试获取数据库表的备份时遇到上述错误问题。请检查

$table_name = "back_up_manager";
$backup_file  = "/var/www/html/solaris_dev/uploads/back_up_manager".date('F h:i:s').".csv";
$sql = "SELECT * INTO OUTFILE '$backup_file' FROM $table_name";
$command = Yii::$app->db->createCommand($sql)->queryAll();

Answer 1

更改这部分代码

$sql = "SELECT * INTO OUTFILE '" . $backup_file. "' FROM " .$table_name;

在您的示例中， $sql变量包含无效的文件路径。