使用php将sql文件加载到数据库中

发布于 2024-11-26 20:29:46 字数 374 浏览 1 评论 0原文

我想将Linux服务器上的sql文件中的数据加载到数据库中。

我这样尝试过。

$query = "LOAD DATA INFILE '/home/technoho/public_html/gpstracking/system/application/controllers/backup/uploads/28_07_11_14_11_07.sql' 
INTO TABLE `backup` 
FIELDS TERMINATED BY '\', \'' 
LINES TERMINATED BY '\n' 
STARTING BY 'INSERT'";

此查询适用于本地系统文件，但我想从服务器文件加载数据。我认为我给出服务器文件的路径是错误的。

原文

I want to load data from sql file which is located on linux server to database.

I tried like this.

$query = "LOAD DATA INFILE '/home/technoho/public_html/gpstracking/system/application/controllers/backup/uploads/28_07_11_14_11_07.sql' 
INTO TABLE `backup` 
FIELDS TERMINATED BY '\', \'' 
LINES TERMINATED BY '\n' 
STARTING BY 'INSERT'";

This query works with local system file, but I want to load data from server file.
I think I am wrong in giving path for server file.

分享到QQ

分享到微博