Moving MySQL database folder to a different location on the same server

MySQL logo

Authors: Dariusz Falkiewicz, Mauro Donadio

Few days ago from the post date, Dariusz Falkiewicz and I had to move a MySQL database folder to a different location on the same server.
We worked on Ubuntu Server v12.10 and had to move MySQL v5.1.41.

The first and main idea was to “mv” the folder to a different location and create a symbolic link to replace the original folder.
It sounds good, it could work! Later we realised that moving MySQL default folder is not so easy as it appears.

Continue reading

MongoDB string comparison

highres_14391580

In this article we’ll go through the MongoDB string comparison to understand how it internally sorts and compares strings.
We’ll also have a practical example to be executed by MongoDB Shell to better understand the different behaviour in front of a small concrete collection.

Continue reading

Xdebug problem: Xdebug doesn’t format output as expected

xdebug-logo

Xdebug is a PHP extension which provides debugging and profiling capabilities.
( Wikipedia http://en.wikipedia.org/wiki/Xdebug )

The test architecture I’m using has the following features

  • Ubuntu Server 12.04
  • Apache/2.2.22
  • PHP 5.3.10
  • Zend Engine v2.3.0
  • Xdebug v2.2.5

Continue reading