The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Best way to backup all MySQL DBs on daily basis ?

Discussion in 'General Discussion' started by WebHostDog, Jun 19, 2007.

  1. WebHostDog

    WebHostDog Well-Known Member

    Joined:
    Sep 3, 2006
    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Website Owner
    Hello,
    I have tried via cpanel backup app. but seems is not working with MySQL only selected (needs accounts too). Any other cool way to backup server's MySQL DBs on daily basis ?



    Thanks,
     
  2. planmysite

    planmysite Registered

    Joined:
    May 1, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Daily Backups of MySQL DB w/ Navicat MySQL

    I would recommend Navicat MySQL for daily db backups. You just need to configure your remote host access, etc. This is a great remote admin tool for mysql and is easy to use!

    Here's a link to try it out:
    http://www.navicat.com/download.html

    Let me know what you think?
     
  3. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kingdom
    I would suggest taking a backup of the data folder containing all the databases in /var/lib/mysql by running a cron to make an archive of that directory.
     
  4. Scotty_B

    Scotty_B Active Member

    Joined:
    Mar 1, 2003
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Bear in mind that you won't get any InnoDB type tables doing that.
     
  5. nathacof

    nathacof Member

    Joined:
    Feb 28, 2007
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    Navicat is a paid product right?

    Why not use the free versions from MySQL (the MySQL GUI Tools):

    http://mysql.org/downloads/

    also while you're there type 'mysqldump --all-databases' into the search form.
     
  6. dempsey

    dempsey Active Member

    Joined:
    Jul 17, 2003
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
  7. AdamDresch

    AdamDresch Well-Known Member

    Joined:
    Jun 22, 2006
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    6
    Is there anyway to make that script backup to a remote server?
     
Loading...

Share This Page