I'm helping a friend setup a cron job to backup his MySQL database. For your reference, here are some one liners to do that:
Backup to a text file: mysqldump -u root --password=PASSWORD MY_DB_NAME > MY_DB_NAME.sql
Backup to a compressed text file (replace gzip with zip or bzip2 or your favorite compression format): mysqldump -u root --password=PASSWORD MY_DB_NAME | gzip > MY_DB_NAME.sql.gz
Thursday, July 31, 2008
One line to backup your MySQL database
Subscribe to:
Post Comments (Atom)
1 comment:
Hello,
I'm Susan, of the TechnoSnack's team and I wish to inform you that we are opening a new blog aggregator about Computers & Internet news.
We put it on-line some hours ago and the link is: http://www.technosnack.com.
The main objective of this project is creation of a "virtual dashboard" of posts coming from many specialized blog and information about Computers & Internet world, with news about Linux, Windows, Mac, Open sources, Security, Graphics, Symbian and more on...
The key feature is that news come directly from blogosphere. We wish to show a preview of posts, with a link "Read more..." to signed blogs. If users are interested in news, they are redirected to your blog and can read entire post directly from your blog!
So, the different signed blogs can increase their visibility and reach more visitors, all over the world!
We think that in a little of time it can send more visitors to re gistered blogs, contributing to diffusion of know-how about Computer and Technology world.
I visited your blog and I think it has very interesting and useful posts!
So, are you interested in this idea, with your blog?
If yes, then you can register your blog, using the specific "Registration Form"!
REGISTRATION IS ABSOLUTELY FREE!
The only thing we ask to you is to insert TechnoSNACK banner in your blog to promote this project. Or, if you prefer, you can insert a link in your blogroll.
If you like (we whould be happy, but it is not mandatory :-), you can write a post regarding TechnoSNACK project in your blog, to promote this idea.
Bye!
Susan - TechnoSnack's Team
Post a Comment