I have attempted to backup four different courses this afternoon, all of which failed and with consistent debug messages. If someone might be so kind ... to take a look at the attached file which contains the debug messages i received on the last page of the backup attempt.
I would greatly appreciate the help in resolving this issue.
russ
Hi Russ,
those "MySQL server has gone away" use to happen by some different causes:
- wait_timeout (MySQL conf variable).
- Old MySQL version running. Those errors were more frequent in MySQL 4.x versions when big packages were used.
- Sudden DNS / firewall / network problems, where access to MySQL (usually port 3306) is denied.
- Problems with threads in the OS you are running MySQL (recent update of OS / MySQL?).
- Incorrectly upgraded MySQL (from 4.x to 5.x). You'll need to repair all them, see this link.
In any case, the query showed in you attachment seems to be 100% correct (it's a trivial one), so I don't think it's the cause for your problem.
I'd try to repair all the tables, then try, then upgrade MySQL to a newer version, then try...
Hope it helps, ciao
those "MySQL server has gone away" use to happen by some different causes:
- wait_timeout (MySQL conf variable).
- Old MySQL version running. Those errors were more frequent in MySQL 4.x versions when big packages were used.
- Sudden DNS / firewall / network problems, where access to MySQL (usually port 3306) is denied.
- Problems with threads in the OS you are running MySQL (recent update of OS / MySQL?).
- Incorrectly upgraded MySQL (from 4.x to 5.x). You'll need to repair all them, see this link.
In any case, the query showed in you attachment seems to be 100% correct (it's a trivial one), so I don't think it's the cause for your problem.
I'd try to repair all the tables, then try, then upgrade MySQL to a newer version, then try...
Hope it helps, ciao
Thanks, Eloy.
If only I knew anything about tables. Wouldn't know where to start.
russ
If only I knew anything about tables. Wouldn't know where to start.
russ