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

  • 46 Users Found This Useful
Was this answer helpful?

Related Articles

How to Create a MySQL Back-Up?

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

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

MySQL-Front

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

Mysql Database Creation

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

MySQL Connection Setting

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