Binary Log Growth Handling in MySQL – Select All From MySQL

Binary Log Growth Handling in MySQL – Select All From MySQL

So today we look at an aspect of capacity management or planning and how it relates to MySQL and its Logging.  For this blog I’m primarily going to look at MySQL’s binary logs. They have a tendency to grow...
Read more...
Easy-to-use Perl scripts to backup your MySQL database with mysqldump and FTP the files to a remote server

Easy-to-use Perl scripts to backup your MySQL database with mysqldump and FTP the files to a remote server

Most users of MySQL utilize the mysqldump utility to backup their database. While mysqldump is handy and easy-to-use (and free), if you have data which is important to your business, then you should take a look...
Read more...