Skip to content

PHP code snippet – How copy database from myadmin?

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:"
4) Type in the name of the new database.
5) Select "structure and data" to copy everything.  Alternately, you can select "Structure only" if you want the columns but not the data.
6) Check the box "CREATE DATABASE before copying" to create a new database.
7) Check the box "Add AUTO_INCREMENT value."
8) Click on the Go button to proceed.
  
See also  Python code snippet - How to find columns in dataframe that start with prefix?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.