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
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
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
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).
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