Importing data to a MYSQL Database using PhpMyAdmin

If you are planning to Import data to a MySQL Database, the first thing which need to check is the whether your data is in the right format. MySQL is best compatible with files in the CSV format. So, in case you have an Excel file you could save that file as a CSV File and you don’t need a special software to do that. All you would have to do is click on File from the Menu and select Save As and make sure the Format Type is CSV.

pl_phpmyadmin_2

Now once you have that checked off your list the next and final step is Importing this data to the MySQL Database. If you google this you would get many different explanations and ways which would make you confused. It might ask you to write SQL Queries which you totally don’t have to. If you are using PhpMyAdmin, the easiest and fastest way to do it is to use the Import Function in the menu. Saves you time creating a table and columns corresponding to the data.

Make sure you select the database, then click on the Import button, choose the file and format and Import!

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s