What's the Easiest Way To Backup Multiple DB's regularly?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • nexcom28
    So Fucking Banned
    • Jan 2005
    • 3716
    #1

    What's the Easiest Way To Backup Multiple DB's regularly?

    Hello,

    Simple question, I have several sites that need the SQL databases backing up on a regular basis and either emailing to me or saving to desktop.
    What is the simplest/ best way to do this without manually having to do a backup.

    Ideally it wouldn't backup to FTP either (unless it's a different server)

    They would need backing up daily or perhaps weekly.
    Tags: None
    • nexcom28
      So Fucking Banned
      • Jan 2005
      • 3716
      #2
      Anyone?

      I guess some here bother to backup - no?

        Comment

        • PornDude
          I'm still broke.
          • Jul 2008
          • 3083
          #3
          http://www.phpmybackuppro.net/
          PornDude.com 🔥

          PornWebmasters.com 🤑

          MyGaySites.com 🤭

          PornDudeCasting.com 🚀

            Comment

            • baddog
              So Fucking Banned
              • Apr 2001
              • 107089
              #4
              Does your server have a control panel installed? If so, which one?

                Comment

                • alcstrategy
                  Confirmed User
                  • May 2012
                  • 124
                  #5
                  what db engine? I will assume mysql

                  i suppose you could write a script to run mysqldump and then mail it or whatever
                  schedule with cron

                    Comment

                    • Ferus
                      Bye - Left to do stuff
                      • Feb 2013
                      • 4102
                      #6
                      SQL or MySQL?

                        Comment

                        • shake
                          frc
                          • Jul 2003
                          • 4663
                          #7
                          Originally posted by nexcom28
                          Anyone?

                          I guess some here bother to backup - no?
                          I backup using the command line mySQL interface, but I wouldn't say that's the easiest unless you use the command line all the time anyway...
                          Crazy fast VPS for $10 a month. Try with $20 free credit

                            Comment

                            • jwerd
                              Confirmed User
                              • Jun 2003
                              • 1953
                              #8
                              Here's what I do via cron with mysql for one of my servers:

                              Code:
                              20 21 * * * mysqldump -u backup client_hightech | gzip -v9 - > /var/www/clients/nightlies/hightech_nightly.sql.gz
20 21 * * * mysqldump -u backup client_clinicazhen | gzip -v9 - > /var/www/clients/nightlies/clinicazhen_nightly.sql.gz
20 21 * * * mysqldump -u backup client_ics | gzip -v9 - > /var/www/clients/nightlies/ics_nightly.sql.gz
                              You could add more to it like date/timestamp, if you wanted.
                              Yii Framework Guru - Seasoned PHP vet - Partner @ XXXCoupon.com

                                Comment

                                • nexcom28
                                  So Fucking Banned
                                  • Jan 2005
                                  • 3716
                                  #9
                                  I could do with a cron job or something. It's just Cpanel and it's Mysql

                                    Comment

                                    • Ferus
                                      Bye - Left to do stuff
                                      • Feb 2013
                                      • 4102
                                      #10
                                      IF its MySQL, here is a few tools
                                      http://dev.mysql.com/downloads/tools/utilities/
                                      http://sourceforge.net/projects/phpbackup/
                                      http://www.digitalcoding.com/free-so...t-Windows.html

                                        Comment

                                        • evil0x
                                          Registered User
                                          • May 2013
                                          • 31
                                          #11
                                          Write\Google a script to mysqldump and move the file to your dropbox folder.
                                          Set cronjob to w\e...

                                            Comment

                                            • baddog
                                              So Fucking Banned
                                              • Apr 2001
                                              • 107089
                                              #12
                                              Originally posted by nexcom28
                                              I could do with a cron job or something. It's just Cpanel and it's Mysql
                                              I don't use cPanel but I am relatively confident they have a backup feature. That would probably be the easiest (via cron job)

                                                Comment

                                                • Klen
                                                  • Aug 2006
                                                  • 32234
                                                  #13
                                                  Jwerd method is easiest one.

                                                    Comment

                                                    • nexcom28
                                                      So Fucking Banned
                                                      • Jan 2005
                                                      • 3716
                                                      #14
                                                      Originally posted by baddog
                                                      I don't use cPanel but I am relatively confident they have a backup feature. That would probably be the easiest (via cron job)
                                                      I only just started using it this week, I didn't know that but I will look into it.

                                                      Thanks for all your answers. Hopefully I will get something sorted soon, these days you can't afford to fuck up.

                                                        Comment

                                                        • freecartoonporn
                                                          Confirmed User
                                                          • Jan 2012
                                                          • 7683
                                                          #15
                                                          i use simple shell script for that., it creates dump of db, and then uploads it to remote ftp...
                                                          SSD Cloud Server, VPS Server, Simple Cloud Hosting | DigitalOcean

                                                            Comment

                                                            • Zoxxa
                                                              Confirmed User
                                                              • Feb 2011
                                                              • 1026
                                                              #16
                                                              I don't think I have used a host in the past 5 years who didn't do daily db backups automatically, have you asked them?
                                                              [email protected]
                                                              ICQ: 269486444
                                                              ZoxEmbedTube - Build unlimited "fake" tubes with this easy 100% unencoded CMS!

                                                                Comment

                                                                Previous template Next
                                                                Working...