1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Backing up my forum.

Discussion in 'XenForo Questions and Support' started by robbieswan, Feb 17, 2014.

  1. robbieswan

    robbieswan New Member

    Hi there, is there a way I can backup the forum on a regular basis easily, do I go to php admin and back up the databases?
     
  2. MattW

    MattW Well-Known Member

    Depends on how you want to back it up, and if you are backing up the database only, or all the files for the forum. Are you going to be storing the backups offsite on a different server / storage place?
     
  3. robbieswan

    robbieswan New Member

    I would like to backup everything really, I can store it on another server yes.
     
  4. MattW

    MattW Well-Known Member

    I personally have a VPS with Backupsy, and use that to store all my files on there. I installed Rsnapshot on there, and configured it to connect 4 times a day for full incremental backups. I also have another script which drops a copy of the database each night and copies that onto there as well.
     
  5. Amaury

    Amaury Well-Known Member

    There are various methods to back up a forum. I personally use phpMyAdmin.
     
  6. whynot

    whynot Well-Known Member

    That is only for a small database reliable.
    You think that you have a good backup but when you ever need it, it will fail you.
     
  7. Amaury

    Amaury Well-Known Member

    What's considered a small database? The last backup I took, which was on Friday, was 395 MB.
     
  8. whynot

    whynot Well-Known Member

    I wouldn't use it for more than 40 MB.
    Are you sure it was phpMyAdmin?
     
  9. Amaury

    Amaury Well-Known Member

    What I use? Yes.
     
  10. whynot

    whynot Well-Known Member

    Hopefully that backup is not corrupted.
     
  11. Amaury

    Amaury Well-Known Member

    Why would it be corrupt?
     
  12. Jeremy

    Jeremy XenForo Moderator Staff Member

    Downloading and generating a file of such a large size can be corrupt or fail with scripts creating them such as PHP.
     
    whynot likes this.
  13. Tracy Perry

    Tracy Perry Well-Known Member

    whynot likes this.
  14. Amaury

    Amaury Well-Known Member

    Then wait. All this time I've been taking backups, all of them have been corrupted?
     
  15. Tracy Perry

    Tracy Perry Well-Known Member

    Not guaranteed, but highly likely. Every large one I've ever done almost always had a corruption in it and would not restore.
     
    whynot likes this.
  16. whynot

    whynot Well-Known Member

    Unzip your backup on your computer.
    Compare it's size to the database's size on the server.
    Are they similar?
     
  17. Amaury

    Amaury Well-Known Member

    I don't need to unzip it, as the backup file is already there. Where do I check the size on the server, though?
     
  18. whynot

    whynot Well-Known Member

    On the server? That's a problem.
    When something's going on wrong on the server you will lose everything.

    In phpMyAdmin click on the database, on the right bottom it should show around 400 MiB.

    "The last backup I took, which was on Friday, was 395 MB."
    How do you know its size?
     
  19. Amaury

    Amaury Well-Known Member

    On my computer.

    Backup.png

    Anyway, server says 431.26 MB.
     
  20. whynot

    whynot Well-Known Member

    #1 The file could be corrupt.
    #2 There is difference between MB and MiB. Isn't that figure from the server in MiB?
     

Share This Page