How to create a dump

From Sandoz

mysqldump -h ip -u disco -p(port) *password -d autosongpurchaser > /www/hosts/test/autosong_backup08072010.sql

mysqldump -h 127.0.0.1 -u 'root' 'music_social_development' > /users/sandrine/documents/share/mysql_staging_dump_10082010.sql

Restore

mysql -u -p database_two < /var/www/backups/table_name.sql