Search Posts on Binpipe Blog

Take mysqldump without increasing server load

If you have a very high traffic website and you need to take the dump
the database without affecting the load of the sever then use the
following code snippet:

# mysqldump -u root -p --single-transaction --quick DATABASENAME > DATABASENAME.sql

No comments:

Post a Comment

Hi, Leave a comment here and one of the binary piper's will reply soon :)