Tag: MySQL

Tracking user behaviour on your website

Tracking the behaviour of the users on your website can be useful for Search Engine Optimization and User Experience Optimization. In this tutorial I describe how you can get started with a simple piece of PHP and a MySQL query.

Posted in Tutorials Tagged with: , , , , , , ,

Daily Full MySQL backup using cron

Today I bring to you a cron job that will save a well named gzip of your database dump every day at 4:00 (4am). Example output: “myDB_2012-01-29_04-00-01.sql.gz“ In this example, I’ll use a fictional host, path, login and password. When

Posted in Tutorials Tagged with: , , , , ,
Top