You have to keep in mind few things to import successfully .csv files within the database from phpmyadmin. Make sure that you save your Excel file as a csv file. Please don’t save it as a workbook or the other format, check it with a text reader like notepad or similar. You’ll be able to see that every column is separated by a comma (,). this is often needed when we import the file with PHPmyAdmin. Please take away column headings, blank areas and make sure that there’s an entry of some kind in every row and column. the information within the table should represent identically within the CSV file. If your table has \u2018n\u2019 columns you need to have \u2018n\u2019 columns within the CSV file as well.<\/p>\n
1. Using ftp Upload .csv file in public_html .
\n2. Access your phpmyadmin >> Choose database >> Click on SQL tab.
\n3. Type the SQL query as follow:
\nInto table city load data local in file \u2018Full path for .CSV file\u2019<\/p>\n
fields terminated by \u2018,\u2019<\/p>\n
enclosed by \u2018\u201d\u2018<\/p>\n
lines terminated by \u2018\\n\u2019<\/p>\n
Then actual full path should be replaced with \u201cFull path for .CSV file\u201d (\/home\/username\/public_html\/filename.csv)<\/p>\n
4. Then Click on Go.<\/p>\n","protected":false},"excerpt":{"rendered":"
You have to keep in mind few things to import successfully .csv files within the database from phpmyadmin. Make sure that you save your Excel file as a csv file. Please don’t save it as a workbook or the other format, check it with a text reader like notepad or similar. You’ll be able to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[],"class_list":["post-2196","post","type-post","status-publish","format-standard","hentry","category-web-hosting"],"yoast_head":"\n