Knowledge Base

How to Import and Export the MySQL Database with phpMyAdmin?

Importing and exporting your database is a significant skill which you need to have. Data dumps can be used for backup and restoration purposes so that older copies of your database can be recovered during emergency or those can be used to migrate data to a new server or development environment.

Database dumps in MySQL can be managed in a simple way. phpMyAdmin makes it easy and more efficient to manage the MySQL databases and also enables you to manage those available databases from any location. The ability of phpMyAdmin to import and export databases also helps to recover from any disaster and migrate a database from one server to another.  Also, as the import and export process occurs through a database, you don’t need to sit in front of the server for recovering your database.

You can export and import your database in the below formats with phpMyAdmin:

• SQL
• CVS
• CodeGen
• CVS for Microsoft Excel
• Microsoft Word 2000
• JSON
• LaTeX
• MediaWiki Table
• OpenDocument Spreadsheet
• OpenDocument Text
• PDF
• PHP Array
• Texy! Text
• YAML