Announcement

Collapse
No announcement yet.

How often do you back up your database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #31
    What is a backup?
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #32
      One of those things that gets lost on my ToDo list. Pshhhhh. Who needs backups
      Trent Gillespie Mod Theater Gillespie Photography

      Comment


      • #33
        It sounds like you did this backup via the vBulletin Admin CP
        I did it that way. Isnt that what is for?

        I dont understand much about web languages or techie talk so the other one you mentioned is waaaaaay over my head. sorry
        TopDog

        Comment


        • #34
          The most 'techie' way is via Telnet. This is taken from vBulletin userguide.
          Step One - Backup current database:
          • Telnet/SSH into your system (we'll call it machine1)
          • from the root directory, type
            mysqldump --opt -uUSERNAME -p databasename > /path/to/dump.sql
          • this should only take about than 30 seconds to a few minutes, depending on your database size
          • when it is completed, it will bring you back to the prompt
          • verify that you have a dump.sql in the /path/to area you specified
          • That is taking into consideration you know how to open Telnet and connect. This way has proven faster and very reliable to me.
          Trent Gillespie Mod Theater Gillespie Photography

          Comment


          • #35
            Thank you for taking the time to reply tgillespie. All that kind of stuff goes way over my head though
            I've heard of Telnet through these forums but other than that it means noting to me.

            Thank you anway
            TopDog

            Comment


            • #36
              Telnet is a way to connect directly to a remote Unix/Linux machine and run commands directly on that machine. Considered insecure, Telnet has pretty much been replaced with ssh (secure shell).

              The Windows equivalent is called Windows Terminal Server and has various front-ends like PCAnywhere and Citrix Terminal.

              http://searchnetworking.techtarget.c...213116,00.html
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud demonstration site.
              vBulletin 5 API

              Comment


              • #37
                sadly my host doesn't allow me telnet or ssh but i can still run cron jobs so that's something at least.

                I backup every few months, but i really mean to backup every few days... I just get lazy

                Comment


                • #38
                  Originally posted by Babylon
                  sadly my host doesn't allow me telnet or ssh but i can still run cron jobs so that's something at least.

                  I backup every few months, but i really mean to backup every few days... I just get lazy
                  There is a script in the MySQL forum that you can run as a cron job. It will backup your forum and you can have them emailed to you on your schedule.
                  Translations provided by Google.

                  Wayne Luke
                  The Rabid Badger - a vBulletin Cloud demonstration site.
                  vBulletin 5 API

                  Comment


                  • #39
                    Originally posted by Wayne Luke
                    There is a script in the MySQL forum that you can run as a cron job. It will backup your forum and you can have them emailed to you on your schedule.
                    Thanks, i'll have a look for it
                    I was writing my own but i got lazy again

                    Comment


                    • #40
                      I have never backed up my database, and my site has been up running for 350 days now. Very close to our one year birthday. Also, the DB is about 65MB, and I have a slow download speed (11kb/s, IDSN line).

                      Comment


                      • #41
                        Once a week
                        | DiscBurn | CD & DVD Replication services, film and VHS to DVD, and duplication equipment
                        |
                        Disc On Demand | Short-run CD & DVD duplication... all online.

                        Comment


                        • #42
                          gzipping, or even bzipping usually shrinks the SQL file 10 fold.
                          Raz - KMC Forums

                          Comment


                          • #43
                            Every Friday.
                            WaterWolfDomains
                            http://www.WaterWolfDomains.com
                            Email: [email protected]

                            Comment


                            • #44
                              Originally posted by Water[EFE]
                              Every Friday.
                              Every 12 hours backup and gzip by cron with 4 backups in case something is wrong with one, or two, or three. We also back up the site daily, and I drop a copy to my hdd every 2 weeks or so.

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...
                              X