SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Feb 2011
    Posts
    101
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Cron for database backup

    Hello guys,

    Is there a way to make a cron - Script, that takes all databases on a server, and back them up to a specific folder? etc /backup/mysql/ ?

    I'm using cpanel but I'm using the cpanel backup function already, but it only supports 1 task, so I can't say sunday night it should backup all user accounts, and friday night, just backup the databases.. Which is what I kinda need!

    Thank you

  2. #2
    Twitter: @TimIgoe silver trophy TimIgoe's Avatar
    Join Date
    Feb 2005
    Location
    Blackpool, UK
    Posts
    1,056
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)
    mysqldump is your friend - using this tool you can dump all databases out to an sql file

    You'll probably have to write a quick script to do this, one that you can then cron.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •