DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

MySQL Dump Entire Database

01.27.2008
| 6098 views |
  • submit to reddit
        
mysqldump -v --quick --single-transaction --all-databases -uroot > file.sql
mysqldump -v --quick --single-transaction --all-databases -h internal-db.s1939.gridserver.com -udb1939 -pPASSWORD > mt_all.sql