Tag Archives: mysql

Creating Temporary Disk with TMPFS (RAM-Disk)

A RAM disk or RAM drive is a block of RAM (primary storage or volatile memory) that a computer’s software is treating as if the memory were a disk drive (secondary storage). It is sometimes referred to as a “virtual … Continue reading

Restoring Accidently Deleted Root User in MySQL

If you’ve ever been in the situation where you’ve accidentally deleted your root user in MySQL, you’ve probably noticed that GRANTS does not work when MySQL is started with skip-grant-tables. The way to get around this is to manually insert … Continue reading

MySQL Master / Master Replication Sync

IMPORTANT: ALWAYS make a backup of your databases before attempting the following procedures. The following is based under the assumption that your MySQL servers are already setup to be Master / Master. If you have have a MySQL Master / … Continue reading

Calculate MySQL Database Sizes Using SQL Query

Here is a quick and easy way to get the sizes of your databases in MySQL, useful when you don’t have PHPMyAdmin and just want to compare two databases (live and development for example).

Restore Single MySQL Database from Full Backup

We’ve recently ran into a situation where a client accidentally deleted her database and only had a 10 GB mysqldump created with –all-databases. As you can imagine, trying to grab a single table out of a 10 GB mysqldump backup … Continue reading