Blogs on

Backup

knackforge blog

How to automate backup for our codebase & database

Most of the sites rely on codebase & database which we can't afford to loose. We definitely need to implement a backup procedure in that case, otherwise we may loose our valuable data due to some kind of mishap (manually delete some data by mistake, software errors, hardware errors, server compromise, etc).

We can use the following shell script to make backup (codebase and database).

First let's create the backup script file:

nano /path/to/script/backup.sh 

and add the following code:

Continue reading →
knackforge blog

Restore database faster from SQL dump

At KnackForge, MySQL has been the primary choice of persistent backend storage. Late-off one of the Drupal sites we maintain had grown to accomodate thousands of contents. This inturn introduced the need for having a different strategy for backup. More details about the project will be shared in the follow up post. For this post I would like to share a simple configuration trick that helped us to speed the restoration process from SQL dump.

Continue reading →