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

Backing up and restoring

Discussion in 'Troubleshooting and Problems' started by Alan Feuerstein, Jan 8, 2011.

  1. Am I missing something? I don't see any way to backup or restore the xenforo database through xenforo. That's one of the things I really liked about phpbb3, it made regular backups a breeze, and made moving the forums and making test forums really fast and easy. I see the import option (used it to import from vb4, but it's a bit more complicated, and only has vbulletin options.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    There is no backup option in the ACP.

    If you have access to phpMyAdmin then you can do it from there.

    It's worth mentioning that everything except avatars and attachments (plus any custom images) is stored in the database so there is no need to backup the server files apart from the /data and /internal_data directories.
     
  3. Hrm, that's too bad. Time to zip over to the suggestions forum, I guess!

    Thanks.[​IMG]
     
  4. Kaiser

    Kaiser Well-Known Member

    Yes I really liked that about phpbb also..
     
  5. steven s

    steven s Well-Known Member

    I really like using automysqlbackup.sh
    http://sourceforge.net/projects/automysqlbackup/
    Set up as a cron job and forget about it.
    Then backup all your files on a routine basis.

    And once your database gets too big you can't use phpmyadmin or cPanel.
    For me, I time out and the server load goes through the roof.
     
    Digital Doctor likes this.
  6. I'm gonna look into that, thanks.

    I have another question though, in the mean time (because my database is NOT that big right now), and I need to backup while I figure out your link...

    Can anyone explain what, if anything, is the difference between backing up my xenforo database through phpmyadmin and backing it up through the CPanel backup wizard?
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    I've never used the cPanel Backup Wizard but there should be no difference if you select just the MySQL Databases option.
     
  8. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Both methods work well. But the CPanel backup can handle larger databases that phpmyadmin cannot. So if phpmyadmin fails then try CPanel.

    The best backup method is a shell command. See this guide.
     
  9. steven s

    steven s Well-Known Member

    My vB3 forum database is 1G. I use a program, Backupsmart which downloads database files through cPanel. The serverload goes very high and eventually takes down my site.
    So even cPanel has it's limits. Or maybe it's my server?
    For those who do not have shell access, or are intimated like me, I've been using the program in post 5 to save the database to my website and use Backupsmart to download all my files late at night.
    It's been working out very well. To back up all my sites to my local drive it takes probably 4 hours.
     

Share This Page