---
title: "How to Export a Table in phpMyAdmin"
description: "phpMyAdmin is a powerful MySQL database client that has many capabilities. We will be showing one of its features - the export table option. Exporting a table means that you will make a copy of the..."
url: https://www.inmotionhosting.com/support/website/phpmyadmin-export-table/
date: 2014-10-28
modified: 2026-01-22
author: "InMotion Hosting Contributor"
categories: ["Website"]
type: post
lang: en
---

# How to Export a Table in phpMyAdmin

**phpMyAdmin** is a powerful MySQL database client that has many capabilities. We will be showing one of its features – the export table option. Exporting a table means that you will make a copy of the table structures and its data. Caution should be taken whenever working with your database. ***Make sure that you make a current [backup of your database](/support/edu/cpanel/cpanel-backups/#database) before making any changes.* **

If you are exporting a table, you will be limited to 50 MB. Tables larger than 50 MB will require that you [submit a ticket to technical support](/support/amp/submitting-and-checking-on-status-of-tickets/).

## How to Export a MySQL Database Table

1. [Login to the cPanel](/support/edu/cpanel/how-to-log-into-cpanel/)
2. [](/support/images/stories/export-tables/phpmyadmin-icon.png)[](/support/images/stories/export-tables/phpmyadmin-icon.png)In the databases section, click on the icon labeled **phpMyAdmin**. This will launch the application and you will see the interface open with the list of databases that it can access listed on the left side.![Click phpMyAdmin](https://www.inmotionhosting.com/support/wp-content/uploads/2014/10/phpmyadmin-icon.jpg) 
3. [](/support/images/stories/export-tables/expand-table-list.png)[](/support/images/stories/export-tables/expand-table-list.png)Click on the plus sign (‘+’) next to the user name that appears in the column at left. This will expand the database list. Next, click on the plus sign (‘+’) next to the database that contains the table the you wish to export.![](https://www.inmotionhosting.com/support/wp-content/uploads/2014/10/expand-table-list.jpg)  
4. [](/support/images/stories/export-tables/table-to-export.png)[](/support/images/stories/export-tables/table-to-export.png)Click on the table name that you want to export. ![](https://www.inmotionhosting.com/support/wp-content/uploads/2014/10/table-to-export.jpg) 
5. [](/support/images/stories/export-tables/export-function.png)[](/support/images/stories/export-tables/export-function.png)In the top right of the phpMyAdmin interface, you should see a row of options starting with **Browse**. Click on **Export** in order to begin the export process.![Click on Export](https://www.inmotionhosting.com/support/wp-content/uploads/2014/10/export-function.jpg)  
6. [](/support/images/stories/export-tables/export-options.png)[](/support/images/stories/export-tables/export-options.png)In order to quickly export all of the data and the entire table structure, leave the **Quick** option selected. If you intend to be more selective, you would need to click on **Custom** in order to make changes to what will be exported. For the purposes of this tutorial, we will be exporting all of the table data, so please leave the option set to **Quick**. ![Select export options](https://www.inmotionhosting.com/support/wp-content/uploads/2014/10/export-options.jpg) 
7. [](/support/images/stories/export-tables/file-format-export.png)[](/support/images/stories/export-tables/file-format-export.png)The format of the exported file will be left as **SQL**. This can be changed by clicking on the drop-down arrow. However, to keep things simple, we are going to be using the default format of .SQL. Click on **Go** in order to start the export.  ![Select Format for export](https://www.inmotionhosting.com/support/wp-content/uploads/2014/10/select-file-format-export.jpg)

Depending on the size of the table, it may take some time for the export to occur. Also, your web browser will determine how the file will be handled and/or saved. For example, if the Downloads folder has been set in Firefox, then the exported file will be sent into that location. Other browsers may prompt you and ask for the location where the file should be saved. When the export completes, you will see the name of the file. Here’s an example of the text that you may see:

-- phpMyAdmin SQL Dump -- version 4.1.8 -- https://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Oct 21, 2014 at 10:12 AM -- Server version: 5.6.17-log -- PHP Version: 5.4.23 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; -- Table structure for table `ps_access` -- CREATE TABLE IF NOT EXISTS `ps_access` ( `id_profile` int(10) unsigned NOT NULL, `id_tab` int(10) unsigned NOT NULL, `view` int(11) NOT NULL, `add` int(11) NOT NULL, `edit` int(11) NOT NULL, `delete` int(11) NOT NULL, PRIMARY KEY (`id_profile`,`id_tab`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `ps_access` (`id_profile`, `id_tab`, `view`, `add`, `edit`, `delete`) VALUES (1, 0, 1, 1, 1, 1), (1, 1, 1, 1, 1, 1), (1, 2, 0, 0, 0, 0), (1, 3, 0, 0, 0, 0), (1, 4, 0, 0, 0, 0), (1, 5, 1, 1, 1, 1), (1, 6, 0, 0, 0, 0), (1, 7, 1, 1, 1, 1), (1, 8, 0, 0, 0, 0), (1, 9, 1, 1, 1, 1),

The file that is exported in *SQL format* is actually a text file and you can open it to see its contents. If you need to find anything in particular, use your favorite text editor and use the search options to find the text/data that you require. Exported tables can be imported back into a database.