Mysqldump all databases and gzip
So, quick and simple MySQL backup in a CRON. #!/bin/bash _hour=`date '+%H'`; _user="root"; _pass="thepassword"; _dest="/srv/backups/daily/"; mysqldump -u $_user -p$_pass --all-databases…
A bunch of ramblings about PHP programming, JQuery, MySQL and other 'stuff'
So, quick and simple MySQL backup in a CRON. #!/bin/bash _hour=`date '+%H'`; _user="root"; _pass="thepassword"; _dest="/srv/backups/daily/"; mysqldump -u $_user -p$_pass --all-databases…
If you have large JSON files with application settings in, you need to be sure that the settings only appear…
If you need to backup your SVN repositories, then you can use this bash script to do so: #!/bin/bash DATE=`date…
I recently had to create a site for an education facility, and they turn on Compatibility mode for all their networked…
If you ever wanted to prevent certain IP addresses from accessing your site, you can easily acheive this in the…
There is a very useful command in Linux, called grep. It is a utility for searching plain text files using…
Sometimes sending mail to a dev account is all well and good, but if the mail server you are sending…
To run a scan on the port status on a Linux box, you can use the Nmap tool: nmap -sT…
Using Vagrant as a dev environment is great apart from when it goes arry after an OS crash, or battery…
I use the openvpn command line to connect to a certain VPN site, and I get annoyed at having to…