Index corruption is usually a very rare issue, caused either by bugs in MySQL or hardware problems. Here’s how I handled it.
mysql
MySQL – Copying tables/databases without using mysqldump
Mysqldump must be one of the most frequently used MySQL utiliies. It’s very easy to use to peform backups with it and it’s reliable. And since its output is a set of SQL statements it’s easy to understand what’s happening and how to use it. For smallish databases mysqldump it’s perfect, but once you’re getting […]
Updating mysql code to mysqli in PHP
There are a few different ways of accessing MySQL from PHP. Historically the mysql extension was the only way until PHP 5.0 (circa 2004). After that mysqli appeared, which is an improved version of the older mysql driver. And also PDO, which gives you an abstraction layer for different databases. Unfortunately there’s still a lot […]
MySQL – Converting large tables to InnoDB faster
Why? The purpose of this article is to show you some tips that may help you reduce the conversion time of MySQL tables when switching to InnoDB. Although this is not going to be a problem anymore since MySQL is using InnoDB by default in newer versions, there are still people out there using MyISAM […]