SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Addict SitePointer's Avatar
    Join Date
    Oct 2001
    Location
    SitePoint
    Posts
    317
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL Backup softwares

    Hi,

    I am looking for a software to help me backup the databases of my websites weekly.

    I found these 3. Which one do you think is better?

    http://www.dswsoft.com/mbw.php
    http://www.richtsoft.com/dump_56_mysql/
    http://www.swordsky.com/products.html

  2. #2
    Ribbit... Eric.Coleman's Avatar
    Join Date
    Jun 2001
    Location
    In your basement
    Posts
    1,268
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You know, you have the free mysqldump command utility that's already isntalled on your server

    http://www.google.com/search?q=backu...th%20mysqldump
    Eric Coleman
    We're consentratin' on fallin' apart
    We were contenders, now throwin' the fight
    I just wanna believe, I just wanna believe in us

  3. #3
    SitePoint Addict SitePointer's Avatar
    Join Date
    Oct 2001
    Location
    SitePoint
    Posts
    317
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am already doing my database backups via Putty SSH and Mysqldump. But it isn't that easy when you need to do weekly backup for 40 mysql databases.

    This is why I am looking for a backup tool to lesser my workload.

  4. #4
    SitePoint Wizard HarryR's Avatar
    Join Date
    Dec 2004
    Location
    London, UK
    Posts
    1,376
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,
    The solution you're looking for is free.. with a little tweaking. Generally I'm just that kinda person, but I don't see it worth spending additional money to buy an 'automated backup solution' when I can knock one up in about two hours or so.

    So my way to get around this problem is to just create a cronjob on my workstation to do the backups, the script the cronjob runs is as such: it logs into the target server using ssh and runs the mysqldump command with the parameters you specify. It then pipes the output of mysqldump into the appropriate local file.

    I'm not sure how you would go about donig this in Windows, but you'd probably need to install either cygwin or msys because normally Windows doesn't come with the tool you'd need to get this done.

    <edit>
    You can grab it from http://webcentre.colegsirgar.ac.uk/~...backup.tar.bz2 (works over ssh+mysqldump and just using mysqldump, supports archiving etc.
    </edit>

    Regards,
    - Harry
    Last edited by HarryR; Jun 16, 2005 at 01:42. Reason: Added URL to my MySQL remote backup script

  5. #5
    Ribbit... Eric.Coleman's Avatar
    Join Date
    Jun 2001
    Location
    In your basement
    Posts
    1,268
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In windows, I think you can run it as a scheduled task

    And Thanks for posting about the cron stuff, that's exactly what I was talking about
    Eric Coleman
    We're consentratin' on fallin' apart
    We were contenders, now throwin' the fight
    I just wanna believe, I just wanna believe in us

  6. #6
    SitePoint Wizard HarryR's Avatar
    Join Date
    Dec 2004
    Location
    London, UK
    Posts
    1,376
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Eric.Coleman
    In windows, I think you can run it as a scheduled task
    Yes, you can run it as a scheduled task, but as standard Windows lacks the tools to do it.

    As an addition to cygwin and msys, Microsoft also have the SFU (Services for Unix) product which is now freely available (although under a more restrictive license compared to the others), I might be mistaken but it also has a cron service.

    From what I've seen my tool basicly does what the two commercial offerings do, but it's free, only took 20 minutes to write.. and ofcourse there is no UI.

  7. #7
    does not play well with others frezno's Avatar
    Join Date
    Jan 2003
    Location
    Munich, Germany
    Posts
    1,391
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    On Windows RoboCopy might do the job
    We are the Borg. Resistance is futile. Prepare to be assimilated.
    I'm Pentium of Borg.Division is futile.Prepare to be approximated.

  8. #8
    SitePoint Addict SitePointer's Avatar
    Join Date
    Oct 2001
    Location
    SitePoint
    Posts
    317
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I got Backup Watcher for MySQL. Still trying to get it to work. Support not very responsive.


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
  •