İMPaRaToR Member Dec 20, 2016 #1 Hi guys, When I get a MySQL backup, XenForo becomes unusable. Other sites on the server continue to work perfectly. The problem is only for xenforo and I think the reason for this might be the table structure. What can be done to solve this problem?
Hi guys, When I get a MySQL backup, XenForo becomes unusable. Other sites on the server continue to work perfectly. The problem is only for xenforo and I think the reason for this might be the table structure. What can be done to solve this problem?
P Paul B XenForo moderator Staff member Dec 20, 2016 #2 How are you backing up? If you are doing it via SSH, you can use '--single-transaction --skip-lock-tables'. Upvote 0 Downvote
How are you backing up? If you are doing it via SSH, you can use '--single-transaction --skip-lock-tables'.
İMPaRaToR Member Dec 20, 2016 #3 Brogan said: How are you backing up? If you are doing it via SSH, you can use '--single-transaction --skip-lock-tables'. Click to expand... Many thanks @Brogan , the problem is solved. Upvote 0 Downvote
Brogan said: How are you backing up? If you are doing it via SSH, you can use '--single-transaction --skip-lock-tables'. Click to expand... Many thanks @Brogan , the problem is solved.
![[GH]c0de](/community/data/avatars/s/249/249784.jpg?1701365946){kind=avatar}
