{"id":5010,"date":"2016-08-20T11:02:27","date_gmt":"2016-08-20T11:02:27","guid":{"rendered":"https:\/\/cpanelplesk.com\/wp62\/?p=5010"},"modified":"2021-02-03T11:12:25","modified_gmt":"2021-02-03T11:12:25","slug":"import-csv-files-database-phpmyadmin","status":"publish","type":"post","link":"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/","title":{"rendered":"How to import .csv files in the database from phpmyadmin"},"content":{"rendered":"<p><span style=\"color: #000000;\">Before proceeding further, keep in mind \u00a0few things to efficiently transfer .csv files in the database from phpmyadmin. Saved your csv file into excel file. Please Do not save it as any other format, check it with a written text such as notepad . Each line must be separated by a comma (,). This is required when we transfer the file within PHPmyAdmin. Remove column titles, blank areas and make certain that there is an entry of some form in each row and column. The information in the table should signify in the same way in the CSV file. If your table has \u2018s\u2019 columns you must have \u2018s\u2019 columns in the CSV file as well.<\/span><br \/>\n<!--more--><\/p>\n<h3><strong>Follow the below steps to import .CSV file into database.<\/strong><\/h3>\n<p><span style=\"color: #000000;\">1. \u00a0Upload .csv file in public_html via <a href=\"https:\/\/cpanelplesk.com\/wp62\/how-to-install-ftp-and-setup-user-account\/\">FTP<\/a>.<\/span><\/p>\n<p><span style=\"color: #000000;\">2. \u00a0Access your <a href=\"https:\/\/cpanelplesk.com\/wp62\/install-and-configure-phpmyadmin-on-a-centos\/\">phpmyadmin<\/a> &gt;&gt; Select database &gt;&gt; Click on SQL tab.<\/span><\/p>\n<p><span style=\"color: #000000;\">3. Type following SQL query.<\/span><\/p>\n<div class=\"command-sh\">\n<pre class=\"lang:default decode:true \">load data local infile \u2018Full path for .CSV file\u2019 into table city\r\n\r\nfields terminated by \u2018,\u2019\r\n\r\nenclosed by \u2018\u201d\u2018\r\n\r\nlines terminated by \u2018\\n\u2019<\/pre>\n<\/div>\n<p>Replace actual full path with \u201cFull path for .CSV file\u201d (\/home\/username\/public_html\/filename.csv)<\/p>\n<p><span style=\"color: #000000;\">4. Click on Go.<\/span><\/p>\n<p><span style=\"color: #000000;\">That\u2019all to do.You would also like to know<a href=\"https:\/\/cpanelplesk.com\/wp62\/scan-ftp-uploaded-files-cpanel-servers\/\">\u00a0How to scan FTP uploaded files.<\/a>\u00a0It will help to keep your server clean from any virus if it get uploaded via FTP.<\/span><span style=\"color: #000000;\">Please\u00a0Give your opinion below if you experience any issues or to discuss your ideas and experiences.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Before proceeding further, keep in mind \u00a0few things to efficiently transfer .csv files in the database from phpmyadmin. Saved your csv file into excel file. Please Do not save it as any other format, check it with a written text such as notepad . Each line must be separated by a comma (,). This is [&#8230;]<\/p>\n<p><a class=\"understrap-read-more-link\" href=\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/\">Continue Reading&#8230;<\/a><\/p>\n","protected":false},"author":2,"featured_media":5012,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5010","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to import .csv files in the database from phpmyadmin - cPanel Plesk<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"How to import .csv files in the database from phpmyadmin - cPanel Plesk\" \/>\n<meta name=\"twitter:description\" content=\"Before proceeding further, keep in mind \u00a0few things to efficiently transfer .csv files in the database from phpmyadmin. Saved your csv file into excel file. Please Do not save it as any other format, check it with a written text such as notepad . Each line must be separated by a comma (,). This is [...]Continue Reading...\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/CSV-file.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Seemab Saleem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/\"},\"author\":{\"name\":\"Seemab Saleem\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\"},\"headline\":\"How to import .csv files in the database from phpmyadmin\",\"datePublished\":\"2016-08-20T11:02:27+00:00\",\"dateModified\":\"2021-02-03T11:12:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/\"},\"wordCount\":228,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"image\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/CSV-file.jpg\",\"articleSection\":[\"Cpanel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/\",\"name\":\"How to import .csv files in the database from phpmyadmin - cPanel Plesk\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/CSV-file.jpg\",\"datePublished\":\"2016-08-20T11:02:27+00:00\",\"dateModified\":\"2021-02-03T11:12:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#primaryimage\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/CSV-file.jpg\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/CSV-file.jpg\",\"width\":225,\"height\":225},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cpanelplesk.com\/wp62\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to import .csv files in the database from phpmyadmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/\",\"name\":\"cPanel Plesk\",\"description\":\"Blog on famous hosting control panels\",\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\",\"name\":\"Farooq Omer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"width\":300,\"height\":44,\"caption\":\"Farooq Omer\"},\"logo\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\",\"name\":\"Seemab Saleem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"caption\":\"Seemab Saleem\"},\"description\":\"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!\",\"sameAs\":[\"https:\/\/cpanelplesk.com\/wp62\"],\"url\":\"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to import .csv files in the database from phpmyadmin - cPanel Plesk","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/","twitter_card":"summary_large_image","twitter_title":"How to import .csv files in the database from phpmyadmin - cPanel Plesk","twitter_description":"Before proceeding further, keep in mind \u00a0few things to efficiently transfer .csv files in the database from phpmyadmin. Saved your csv file into excel file. Please Do not save it as any other format, check it with a written text such as notepad . Each line must be separated by a comma (,). This is [...]Continue Reading...","twitter_image":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/CSV-file.jpg","twitter_misc":{"Written by":"Seemab Saleem","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/"},"author":{"name":"Seemab Saleem","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648"},"headline":"How to import .csv files in the database from phpmyadmin","datePublished":"2016-08-20T11:02:27+00:00","dateModified":"2021-02-03T11:12:25+00:00","mainEntityOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/"},"wordCount":228,"commentCount":0,"publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"image":{"@id":"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/CSV-file.jpg","articleSection":["Cpanel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/","url":"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/","name":"How to import .csv files in the database from phpmyadmin - cPanel Plesk","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/CSV-file.jpg","datePublished":"2016-08-20T11:02:27+00:00","dateModified":"2021-02-03T11:12:25+00:00","breadcrumb":{"@id":"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#primaryimage","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/CSV-file.jpg","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/CSV-file.jpg","width":225,"height":225},{"@type":"BreadcrumbList","@id":"https:\/\/cpanelplesk.com\/wp62\/import-csv-files-database-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cpanelplesk.com\/wp62\/"},{"@type":"ListItem","position":2,"name":"How to import .csv files in the database from phpmyadmin"}]},{"@type":"WebSite","@id":"https:\/\/cpanelplesk.com\/wp62\/#website","url":"https:\/\/cpanelplesk.com\/wp62\/","name":"cPanel Plesk","description":"Blog on famous hosting control panels","publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13","name":"Farooq Omer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","width":300,"height":44,"caption":"Farooq Omer"},"logo":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/"}},{"@type":"Person","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648","name":"Seemab Saleem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","caption":"Seemab Saleem"},"description":"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!","sameAs":["https:\/\/cpanelplesk.com\/wp62"],"url":"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/"}]}},"_links":{"self":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/5010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/comments?post=5010"}],"version-history":[{"count":0,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/5010\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media\/5012"}],"wp:attachment":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media?parent=5010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/categories?post=5010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/tags?post=5010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}