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

Popular posts from this blog

php - cannot display multiple markers in google maps v3 from traceroute result -

php - Boolean search on database with 5 million rows, very slow -

css - Text drops down with smaller window -