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

XF 1.5 Database restore.

Discussion in 'Troubleshooting and Problems' started by andybond, Dec 18, 2015.

  1. andybond

    andybond Active Member

    I have been creating automagic database backups for the "just in case" disaster recovery and testing offline for some time.

    I have come to restore a recent backup and am having issues with the recovery. It looks like a conversation post is causing the issue as seen by

    Is there any way of killing this message on the live server , and therefore mitigation the error ?
  2. wang

    wang Well-Known Member

    Can you please post the full error message?
  3. andybond

    andybond Active Member


  4. andybond

    andybond Active Member

    I dare say it looks like my conversations that are causing teh issue , but I dont know how to recover.
  5. AndyB

    AndyB Well-Known Member

    How many posts does your forum have?

    How are you backing up?
  6. andybond

    andybond Active Member

    Backing up using an automated cron job that runs at 0300 - paid for app. Previous backups to a point worked.

    Approx 155k posts
  7. andybond

    andybond Active Member

    Appears to be a bounce log issue. Dare not drop that table on a live server
  8. wang

    wang Well-Known Member

    That table holds the emails that were not able to be delievered by the system. You can truncate it, but not drop it. If you are going to truncate it, make a backup of it before hand. In the worst case scanario, you can restore the table back.
  9. andybond

    andybond Active Member

    Thanks to @wang and @AndyB for the assistance.

    Exported , then truncated the table and backup is all good now.
    wang likes this.

Share This Page