Not Solved Alternative way to backup data and structure?
#3
Not Solved
(2018-09-12, 08:23 AM)frostschutz Wrote: If the backup of the host is complete and the only problem is it being "x hours ago"... find out which time of day they create the backups, then put the forum in maintenance mode an hour before that (so no more changes can be made) and move the forum the moment the backup is available.

I'll try that.

Quote:Which version of MyBB are you using and how doesn't the ACP backup work? What's the error message etc.?

1.8.17

Error message when trying to make a complete backup with ACP:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2006 - MySQL server has gone away
Query:
SHOW FULL TABLES FROM databasename_forum WHERE table_type = 'BASE TABLE' AND Tables_in_databasename_forum = 'mybb_privatemessages'

Quote:The ACP also lets you backup each table individually so if it struggles to backup all tables at once, you can try making a separate backup just for the posts table, privatemessages table, (those two are likely the largest ones depending on user activity) and then everything else.

This is the error message I got when I tried to backup the posts table separately:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2006 - MySQL server has gone away
Query:
INSERT INTO mybb_adminlog (uid,ipaddress,dateline,module,action,data) VALUES (1,X'55e107c1',1536741069,'tools-backupdb','backup','a:2:{i:0;s:4:\"disk\";i:1;s:97:\"/home3/databasename/public_html/forum/_______/backups/backup___________.sql.gz\";}')
Reply


Messages In This Thread
RE: Alternative way to backup data and structure? - by amanda_2011 - 2018-09-12, 08:45 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)