As the manual says in Copying Databases you can pipe the dump directly into the. I can see you said you didn’t want to use mysqldump , but I reached this . The new database must exist already.
The -d flag in the mysqldump command prevents copying of data . Is it posible to duplicate an entire MySQL database on a linux server? First create the duplicate database: CREATE DATABASE duplicateddb;. The mysql command line client will accept a stream of SQL statements from standard input.
You can therefore pipe the output of mysqldump directly . Begin by accessing phpMyAdmin via cPanel or Plesk. Select the database you wish to copy (by clicking on the database from the phpMyAdmin home screen). Make a dump of your source database: Copy. Or, if you only want to dump the database’s table structure . How to use phpMyAdmin to copy a MySQL database. This article describes how to copy a MySQL database using phpMyAdmin.
This tutorial shows you how to copy a MySQL database on the same database server and from a database server to another.