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

Best way for backup.

Discussion in 'XenForo Questions and Support' started by dosc, Jul 27, 2012.

  1. dosc

    dosc New Member

    Adam Howard likes this.
  2. MOZ

    MOZ Well-Known Member

    We generally export the DB via phpmyadmin and get all the files of the community folder via CPanel File Manager.
  3. MattW

    MattW Well-Known Member

    Bash script which runs at midnight and copies the forum files to the remote server using rsync, and then another bash script drops the database at 4am via mysqldump, which is then uploaded to two different remote sites for rolling storage.
  4. Neil E.

    Neil E. Active Member

    dosc likes this.
  5. Neil E.

    Neil E. Active Member

    I'm just at the beginning stages of learning xenforo and am trying to follow the recommendations.

    "Shell access" means I have to change to a different server at my host. This will require a one time charge plus a monthly increase.
  6. akia

    akia Well-Known Member

    How does this work with large databases? does it have any impact on the server doing a mysqldump each night,
  7. MattW

    MattW Well-Known Member

    Doesn't cause any load on my VPS, but then, I've got just under 220k posts and 5k members, do it's not that big.

    I run the mysqldump with single transaction option so it doesn't lock any tables, but 4am there is hardly anyone using the forum anyway.

    Suppose you could set the niceness on the mysqldump to use less CPU is that would be an issue?

Share This Page