SQL

Here's a quick and effective way to copy a MySQL database. I use it often during day to day database admin tasks.

mysqldump --single-transaction --routines -u root -prootpassword databasename > outputfile.sql