We are assuming that you already have phpMyAdmin and a .csv file with structured data. Many hosts are providing phpMyAdmin by default installed like easyhosted.com.
So we will import our data from a .csv file our data. This import will create a new SQL database.
steps to correctly create a database from phpMyAdmin with the import of a .csv file:
- Log in to your phpMyAdmin account.
- Select the database you want to import the .csv file into or create a new database.
- Click on the “Import” tab located in the top navigation menu.
- Click on the “Choose File” button and select the .csv file you want to import.
- Select “CSV” as the format of the file.
- Configure the options under the “Format-specific options” section, such as the character set, field delimiter, and field enclosure. These options should match the settings used in your .csv file.
- Click the “Go” button to start the import process.
- If the import is successful, you will receive a confirmation message. If there are errors, check the .csv file for correct formatting and try the import again.
- After importing the .csv file, you can verify that the data has been properly imported by browsing the tables within the database.
Note: If you’re importing a large .csv file, it may take several minutes to complete the import process. Be patient and wait until the process is finished.
Add to this article to my favorites list!