MySQL Dump Not Exporting All Rows
This example is a lesson in double-checking what you think you’re seeing. I just invested a half hour in trying to solve a problem which […]
Blog Posts
Changing a MySQL Schema Name
You’ve got your MySQL database up and running. Everything is going smoothly. But then for some reason you need to change your MySQL schema name. […]
Updating ASP Classic Scripts from MSSQL to MySQL
OK I had gone through all the planning and I had actually moved all my millions of rows in my databases from the MSSQL tables […]
Moving Data from MSSQL to MySQL
It took me quite a while to be ready for the task of moving my data from MSSQL to MySQL. To get some history on […]
Migrating a Database from Microsoft MSSQL to MySQL
If you’d asked me ten years ago if I’d ever consider moving my databases from Microsoft MSSQL to open-source MySQL, I’d probably have said no. […]
Moving to TurnKey Internet
Many of you have noticed that this site has been experiencing fairly serious issues these past few months. I’ve been using a hosting company in […]
Language=VBScript
If you look at the very top line of ASP Classic code, you’ll often see a line that looks like this: <%@ Language=VBScript %> or […]
Mapping HTML to Run ASP Scripts
It seems normal and natural for a Microsoft IIS Webserver, which is set up to run ASP Classic code, to therefore process any .ASP file […]
Blocking and Viewing ASP 500 Errors on IIS
When you’re using ASP Classic on Microsoft IIS servers, you generally don’t want all your 500 errors showing up to the public. They could get […]
MSSQL and Character Set Issues
One of the most troubling parts of ASP and SQL for new programmers can be how to handle apostrophes and other special characters. Here is […]