10 {{ upvoteCount | shortNum }}
10 {{ upvoteCount | shortNum }}

Scripts to backup databases on one's web server

by Francis Miller
9 replies
Can anyone recommend any scripts that automatically backup databases on one's web server eg. forum databases?

Thanks,

Francis
#backup #databases #scripts #server #web
  • Profile picture of the author electrobooks
    Hi francis,

    There was one around called DB backup generator or something like that. It was a PHP script that ran on your server and would back up any database that you have (I think even on other servers).
    Im pretty sure I had PLR to it but the guy who wrote it released a 2nd version.

    PM me if you want me to dig out my version 1 copy.

    Happy hunting

    Chris
    {{ DiscussionBoard.errors[253398].message }}
    • Profile picture of the author Francis Miller
      Hi Chris,

      Thanks for telling me about DB Backup Generator - and thanks for the offer. I'll have a look first at v2.

      Francis
      {{ DiscussionBoard.errors[255065].message }}
      • Profile picture of the author radhika
        For forums and big databases, better do it thru telnet.

        Ask your host to enable telnet and run this command:

        mysqldump -u mydb_user -p***** mydb_members > /home/USER/public_html/backup.sql

        RESTORING:
        mysql -u mydb_user -p***** mydb_anotherDB < /home/USER/public_html/backup.sql

        .
        Signature
        Follow up Autoresponder PRO :: 33% Discount!!
        FREE Upgrades! IMPROVED Email Deliverability!!
        {{ DiscussionBoard.errors[255151].message }}
        • Profile picture of the author Francis Miller
          Thanks, radhika. I'll have a look at that option as well.
          {{ DiscussionBoard.errors[255257].message }}
  • Profile picture of the author Steve Garratt
    I'm also looking for serious backup solutions. I'm working on a project that has a database thay I'm expecing to grow at the rate of 2GB per month. I need to have it fully backed up on a remote server every few hours and I can't stop user activity while it's being backed up.

    I'm a programmer but so far I haven't found a workable solution to this problem. Can anyone point me in the right direction please?

    Steve
    Signature
    Please visit my blog and if you have an interest in electronics then please join me at Home DIY Electronics
    {{ DiscussionBoard.errors[255320].message }}
    • Profile picture of the author schabotte
      What might work for the large database is a mirroring solution. There is software available for linix that will keep a live database and a remote database in sync in real time.

      Do a search on google for something like remote database sync and you will start to find some discussion on this. You might need to do some additional searches to nail down the solution that will work for you but there are no cost solutions out there for this task.
      {{ DiscussionBoard.errors[255476].message }}
      • Profile picture of the author Steve Garratt
        Originally Posted by schabotte View Post

        What might work for the large database is a mirroring solution. There is software available for linix that will keep a live database and a remote database in sync in real time.

        Do a search on google for something like remote database sync and you will start to find some discussion on this. You might need to do some additional searches to nail down the solution that will work for you but there are no cost solutions out there for this task.
        Thanks schabotte,

        I'm thinking that mirroring might be my best bet so I will take your suggestion and hunt around for solutions.

        Steve
        Signature
        Please visit my blog and if you have an interest in electronics then please join me at Home DIY Electronics
        {{ DiscussionBoard.errors[255723].message }}
  • Profile picture of the author MikeAmbrosio
    DBG Version 2 is not ready yet, but soon.

    Running telnet commands works great, but the problem I ran into when I used to be a webhost is that so many people did not know how to do that, did not have telnet software of any kind, etc. And most importantly - not automated!

    DBG was designed to be a hands off solution. Set it up, set your frequency and your storage destination and then don't worry.

    Version 2 will have the ability to also store your backups to S3 - which is real handy with those extra large databases

    If anyone is interested, I will run a version 1 WSO, which will include a V2 upgrade. That will be cheaper than V2. The free upgrade offer is only valid via the WSO (if I hold one). DBG1 owners WILL get a substantial discount (bear in mind that V2 is a complete rewrite. There will be no upgrade per se... you'll have to do a fresh install).

    Mike
    Signature

    Are you protecting your on line business? If you have a website, blog, ecommerce store you NEED to back it up regularly. Your webhost will only protect you so much. Check out Quirkel. Protect yourself.

    {{ DiscussionBoard.errors[255653].message }}
    • Profile picture of the author Francis Miller
      Originally Posted by MikeAmbrosio View Post

      ........If anyone is interested, I will run a version 1 WSO, which will include a V2 upgrade. That will be cheaper than V2.......

      Mike
      Mike,

      I'd be interested in a WSO on this. Any idea when it might be and when v2 will be ready?

      Francis
      {{ DiscussionBoard.errors[256506].message }}

Trending Topics