The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Table Importing Issue with phpMyAdmin

Discussion in 'Database Discussions' started by Ice_Drake1, Jul 9, 2013.

  1. Ice_Drake1

    Ice_Drake1 Registered

    Joined:
    Jul 3, 2013
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    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
     
    #1 Ice_Drake1, Jul 9, 2013
    Last edited by a moderator: Jul 9, 2013
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    It's difficult to determine the exact cause of the problem without root access to the serve to reproduce the issue. You did post the following error:

    This can sometimes indicate the account password needs to be updated so the MySQL password matches. It's possible your hosting provider is only a reseller without root access to complete this task. Importing a table should not be an issue using SSH as an alternative to phpMyAdmin. You are welcome to ask your hosting provider to open a ticket with us regarding this issue so we can attempt to reproduce the problem.

    Thank you.
     
  3. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,478
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Going by your post it sounds like you might be using this:
    geoIP (IP to Location)

    If yes, you might try that forum thread.

    HTH!
     
  4. Ice_Drake1

    Ice_Drake1 Registered

    Joined:
    Jul 3, 2013
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Yes, you are correct. I am trying to install geoIP, but that forum won't be able to help me. It is because I have been running into database problems since I can't seem to be able to import those tables successfully without getting an error. Later on, I found out that it was a permission problem coming from either cpanel or phpMyAdmin or both.
     
  5. Ice_Drake1

    Ice_Drake1 Registered

    Joined:
    Jul 3, 2013
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Thank you so much with your suggestion. I was able to import those tables to the database via SSH. In the process, I noticed that I can't log to mysql with cpanel username. I got a #1045 error as a result. Instead, I have to log in with my mysql username. The issue #1045 appears again as I attempt to import a CSV file to a table even when I am log in with mysql username.

    Nonetheless, I got my tasks done. I have told the technical support of my web hosting provider to follow up with you guys on this issue. Whether they will or not is up to them. Thanks, again. This installation took me months to install properly.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    This indicates your hosting provider needs to update your account password via "WHM Home » Account Functions » Password Modification" and ensure that "Allow MySQL password change" is enabled.

    Thank you.
     
Loading...

Share This Page