Category Archives: Web Development
Easy MySQL backup shell script
I accidentally deleted my MySQL backup script. No backups is bad news. I was looking for replacements and found a bunch, but they are all overkill. And half of them don’t even zip your backups. The only two elements I … Continue reading
Posted in MySQL, Web Development
Tagged backup, database backup, linux, linux commands, mysql, mysqldump, script, server administration, shell script
Leave a comment
Removing duplicate rows in SQL
Since I’ ve had to look this up twice in the last year, I should blog about it so I’ll remember. This is the quickest solution I’ve found. Problem: You have duplicate rows in your database. Even if you have … Continue reading