Archives For Database

Your MySQL script was running great, but then you started getting errors – If you get this warning when dumping the mysql database, it’s not a bug – MySQL did this on purpose because they wanted people to know that they weren’t dumping the event table. Previous versions did not give the warning.
Continue Reading…

There are a couple of ways that I lock it down.. I won’t get into specifics because I don’t want you (or you!) trying to find it, but I can’t count the number of times I’ve seen an old phpMyAdmin install just sitting on someone’s server waiting for someone to type in the correct login and password and screw up your day. Continue Reading…

My server had some tables marked as ‘crashed’ in one of the databases.. the server had recently gone down pretty harshly so I wanted to go through and check, repair and optimize all of the tables in every database on the server (there are about 30 databases.. mostly wordpress ones.. some vbulletin.. some xenforo). Continue Reading…

Have you ever wanted to make your own MySQL database backups?  You can use this script I wrote to make a backup of all databases, then save each one in a dated backup directory.  It will keep doing this and keep 10 days worth of backups.  I’d suggest you use rsync or something to automatically back them up off the server each night/morning also. Continue Reading…