Mastering Operations in phpMyAdmin: A Comprehensive Tutorial

PHPMyAdmin provides a variety of operations for managing, organizing, and optimizing databases and tables on a MySQL or MariaDB server, serving a variety of purposes.

a) Database Operations

1. Log into PHPMyAdmin. (You can get your PHPMyAdmin URL inside your cPanel / Plesk).

2. Select the ‘source database’ which you wish to export from the drop down database menu at the left panel.

• Create table: Create a new table under the current database.
• Rename the database to: Rename database
• Copy the database to: Create a copy of the database
• Collation: Change database collation

b) Database Table Operations

1. Log into PHPMyAdmin. (You can get your PHPMyAdmin URL inside your cPanel / Plesk).

2. Select the ‘table’ which you wish to export from the drop down database menu at the left panel.

3. Click on the “Operations” tab in the top center panel and display three sections of operations, which are Move table to, Table options, and Copy table to.

• Move table to: Move the table with a new name to the current database or to a different database.
• Table options: rename table, insert comments, change storage engine, change collation.
• Copy table to: Copy the table under the current database with a new name, or copy it to another database.