How to Copy a MySQL database in phpMyAdmin | cPanel

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, 2 months ago.

  • Author
    Posts
  • #2321 Reply

    Nav Singh
    Keymaster

    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 Reply

    Cathal

    sweet

Reply To: How to Copy a MySQL database in phpMyAdmin | cPanel
Your information:




Official Forum

This is the Official Forum of Navsingh a community that helps you find answers to all of your problems,they can be Java/programming,wordpress,android, android programming, seo related or technology related