How to create a dump
From Sandoz
Revision as of 05:43, 17 February 2011 by Sandoz-admin (Talk | contribs)
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
