Dec 11 2014

Extracting a Single Database From a mysqldump File containing –all-databases Dump.

Imagine to have a full MySQL DB Dump (containing a lot of Single Database Dumps) and imagine also to need the extraction or restoration of a single one. This is a quite common task that can be accomplished using some shell commands.
Continue reading

Sep 23 2012

MongoDB APT Installation on Ubuntu 12.04 (Precise Pangolin).

MongoDB is an open source document-oriented NoSQL DataBase system.
Instead of storing data in tables as is done in a “classical” relational database, it stores structured data as JSON-like documents with dynamic schemas (BSON Format).

MongoDB installation on Ubuntu 12.04 (Precise) is quite easy.
Continue reading

May 8 2012

osTicket: Reset User Password.

Password lost for admin user in osTicket?

This can be solved by setting a new password in the DB.
Continue reading

Mar 31 2012

MySQL: Resync a Master-Slave replication.

Replication enables data from one MySQL database server (the Master) to be replicated to one or more MySQL database servers (the Slaves).

Replication is asynchronous: slaves need not be connected permanently to receive updates from the master.
Depending on the configuration, it is possible to replicate all databases, selected databases, or even selected tables within a database.

This is a Step-by-Step procedure to RESYNC a Master-Slave MySQL Cluster.
Continue reading