In phpMyAdmin, how can I copy a database?

This tutorial will show you how to use phpMyAdmin to copy or duplicate a database. Begin by logging in to phpMyAdmin through cPanel or Plesk. The steps stated in the video guide above are listed below.

  • Go to your phpMyadmin.

Screenshot 1 6 300x76 1

  • Choose the database you want to replicate from the drop-down menu (by clicking on the database from the phpMyAdmin home screen).

Screenshot 2 4 300x141 1

  • Select the Operations tab once you’ve entered the database.
  • Go to the section where it says Copy database and scroll down.
  • Fill in the new database’s name.

Screenshot 3 4 300x183 1

  • To replicate everything, select structure, and data. You can also choose Structure Only if you only want the columns and not the data.
  • To build a new database, check the box CREATE DATABASE before transferring.
  • Make sure the box Add AUTOINCREMENT value is checked.
  • To continue, click the Go button.
  • Select the Home icon.

Screenshot 4 2 300x196 1

  • In the left column, you’ll see your new database listed. If you look inside, you’ll notice that the database is a duplicate of the prior one.

Screenshot 5 4 300x251 1

The post In phpMyAdmin, how can I copy a database? appeared first on cPanel Plesk.

cPanel cPanel Guides Internet Linux Administration Linux Tutorials Technology Web Hosting Guides