Recently I remembered that I had this little handy script that I used to backup my WordPress blog. The script contains only 2 actual commands.
I used nice while compressing / uncompressing the files to avoid CPU throttling since my blog is running on a shared hosting server.
This WordPress backup script doesn’t work without user interaction since it needs you to enter the password. Continue reading WordPress Backup Script
Country tables are useful when you need a select box containing the countries in your application. It is a must have when you have multiple rows with country fields.
I showed every way possible to import the table. Hopefully everyone can benefit from this post.
Continue reading ISO-3166 Country List for MySQL
If you want to see where your users are coming from, you can use MaxMind‘s GeoIP Country or GeoLite Country (Free version). The easiest way to do this is to download the database in CSV format and to import it into your MySQL database. Continue reading Faster GeoIP Country on MySQL Database
Ever wondered how many people are on your website? Do you think Analytics Real-Time shows all of the visitors? If you don’t have any clicks in 5 minutes (which I believe is the timeout of Analytics Real-Time) you won’t be seeing that user in Analytics Real-Time. Continue reading Analytics Real-Time Alike Real Online Script