AlpineIan
SAOCA Founder
We have always had a problem with our current hosts 100MB database quota. This has required regular monitoring of the db log files to ensure they aren't growing past the quota limit, therefore shutting us down until it's fixed.
To add to that problem, the web site has grown to the point that I can no longer simply delete the log files from the database to keep it working. I stupidly got careless and deleted the wrong things, crashing the site as a result.
Now to the good news. As a result of my mistake, I had to call tech support to have a back up implemented from Monday night. While on the phone with them I complained about the 100MB limit and they responded that all new db are 1GB in space. The conversation quickly turned to "How do I get one of those!"
So, we are now on a 1GB database platform. This is a good thing. During the restoration process I did run into some problems. 1st problem was that the backup file was too big for the MySQL uploading tool. I had to use a tool called Putty to import the file through a SSH link. Just when I though this was working great, I discovered that it was not completing the entire table upload and crashing on some of the Subdreamer portal tables. The only way to finish the job would be to recreate about 25 Subdreamer tables manually and import their data through the MySQL interface.
Once finished, I pointed the web site to the new db location and it blew up. My email inbox instantly flooded with error messages and I had to shut the whole thing down. After many hours of playing with it I finally decided to strip the Subdreamer portal software away from the Vbulletin forum software. This is why we are now looking a little bit different, without the outer shell from the web site portal. This had to be performed manually since the Subdreamer portion of the site wasn't functioning properly.
In time we can work on rebuilding the portal with newer software and get it back to the way it was. For right now, at least the forum is recovered and you guys can get back to talking about Sunbeams again!
Ian
To add to that problem, the web site has grown to the point that I can no longer simply delete the log files from the database to keep it working. I stupidly got careless and deleted the wrong things, crashing the site as a result.
Now to the good news. As a result of my mistake, I had to call tech support to have a back up implemented from Monday night. While on the phone with them I complained about the 100MB limit and they responded that all new db are 1GB in space. The conversation quickly turned to "How do I get one of those!"
So, we are now on a 1GB database platform. This is a good thing. During the restoration process I did run into some problems. 1st problem was that the backup file was too big for the MySQL uploading tool. I had to use a tool called Putty to import the file through a SSH link. Just when I though this was working great, I discovered that it was not completing the entire table upload and crashing on some of the Subdreamer portal tables. The only way to finish the job would be to recreate about 25 Subdreamer tables manually and import their data through the MySQL interface.
Once finished, I pointed the web site to the new db location and it blew up. My email inbox instantly flooded with error messages and I had to shut the whole thing down. After many hours of playing with it I finally decided to strip the Subdreamer portal software away from the Vbulletin forum software. This is why we are now looking a little bit different, without the outer shell from the web site portal. This had to be performed manually since the Subdreamer portion of the site wasn't functioning properly.
In time we can work on rebuilding the portal with newer software and get it back to the way it was. For right now, at least the forum is recovered and you guys can get back to talking about Sunbeams again!
Ian
Last edited: