When you make a new table, MySQL creates a file with your table name and a .ibd file extension. And this is the default behavior. Unless you turn off the innodb_file_per_table system variable.

In my previous post I have explained about How to Export MySQL table data to CSV File using PHP. Now in this tutorial I am going to explain how to import CSV data file into mysql. Suppose that we have ...

Migrating a database is as simple as selecting the database in the left column, clicking the Export link, and saving the database to a file.