cloning a live drupal website (db) to a local / working mamp version
I use this command to dump my databases which are hosted on Ubuntu:

mysqldump -uusername -p --databases db_name | gzip -f > db_name.sql.gz