Import a CSV file to MYSQL via PHPMYADMIN

Import a CSV file to MYSQL via PHPMYADMIN

I was given access to an existing instance of MySQL via phpMyAdmin. 
My task was to import a CSV file using the import feature on phpMyAdmin. 
First, I went to the the main phpMyAdmin page.
Next, I clicked on the database instance that I am interested. 
Then, I click on the table that I want to import my data and click on Import button.
On the import form, I click Browse button to choose the CSV file on my local hard drive.

Chose the following options:
        
  • Chose CSV using LOAD DATA
    •     
  • Separate columns with: ;
    •    
  • Columns delimited by: "
    •     
  • Fields divided with: \
    •     
  • Lines ending with: auto
    •    
  • Columns Name: [Leave Blank]
    •    
  • Select "Use LOCAL keyword" option

Finally, click in the "Run" button.

    • Related Articles

    • How to import a database in PhpMyAdmin?

      To import your database into phpMyadmin, you must access phpMyadmin through cpanel.  When you are in phpMyAdmin, you must choose a database into which the data will be imported (the empty database), which is located on the left, as shown in the ...

    • How to export your database in phpMyAdmin?

      To export your database on phpMyadmin, you must access phpMyadmin through cPanel.  - You must choose the database you want to export.  - Click on the MySQL database you want to export, it is located on the left side, as shown in the following image: ...

    • How to import/export a PostgreSQL database

      Important: First you need to create a PostgreSQL database following this tutorial: https://help.scriptcase.net/portal/pt/kb/articles/banco-de-dados-postgresql 1 - In cPanel, access “phpPgAdmin”; To import: 2 - In the left panel of the screen, click ...

    • How to change the charset of MySQL server

      To change the MySQL charset, follow the steps below: 1. Access the phpMyAdmin option in the Database section of your cPanel 2. Check the current server charset  3. Go to Settings, select Features and then Database tab, change the server charset in ...

    • How to edit a file in FIle Manager

      1. Log into your cPanel account. 2. In the "Files" section, click on "File Manger" Icon.   3. Navigate to the directory where your file is located and right click on the file and then click on "Edit"" in the Context Menu.  4. If the small "Code ...