I’ve just upgraded my Piwik web analytics system this afternoon. It was not a long and complex process however it still have some things you should take note whenever you want to upgrade to a new version. Continue reading
I’ve just upgraded my Piwik web analytics system this afternoon. It was not a long and complex process however it still have some things you should take note whenever you want to upgrade to a new version. Continue reading
Creating a job to schedule backup databases automatically is a very important task for each database administrator. Database is always irreplaceable and is the heart of all online business therefore this process must be the first thing in the process of database administrating to ensure it’s super safe. Continue reading
This example will help you know how to backup one or multi MySQL database using mysqldump command. If your database is very big, you may need to compress the backup sql file. To do that, you can use gzip compression to pipe the output to gzip then you will get the output as gzip file. Continue reading
This shell script will backup all current Mysql databases, compress(gzip) them and put them in a new folder named by current date (one directory per database). Continue reading
How to backup and restore a single table using MySQLDump with default-character-set utf 8
1. Backuping a single table from a database
2. Restoring the table into another database Continue reading
