Monthly Archives: July 2014

Ways to auto backup MySQL database

1. AutoMySQLBackup

AutoMySQLBackup with a basic configuration will create Daily, Weekly and Monthly backups of one or more of your MySQL databases from one or more of your MySQL servers.

Other Features include:
– Email notification of backups
– Backup Compression and Encryption
– Configurable backup rotation
– Incremental database backups

2. Exabytes off-site backup RM199/mo for 50GB.

3. Handy Backup

4. Percona XtraBackup (incremental backup)

5. Explaining on AutoMySQLBackup and MySQL Workbench

CodeIgniter template library

Why use template library for CI

  • You feel like using views can be clunky, especially when “embedding” views.
  • You don’t like calling header, footer, and other global views from every Controller method.
  • You prefer having one “master template” that can be changed for any controller in order to meet unique application design needs.
  • You don’t want to drastically alter the way you interface controllers and views.
  • You like clear, thorough documentation on par with CodeIgniter’s User Guide.

source: http://jeromejaglale.com/doc/php/codeigniter_template

or alternative download

Find large files in Mac OS X

The steps:

  1. From the Mac OS X Desktop, open any new Finder window
  2. Hit Command+F to bring up Search
  3. Click on “Kind” filter and select “Other”, then select “File Size” from the attribute list
  4. Click on the second filter and choose “is greater than”
  5. In the third space, enter the size to search for anything greater than (ex: 100) and choose either MB or GB as the final filter

Original source

Top PHP framework

Still looking for best and promising PHP framework. There are too many of PHP frameworks out there.

You can refer to this site of summary for some of the frameworks.

And you can take a look on poll result made by sitepoint on most popular PHP framework in 2014.

According to the site. Top 3 PHP frameworks are

  1. Laravel
  2. Phalcon
  3. Symfony2
  4. CodeIgniter & Yii

Don’t know how true it is but it can be as indicator to start doing the research further to find out.

phpframework