MySQL Workbench – Increasing Connection Time
If you do a lot of work with MySQL, you’re probably using MySQL Workbench to manage your databases and schemas. Once you start working with […]
Blog Posts
MySQL Schema Inspector Reporting Wrong Row Counts
When you use reports in MySQL, you expect them to be accurate. Let’s take, for example, the MySQL Schema Inspector. When you use the schema […]
Comparing MySQL Data Across Schema
There are all sorts of reasons you might want to compare data between two tables in different schema. A common situation is that you’re moving […]
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 […]
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 […]