Most articles on removing duplicate rows from a MySQL table involve 3 steps, but the following query is what I use for purging dupe records in one simple query. DELETE FROM `myTable` WHERE id NOT IN (SELECT t1.id FROM (SELECT id, groupByColumn FROM `myTable` ORDER BY id DESC) as t1 GROUP BY t1.groupByColumn) – “myTable” […]
Category: MySQL
How to Copy or Move a Joomla Website
Intro If you manage one or more Joomla websites, eventually you’ll have to move them elsewhere. It’s pretty much fact. Performance requirements will change, you’ll find better pricing elsewhere, your dedicated server died, etc. There are a few options most people have to choose from: FTP client and phpMyAdmin method (aka the long, boring method) SSH/Shell […]
How-to Backup Joomla! 1.5 to Amazon S3 with Jets3t
Introduction to backing up a Joomla website to Amazon S3 storage using Jets3t. We all know backups are important. I’ve found what I consider a pretty good backup solution using Amazon S3. It’s super cheap, your backups are in a secure location, and you can get to them from anywhere. For my backup solution, I’m […]
Tips on Load Balancing a Joomla Cluster with HAProxy
For the past several weeks, I have been working with Joomla in a clustered environment. We have a single load-balancer running HAProxy that sends requests to two web servers synchronized with unison. One server is a hybrid and includes both the MySQL database as well as Apache2/PHP5. The other web server is strictly Apache2/PHP5. We […]
Dreamhost Hosting Review
Soon after I opened my own Dreamhost account, my company needed an external hosting environment for Joomla instances, and I recommended Dreamhost. I mentioned it supported unlimited domains, MySQL databases, etc., and had a large amount of space/bandwidth for any of our sub-projects within the company. They even have a One-click install for Joomla! It […]