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

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...

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...

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...

MySQL-Front

Can I use MySQL Front to access my database?You can remotely connect to your database by using...

How to Create a MySQL Database?

A: 1. Login to your control panel 2. Click on "MySQL Databases" 3. Add database 4. Add database...