Back in October I moved to Linode for hosting my site. Happy to report — I haven’t had any problems! Apparently there have been recent issues in late December (apparently many people were suffering some serious downtime thanks to DDOS attacks). But I wasn’t affected much — maybe a couple hours of downtime one day, but other than that, nothing. So I’m very happy here! MySQL Issues The only problem I have been having, however, are intermittent MySQL disconnections. I lost my database for ten minute stretches maybe once every two days. Of course I could see in my Linode […]
My Start Hosting on Linode
So I’ve been hosting most of my sites forever on JustHost. I’ve basically never had a problem except when a bunch of sites aside from mine were down for a couple days. It’s cheap shared hosting and I’ve been here since 2009 without issue — so why move? Well. I wanted to learn more things about running a VPS, and setting up an actual server.
IPB 1.3.1 to phpBB 3 Forum Conversion
I had an old forum archive on IPB 1.3.1 Final forum software from Invision Power Board. 1.3.1F is over 10 years old — it hasn’t been supported in a really, really long time, and its community of users is dwindling (or even nonexistent). More pressing, however — webhosts have been upgrading PHP lately. 1.3.1F has ceased to function without updates to make it compatible with new versions of PHP: some functions used by 1.3.1F have been deprecated, unsurprisingly. There are instructions as to how to make 1.3.1F compatible, but running an ancient and unsupported application isn’t ideal. We didn’t want […]
XAMPP Installation and Common Problems
What We’re Trying to Do We’re trying to set up a local web development environment on a Windows computer with an XAMPP installation. XAMPP will allow us to run Apache and MySQL on our local computer. Apache is a web server technology: it allows us to run PHP. MySQL is a database technology: it allows us to create and operate MySQL databases. For more information, see the Apache and MySQL sites. Don’t get lost — extensive knowledge isn’t required to use XAMPP. We want Apache and MySQL because without them, we cannot run PHP/MySQL applications such as WordPress or phpBB. […]
Importing Large MySQL Database with XAMPP
Even locally, phpMyAdmin has a size limit to the database you can import. You can change those limits, I’m pretty sure, but you can also bypass phpMyAdmin altogether and import the database with the XAMPP shell. Open the XAMPP shell (“Shell” button on your XAMPP Control Panel). Type: mysql -h localhost -u root database_name < J:\path\to\database.sql Change database_name to the name of the database you want to import to. Change the \path\to\database.sql to the appropriate path and filename. I'm working locally with XAMPP so I don't set a password on my root MySQL user (this is default behavior in XAMPP […]