jeudi 8 janvier 2015

import text file getting command is not allowed with this MySQL version


here is my table



CREATE TABLE cities (
country CHAR(2),
city_ascii VARCHAR(100),
city VARCHAR(255),
region CHAR(2),
population INT UNSIGNED,
latitude DECIMAL(10, 6),
longitude DECIMAL(10, 6),
INDEX idx_lat_long (latitude, longitude),
INDEX idx_country (country),
INDEX idx_region (region)
);


I'm trying to import a text file to my database following tutorial here.



LOAD DATA LOCAL INFILE 'worldcitiespop.txt' INTO TABLE cities
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(country, city_ascii, city, region, population, latitude, longitude);


but I'm getting the following error message.



ERROR 1148 (42000): The used command is not allowed with this MySQL version


Any ideas?


Thank you





Aucun commentaire:

Enregistrer un commentaire