I recently setup the script found at: http://wiki.dreamhost.com/Mysqldump
When I run the script, the site that is currently being dumped becomes unresponsive until it completes. My largest db is only 12MB, but it still made the site unresponsive for more than a minute. Does a dump place a lock on the entire database, or table when it runs? Is there someway around this?