I had the need to do a backup and compress a mysql database, so this is how I did it.
mysqldump --opt databasename -uUsername -p | gzip > databasename.sql.gz
Backing up a mysql database
Leave a Comment
SysAdmin Valley
I might as well write this stuff down so I remember it tomorrow
Recent Posts
Tag Cloud
Categories
- Amazon AWS (2)
- fun (2)
- linux (28)
- mysql (3)
- networking (5)
- security (4)
- Uncategorized (5)
- Windows (2)
Archives
- May 2010 (2)
- March 2010 (6)
- February 2010 (5)
- October 2009 (2)
- September 2009 (3)
- August 2009 (2)
- July 2009 (1)
- June 2009 (2)
- May 2009 (1)
- February 2009 (2)
- January 2009 (3)
- December 2008 (13)