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

Dec 19 2011

Hide specific databases in phpMyAdmin to users.

In a MySQL DB Hosting Environment, phpMyAdmin is a commonly used Web Frontend to give access to Customers to MySQL DB Administration.
In that scenario, it is common to hide specific databases to customer’s default Web-View.

The hide_db phpMyAdmin configuration option is a regular expression so useable to hide several databases (exclusion based on DB Name).
Continue reading