Skip to main content

ghost3k

  • Home
  • About

Category: mysql

Fixing MySQL / InnoDB index corruption

25 June 201625 June 2016 ghost3k Leave a comment

Index corruption is usually a very rare issue, caused either by bugs in MySQL or hardware problems. Here’s how I handled it.

Read More

MySQL – Copying tables/databases without using mysqldump

18 February 201619 February 2016 ghost3k Leave a comment

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 […]

Read More

Updating mysql code to mysqli in PHP

10 February 201610 February 2016 ghost3k 2 Comments

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 […]

Read More

MySQL – Converting large tables to InnoDB faster

20 January 201117 November 2015 ghost3k Leave a comment

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 […]

Read More

Categories

  • linux
  • php
  • webdev
  • mysql
Theme by Colorlib Powered by WordPress