I'm trying to upload some data to my mysql.
I tried using phpMyAdmin 2.2.5, provided by the hoster, but I get the error
"The used command is not allowed with this MySQL version"
because of the "local" in:
LOAD DATA LOCAL INFILE '/var/tmp/phphzsETp' INTO TABLE iptocountry FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
Is there another way?
I also tried using a php script to do it...
created a folder "test" on the server, uploaded the file iptocountry.txt to that folder.
no error... but doesn't work:
mysql_connect('localhost','myusername','mypassword') or die("can't connect to database");
mysql_select_db('nunomira_com') or die("can't select nunomira_com");
$query = "load data infile 'iptocountry.txt'
into table iptocountry
fields terminated by ',' enclosed by '\"'
lines terminated by '\r\n';"
mysql_query($query) or die("can't execute query" . mysql_error());
the file is now just 1Kb...
I've read every thing I could about this...
Also, the domain was a gift, but I don't have much control over it by now. So I can't configure anything nor upgrade phpMyAdmin... I don't even know where the phpMyAdmin files are nor the MySql data is stored...
