OJB Posted September 28, 2007 Posted September 28, 2007 Hey guys, Recently I have had a few issues which I didnt have before when it comes to backing up. The problem occurs when I backup my forum database. From the period between starting the backup and it finishing I am unable to access the forum itself, and occasionally I will even get a too many connections MySQL error at which point I contact the help desk to get them to reset the connections for me. Is there any reason why EVERY time I backup my forum (which is the main aspect of my site and the .gz file is 26MB) it becomes inaccessible?? I understand that taking a backup uses up SQL queries and connections but I would not have thought it would stop my forum from working every time I do it. I am going to try install the dbsender script that I just read when searching the forums to see if this works without freezing my forum. Any ideas of why its doing this and/or what I can do to fix it because sooner or later the help desk are going to get fed up of me. Quote
TCH-Andy Posted September 28, 2007 Posted September 28, 2007 Hi, How are you doing the backup? It depends on a number of issues, but if you open a ticket at the help desk ( link at top of page) we'll take a quick look for you. Quote
OJB Posted September 28, 2007 Author Posted September 28, 2007 (edited) I am doing it via CPanel, going into Backups then downloading the MySQL backups individually. My usual backup routine involves downloading the home directory, plus the aliases/filters and MySQL databases individually (as opposed to the full backup) Thanks for the response, I shall contact the help desk in a few minutes. Edited September 28, 2007 by OJB Quote
TCH-Bruce Posted September 28, 2007 Posted September 28, 2007 I would recommend using the dbsender script for your databases and set up a cron job to run at off peak hours. Check out our Backup FAQ for more information. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.