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

Oct 9 2013

Configuring MySQL Server to Permit IPv6 Connections.

MySQL server listens on a single network socket for TCP/IP connections.
This socket is bound to a single address, but it is possible for an address to map onto multiple network interfaces, also in IPv6.
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

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