Mysqldump Compress on the Fly
Backup MySQL Database MySQL provides mysqldump utility to let us dump SQL statements that can recreate the whole database. We can output the SQL statements… Read More »Mysqldump Compress on the Fly
Compression
2 Steps to Compress MySQL Tables
Two steps to make your table compressed. Set the server INNODB_FILE_FORMAT to Barracuda. mysql> SET GLOBAL INNODB_FILE_FORMAT=Barracuda; Alter table to compressed with 8KB key block… Read More »2 Steps to Compress MySQL Tables
How to Resolve Very Big Dump File of MySQL
I usually backup the database by mysqldump, but the plain SQL dump file was getting larger and larger and took most of the free space.… Read More »How to Resolve Very Big Dump File of MySQL