How to Export/Save MySQL using Phpmyadmin

How do I export and import a mysql db using PHPMyAdmin?
Step 1:

Open phpMyAdmin and select the database from where you want to export data and/or structure. Go to the tab with "Export". Select the table(s) you want to save. Select the option you need: Data only or data and structure or structure only:


--> if you only want to update a table on another server, which has a table with the same structure, then you choose data only


--> if you want to create a new table on another server (for instance, if you have a development environment and you now want to put your application in production) then choose structure only


--> if you are moving a complete table, choose data and structure


Select "save as file"


Hit "go"


You can now enter a filename and specify where the file needs to be saved. It's recommended to choose a meaningful filename that includes the date. Like "shop_05_07_03.sql"


This creates the dumpfile. The dumpfile can be viewed using text editor

  • 17 Users Found This Useful
Was this answer helpful?

Related Articles

MySQL Connection Setting

* What are the connection settings for my MySQL database?*What is my database name, my database...

PHP Extension "pdo_mysql" must be loaded error.

We do not have Pdo_MYSQL for shared hosting.Faster server due to this components not suitable...

How to Create a MySQL Back-Up?

A: Step 1: Login to your control panel Step 2: Click on MySQL databases Step 3: Scroll to the...

Mysql Database Creation

You can check in Cpanel MYSQL database. If you have not created database please do so in Cpanel...

How to Restore your MySQL Database?

A: 1. Login to your control panel 2. Click on MySQL databases 3. Scroll to the bottom and click...