970_90

Monday, 5 October 2015

How to import csv file to database through phpmyadmin

How to import csv file to database through phpmyadmin

To import csv file in database though phpmyadmin, Follow the following steps.
  1. You must have valid CSV File. EXCEL file will not work.
  2. you must have a table in database
  3. Number of Colums in CSV file must be equal to Number of column in table
  4. Now login to phpmyamdin.
  5. Make sure you server allow to upload the heavy files (If CSV is heavy).
    You can update the php.ini file as following(If you CSV is less than 700MB).
    upload_max_filesize = 700M
    post_max_size = 800M
    
    If your CSV is more than 700MB, then increase the above values in php.ini
  6. If you are uploading heavy files, you might need to increase the max_execution_time. (Means loading time to upload )
    max_execution_time = 300000
    
  7. Go to database and then go to table listing.
  8. Click on Import link at top page
  9. Next, Follow the steps in next.


  10. If you are getting any problem, Please comment below.. We will help you.


1 comment:


  1. Import CSV to MySQL Database

    LOAD DATA LOCAL INFILE '/home/project/csv/HotelImageList.csv' INTO TABLE `ean_hotel_images_april201` FIELDS TERMINATED BY '|' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n';

    ReplyDelete