Home Forums Official Forum- Navsingh How to Copy a MySQL database in phpMyAdmin | cPanel

This topic contains 1 reply, has 2 voices, and was last updated by  Cathal 2 years, 10 months ago.

  • Author
  • #2321

    Nav Singh

    Hi, Warriors
    This tutorial will demonstrate how to copy or duplicate a database in phpMyAdmin.

    Begin by accessing phpMyAdmin via cPanel

    1-Select the database you wish to copy (by clicking on the database from the phpMyAdmin home screen).
    2-Once inside the database, select the Operations tab.
    3-Scroll down to the section where it says “Copy database to:”
    Type in the name of the new database.
    4-Select “structure and data” to copy everything. Alternately, you can select “Structure only” if you want the columns but not the data.
    5-Check the box “CREATE DATABASE before copying” to create a new database.
    6-Check the box “Add AUTO_INCREMENT value.”
    7-Click on the Go button to proceed.
    8-When you click on the home icon, you will notice your new database listed in the left column. If you go inside, you will see the database is a copy of the previous database

    Congrats, you can know successfully copy a MySQL Database in phpMyAdmin

  • #2432



The forum ‘Official Forum- Navsingh’ is closed to new topics and replies.