As you know your website data is stored in your database server, in this case is MySQL. To prevent disaster, backup your data regularly is a must for you and every website owner. There are many ways to backup MySQL data, one of them is using mysqldump to dump your MySQL data to a file.But mysqldump output is plaint text files with full of SQL commands. And in linux you can compress it using gzip with pipelining command.To backup and compress MySQL dump file:Explanation: the … Read more...