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 […]
Month: November 2019
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 […]