Copying production database using Mysql

Question

I have a huge production DB of around 30GB using Mysql present in remote machine. I want to make a copy of that DB on my local Mysql setup. But I don't want to use SQL dump files.

Is there any alternative to make a copy of production DB to my local machine without using SQL dump files? Please tell me.

Thanks in advance.

Kamil · Accepted Answer · 2013-09-23 10:03:24Z

1

If you are using MySQL 5.x - you may use replication mechanism to make "mirror" database. You can run replication, then stop slave database and back it up very fast without stopping master database.

If you want to use it for backup - you can find more information here:

Using Replication for Backups at dev.mysql.com

answered Sep 23, 2013 at 10:03

Kamil

14k25 gold badges101 silver badges202 bronze badges

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

Collectives™ on Stack Overflow

Copying production database using Mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related