How to create a dump
From Sandoz
(Difference between revisions)
Sandoz-admin (Talk | contribs) (Created page with " 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' >...") |
Sandoz-admin (Talk | contribs) |
||
| (One intermediate revision not shown) | |||
| Line 1: | Line 1: | ||
| - | |||
mysqldump -h ip -u disco -p(port) *password -d autosongpurchaser > /www/hosts/test/autosong_backup08072010.sql | 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 | 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 | ||
Latest revision as of 05:43, 17 February 2011
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
