importing a CSV into phpmyadmin

In phpMyAdmin, click the table, and then click the Import tab at the top of the page.

Browse and open the csv file. Leave the charset as-is. Uncheck partial import unless you have a HUGE dataset (or slow server). The format should already have selected “CSV” after selecting your file, if not then select it (not using LOAD DATA). If you want to clear the whole table before importing, check “Replace table data with file”. Optionally check “Ignore duplicate rows” if you think you have duplicates in the CSV file. Now the important part, set the next four fields to these values:

Fields terminated by: ,
Fields enclosed by: “
Fields escaped by: \
Lines terminated by: auto

Currently these match the defaults except for “Fields terminated by”, which defaults to a semicolon.

Now click the Go button, and it should run successfully.

Related Posts:

  1. How to create a foreign key in phpmyadmin
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. How do I restore a dump file from mysqldump?
  5. How do I quickly rename a MySQL database (change schema name)?
  6. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  7. Setting up foreign keys in phpMyAdmin?
  8. Create a new database with MySQL Workbench
  9. How to get size of mysql database?
  10. 1052: Column ‘id’ in field list is ambiguous
  11. 1052: Column ‘id’ in field list is ambiguous
  12. difference between primary key and unique key
  13. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  14. MySQL Error #1133 – Can’t find any matching row in the user table
  15. Create mysql table directly from CSV file using the CSV Storage engine?
  16. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  17. How can I output MySQL query results in CSV format?
  18. Dump all tables in CSV format using ‘mysqldump’
  19. How to check if mysql database exists
  20. Is there a Profiler equivalent for MySql?
  21. How to do a batch insert in MySQL
  22. MySQL: Cloning a MySQL database on the same MySql instance
  23. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  24. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  25. Data is not constantly loading from custom wordpress table
  26. What’s a good strategy for planning WordPress DB growth?
  27. What specific database privileges does WordPress need?
  28. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  29. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  30. How to copy post titles to post slug in phpmyadmin
  31. Delete all post meta except featured image
  32. Export only pages and posts with mysql dump
  33. How to do a MySQL dump from production site without using a search and replace script for local development?
  34. Set Display Name to first and last name (phpmyadmin SQL Query)
  35. How Do I Merge Categories With phpMyAdmin
  36. Emojis getting converted to “?”
  37. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  38. Delete all post meta except featured image Using SQL
  39. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  40. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  41. Can’t find my wordpress DB in phpmyadmin
  42. WordPress database import: Row size too large
  43. Will changing the folder name two directories above a fresh wordpress installation break the site?
  44. Backing up and restoring multiple sites efficiently
  45. $wpdb to insert html form information
  46. Better ads plugin has 500.000 entries in wp_postmeta
  47. Changing root password in PHPMyAdmin for WordPress Database when going live
  48. Can’t update WordFence Options, clear data manually
  49. Import CSV to MySQL, with custom registration field information
  50. Create a form with custom autocomplete address field and CSV import values
  51. Setting up WordPress Locally on WAMP for a new site (with one already)
  52. Getting Error Trying to Create Table
  53. Export Yoast Keywords from MySQL/phpMyAdmin
  54. Editing mysql tables/database with wordpress or other app/cms
  55. Files on Localhost, Database on Server
  56. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  57. How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
  58. List users with the most posts in the last 30 days
  59. Installing local to live WP into subdirectory
  60. Export SQL query based on custom field?
  61. Mysql Server keeps crashing
  62. Error establishing a database connection (Set-up locally)
  63. DB prefix not updating
  64. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  65. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  66. How to bulk delete a certain part of all wordpress posts
  67. When I add metadata, metavalue length is added in to the value in some cases
  68. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  69. Deleted products from woocommerce are still in the database
  70. Store GravityForm data in phpmyadmin (mysql)
  71. Find locations of all featured images of draft posts via SQL
  72. SQL query to change custom field in WordPress database
  73. How to map data on CSV to web pages?
  74. An SQL query to find orphaned image attachments and their meta
  75. Missing latest posts and options after DB migration via phpMyAdmin
  76. Check if a database is well installed
  77. How to Import Multiple Values in custom field
  78. cannot log in to the mysql server (wamp and wordpress)
  79. SQL command to export post_content from wp_posts using phpMyAdmin
  80. Need SQL query to find&replace image URL
  81. How do I load a sql.gz file to my database? (importing)
  82. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  83. Rename a column in MySQL
  84. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  85. MySQL date formats – difficulty Inserting a date
  86. Moving WordPress from MAMP to WAMP, can’t access pages
  87. Mysqldump add drop table?
  88. find a random blogid across my multisite network that has at least one post published
  89. #1115 – Unknown character set: ‘utf8mb4’
  90. How to Move Local Singlesite Database to Remote Multsite Database?
  91. WordPress mysql table double prefixes
  92. Why do mass updates to post_content shows in front end, but not in edit screen?
  93. Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
  94. Many slow queries post_type = ‘attachment’;
  95. Match tag names with form titles
  96. MSQL database wp_postmeta has meta key tve_revision
  97. Regular XML-RPC timeouts
  98. How To connect to the same WordPress database with different database user
  99. $wpdb->get_var not returning count
  100. Custom user query – orderby meta_key (that may not exist)

Leave a Comment