Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Problem importing zipped CSV into a database

Discussion in 'Database Discussion' started by Tjay322, May 10, 2017.

Tags:
  1. Tjay322

    Tjay322 Registered

    Joined:
    May 10, 2017
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Aus
    cPanel Access Level:
    Website Owner
    I've been using phpmyadmin for importing and exporting tables without too much trouble, but after the latest update it seems to not work properly? Before there was an option to 'replace table data with file' which I would use if there was any problems and it was working well. This is no longer an option and when I upload a .csv I'm just getting a blank page after the upload is finished, no info no error message just blank?

    So I'm wondering what's the best practice for uploading .csv tables and zipped .csv files?

    Most of the time I'm just adding to the content already there using MS excel then saving as normal. I'm not adding new columns, sometimes deleting rows.

    Now the particular file I'm uploading is around 500mb but zipped up it's around 7mb, I've increased the upload limit and time via WHM. I have dealt with files this large before with the old version without any problem so I'm confused why this version is playing up or I'm not doing something right? I'm including the column names when uploading, disabling partial import and choosing Do not abort on INSERT error.

    I've got this message when on the home page of phpmyadmin:
    Your PHP MySQL library version 5.1.73 differs from your MySQL server version 5.5.54. This may cause unpredictable behavior.

    Would this be causing it?
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,167
    Likes Received:
    1,933
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Here's a quote from one of our Technical Analysts regarding the topic of importing CSV files via phpMyAdmin in a recent support request:

    Regarding your other question:

    This topic is discussed on the following thread:

    Phpmyadmin - PHP MySQL library version

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice