This is the first article on our series on phpMyAdmin. phpMyAdmin is the most popular free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser.
Most PHP web hosting company provide this tool for their client to easily and conveniently manage MySQL database.
Am going to be teaching us how to duplicate a database and a given table via phpMyAdmin. follow the tutorial below to learn how to do it.
How To Duplicate Or Copy A Database
- Log into phpMyAdmin, select the database that you wish to copy.
- Click the “Operations” tab which appears in the tabs near the top of the page in the right frame.
- There are then three radio options:
structure only: this will create a copy of the table with the name you specify but won’t copy the data.
structure and data: this will create a copy of the database and it’s data.
data only: this will copy the data but won’t copy the database structure. - There are also a check options:
CREATE DATABASE before copying: when this option is checked, a database with the specified name will be created before the copy will be done.
Add DROP TABLE / DROP VIEW: only checked this when you want to drop the table that you are copying to before creating the table and copying the data.
Add AUTO_INCREMENT value: By default this is not done and the auto increment value will end up being whatever it would be after the INSERT INTO query is done. If checked then the CREATE TABLE syntax will include the auto increment value from the original table.
Add constraints: this is rather advance for beginners. but if you may know – SQL constraints are used to specify rules for the data in a table. If there is any violation between the constraint and the data action, the action is aborted by the constraint. - Hit the Go button to start the duplicating or copy process.
How To Duplicate Or Copy A Database
- Log into phpMyAdmin, select the database and then the table that you wish to copy
- Click the “Operations” tab which appears in the tabs near the top of the page in the right frame.
- You can either make a copy of the table to the current database, which is selected by default from the database drop down box, or copy it to another database for which you have the appropriate permissions and hit the GO button.
