Copying a Database Table with phpMyAdmin

Updated 28 September 2026 1 min read

Updated: 28 September 2026 · Applies to: phpMyAdmin 5.2 in cPanel & WHM 138

phpMyAdmin can copy a table within a database or to another database, for example to keep a copy before changes.

Open phpMyAdmin (in cPanel: Databases › phpMyAdmin) and click the database in the left panel.
Click the table, then open the Operations tab.
Under Copy table to (database.table), choose the target database and enter a name for the copy.
Choose what to copy: Structure only, Structure and data or Data only.
Click Go.

Note: Large tables take time to copy and use disk space. The copy has the same indexes, but foreign keys and triggers may need to be recreated.

Related services

KVM VPS hosting

NVMe SSD and full root access, with Free Basic Managed Support.

Managed cPanel VPS

cPanel included; we handle updates, security and monitoring.

Server management

on-demand administration, hardening, migrations and monitoring.