Hi, I am an owner of a website hosted by [Removed]. I have a table importing issue with phpMyAdmin. When I tried to import data with CSV file, I get the following error:
SQL query:
LOAD DATA INFILE '/home/etheriac/tmp/php83KkA7' INTO TABLE `smf_geoip_countries` FIELDS TERMINATED BY ',' ENCLOSED BY '"'
ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 2 LINES
MySQL said: Documentation
#1045 - Access denied for user 'etheriac'@'localhost' (using password: YES)
I already raised the issue with my web service provider, but they told me that they have given me all the permissions and check everything and direct the source of the problem to elsewhere like the invalid content of my CSV files.
I checked the CSV files over myself with a private local server and the import was successful, so I took an extra step to export out the table into several SQL files since PHP has a timeout of 300 seconds. I tried importing those SQL files to the table and yet, I got a blank page after the import stops or finishes (not sure what), so I told the technical support personnel to import on my behalf; yet, they told me that they can only import database not a single table and they want only one file not broken into parts.
Disappointed by their reply, I came here to verify two things. Being unfamiliar with cpanel, I would like to verify if the technical support of my web service provider is correct about that they can't import a single table and that they can only import a database on their end.
The second thing I need to verify is if the error is coming from cpanel or not since my private server don't use cpanel. I use phpMyAdmin directly.
Here is the detail information of the virtual server and my private server:
Virtual Server:
cpanel version: 11.38.1 (build 6)
phpMyAdmin version: 3.5.8
Private Server:
phpMyAdmin version: 3.4.9
SQL query:
LOAD DATA INFILE '/home/etheriac/tmp/php83KkA7' INTO TABLE `smf_geoip_countries` FIELDS TERMINATED BY ',' ENCLOSED BY '"'
ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 2 LINES
MySQL said: Documentation
#1045 - Access denied for user 'etheriac'@'localhost' (using password: YES)
I already raised the issue with my web service provider, but they told me that they have given me all the permissions and check everything and direct the source of the problem to elsewhere like the invalid content of my CSV files.
I checked the CSV files over myself with a private local server and the import was successful, so I took an extra step to export out the table into several SQL files since PHP has a timeout of 300 seconds. I tried importing those SQL files to the table and yet, I got a blank page after the import stops or finishes (not sure what), so I told the technical support personnel to import on my behalf; yet, they told me that they can only import database not a single table and they want only one file not broken into parts.
Disappointed by their reply, I came here to verify two things. Being unfamiliar with cpanel, I would like to verify if the technical support of my web service provider is correct about that they can't import a single table and that they can only import a database on their end.
The second thing I need to verify is if the error is coming from cpanel or not since my private server don't use cpanel. I use phpMyAdmin directly.
Here is the detail information of the virtual server and my private server:
Virtual Server:
cpanel version: 11.38.1 (build 6)
phpMyAdmin version: 3.5.8
Private Server:
phpMyAdmin version: 3.4.9
Last edited by a moderator: