Duplicate MYSQL Database Same Server Without Using mysqldump

Question

I have a large database, "devDB" that I want to duplicate on the same server to become my live database, "liveDB". Can I make a duplicate without using mysqldump? Last time I used mysqldump it took a really long time. Seems like there could be a quicker way if its just a matter of copying the files. Can you create a new database and copy all the tables?

mysqldbcopy is the obvious answer.

IncredibleHat
– IncredibleHat

2018-04-10 14:31:27 +00:00
Commented Apr 10, 2018 at 14:31 — IncredibleHat
– IncredibleHat, Commented Apr 10, 2018 at 14:31

Michael · Accepted Answer · 2012-07-29 12:36:06Z

4

If you don't want to use mysqldump, create you databases/schema,

and copy the tables from one DB to the other:

 CREATE TABLE `liveDB.sample_table` SELECT * FROM `devDB.sample_table`;

answered Jul 29, 2012 at 12:36

Michael

2,8774 gold badges33 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dina Kaiser · Accepted Answer · 2012-08-08 08:54:58Z

0

Michael's answer above is a good idea if you want to put the newDB in the same MySQL instance as devDB. If you want to put liveDB on a separate Instance, you could use mysqldump to "pipe" the output directly into the "source" of liveDB, so that you could avoid Disk I/O. Also to improve performance, you could disable MySQL's binlog on the target DB while Inserting data.

answered Aug 8, 2012 at 8:54

Dina Kaiser

4763 silver badges6 bronze badges

Collectives™ on Stack Overflow

Duplicate MYSQL Database Same Server Without Using mysqldump

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related