# Copying a database table with phpMyAdmin

> Copy any database table in phpMyAdmin in just a few steps, with options to copy the structure, data, or both.

Source: https://www.kualo.com/knowledgebase/cpanel-databases/copying-a-database-table-with-phpmyadmin
Updated: 2026-06-11

---

phpMyAdmin lets you copy any database table quickly, giving you the choice to copy the table structure, its data, or both.

## How to copy a database table

1. Open phpMyAdmin and click the table you want to copy in the left-hand panel.
2. Click the **Operations** tab along the top of the page.
3. Scroll down to the **Copy table to (database.table)** section and choose what to copy:

   - **Structure only** - copies the table layout with no rows
   - **Data only** - copies the rows without recreating the table definition
   - **Structure and data** - creates a complete duplicate

   Enter a name for the new table, then click **Go**.

   ![The Copy table to section on the Operations tab in phpMyAdmin](https://kb-cdn.kualo.com/40/88/408818143b61a910672b920bb52dec784f858c03.png)

:::info
Copying a table creates a brand-new table with the name you provide. The original table is left untouched.
:::

4. phpMyAdmin confirms the operation and the new table appears alongside the original in the left-hand panel.


---

_Source: Kualo Knowledgebase — https://www.kualo.com/knowledgebase/cpanel-databases/copying-a-database-table-with-phpmyadmin · © Kualo Ltd._