sql - DB copy within MySQL that is faster than `mysqldump`? -
i have production db i'd copy dev. unfortunately takes hour operation via mysqldump | mysql
, curious if there faster way via direct sql commands within mysql since going same dbms , not moving dbms elsewhere.
any thoughts / ideas on streamlined process perform inside of dbms eliminate long wait time?
note: primary goal here avoid hour long copies need data production in dev db. not question locking or replication. wanted clarify based on comments including more info / ancillary remarks should have initially.
you set slave replicate production db, take dumps slave. allow production database continue operating normally.
after slave done performing backup, catch master.
http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-backups-mysqldump.html
Comments
Post a Comment