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.

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.

Large Mysql Database Export and Import Easiest way to export and import large MySQL database from one server to another server. Are you tired of the hassle of transferring hefty MySQL databases ...