Daily/weekly/monthly Mysql database backup with cron

Smart Mysql database backup with cron
Create and assign a DB user to the DB you want to backup with all privileges from your Cpanel >> Mysql section.
following is a simple script to take backup using cron. Just create the file, chmod it to 750 and execute it using cron.

#============================

#/bin/bash
/usr/bin/mysqldump –user=db_User –password=xyz –databases db_name | gzip > /home/foo/db_name-`date “+%Y%m%d%H%M”`.sql.gz

#============================

where,
db_user is your database user who has access on your database.
db_name is the database name you are scheduling backup for.
xyz is the actual password of above database user.
+%Y%m%d%H%M is the time stamp which will help to distinguish between backup date and time.
the backup destination in above example is “/home/foo/”

add following line in cron to take backup everyday at 23:00 and will store in separate file

0 23 * * * /PathToScript.sh

Security notes Note ::
1) Dont use the command directly in cron. Put the command in a file and execute that file in cron.
2) I asked to chmod to 750 so that other will not be able to view your files.
If the file is readable by others anyone may view it and get your DB access very easily.

Be Sociable, Share!

386 thoughts on “Daily/weekly/monthly Mysql database backup with cron”

  1. I¡¦ll immediately snatch your rss feed as I can’t to find your e-mail subscription link or newsletter service. Do you have any? Kindly let me recognise so that I could subscribe. Thanks.

  2. You really make it seem really easy along with your presentation however I to find this topic to be really one thing that I believe I would never understand. It sort of feels too complicated and very extensive for me. I’m having a look ahead for your next put up, I will attempt to get the cling of it!

  3. We are a group of volunteers and opening a new scheme in our community. Your web site provided us with valuable info to work on. You have done a formidable job and our entire community will be grateful to you.

  4. Hiya, I am really glad I have found this info. Today bloggers publish just about gossips and web and this is really annoying. A good blog with exciting content, this is what I need. Thank you for keeping this website, I will be visiting it. Do you do newsletters? Cant find it.

  5. Attractive section of content. I just stumbled upon your blog and in accession capital to assert that I acquire in fact enjoyed account your blog posts. Any way I’ll be subscribing to your augment and even I achievement you access consistently rapidly.

  6. Great post. I was checking continuously this blog and I’m impressed! Very helpful information specially the last part :) I care for such information a lot. I was seeking this particular information for a very long time. Thank you and best of luck.

  7. I simply couldn’t go away your web site before suggesting that I really loved the standard information an individual supply in your guests? Is gonna be back frequently to check out new posts

  8. You could certainly see your enthusiasm within the paintings you write. The arena hopes for even more passionate writers such as you who aren’t afraid to mention how they believe. All the time follow your heart.

  9. You’ll find it nearly unattainable to see well-aware men and women on this area, however, you look like you fully understand whatever you’re writing on! Many Thanks

  10. It¡¦s really a great and useful piece of information. I¡¦m satisfied that you shared this helpful information with us. Please keep us up to date like this. Thanks for sharing.

  11. My brother suggested I might like this website. He was totally right. This post truly made my day. You cann’t imagine simply how much time I had spent for this info! Thanks!

  12. Somebody essentially help to make significantly posts I might state. This is the first time I frequented your web page and thus far? I amazed with the research you made to make this actual put up incredible. Magnificent job!

  13. you’re really a excellent webmaster. The site loading speed is incredible. It kind of feels that you are doing any unique trick. In addition, The contents are masterpiece. you have performed a fantastic task in this topic!

  14. My Partner And I just need to advise you that I’m just fresh to blogging and thoroughly liked your site. Very likely I am likely to save your article post . You indeed have fabulous article reports. Delight In it for share-out with us your url information.

  15. I do agree with all of the ideas you’ve introduced on your post. They are very convincing and can certainly work. Nonetheless, the posts are very brief for beginners. May you please extend them a bit from next time? Thanks for the post.

  16. Thank you for another informative site. The place else could I get that kind of information written in such an ideal manner? I have a mission that I’m simply now running on, and I’ve been at the look out for such info.

  17. I leave a response each time I like a article on a site or if I have something
    to valuable to contribute to the discussion. It is triggered
    by the sincerness displayed in the article I read.

    And after this article Daily/weekly/monthly Mysql
    database backup with cron | RegencyHost Blog. I was moved enough to post a comment :-)
    I actually do have 2 questions for you if it’s okay.

    Could it be just me or does it look as if like a few of
    the remarks appear as if they are written by brain dead individuals?
    :-P And, if you are posting on other places, I would like to keep up with everything fresh you have to post.

    Could you make a list all of your communal sites like your linkedin profile,
    Facebook page or twitter feed?

  18. We’re a group of volunteers and starting a new scheme in our community.

    Your website provided us with valuable info to work on.
    You have done an impressive job and our entire community will
    be thankful to you.

  19. What you published made a lot of sense. However, what about this?
    suppose you were to create a awesome post title? I mean, I don’t
    wish to tell you how to run your blog, however what if
    you added a title that grabbed a person’s attention? I mean Daily/weekly/monthly Mysql database backup with cron | RegencyHost Blog is kinda boring.
    You ought to look at Yahoo’s home page and see how they write article titles to grab viewers to open the links.
    You might add a related video or a related picture
    or two to get people excited about what you’ve written. In my opinion,
    it could bring your posts a little bit more interesting.

  20. I think that everything said made a great deal of
    sense. However, what about this? what if you were to create a killer title?

    I am not suggesting your information is not solid., however
    suppose you added a headline that makes people desire more?
    I mean Daily/weekly/monthly Mysql database backup with cron | RegencyHost Blog is
    a little plain. You should glance at Yahoo’s
    front page and note how they create news headlines to grab people to click.
    You might add a related video or a related pic or
    two to get people interested about everything’ve written. In my opinion,
    it would make your posts a little livelier.

  21. Hey very cool website!! Man .. Excellent .. Superb ..
    I will bookmark your website and take the feeds additionally?
    I am glad to search out so many useful info right
    here in the publish, we need develop extra strategies
    on this regard, thank you for sharing. . .

    . . .

  22. Proactol is also used as remedy for aches and pains. Now removing that stubborn fat
    from your body is easy with the Zerona Fort Lauderdale.
    After eight it’s too late, avoid late night dinner.

  23. I was suggested this web site by way of my cousin. I’m no longer positive whether or not this
    submit is written through him as no one else realize such certain approximately my problem.
    You’re wonderful! Thank you!

Leave a Reply

Your email address will not be published. Required fields are marked *

Connect with Facebook

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>