Here’s a cheap ass script to tar up and dump all of your MySQL databases to separate files using the Debian system maintenance account. Sure there’s plenty of room for improvement here, but hey, it gets the job done and is perfect for a midnight cron job.
Based off of this with a few of my own customizations.
Continue reading “Bash Script – Backup All Databases to Separate Files”
Here’s an extremely basic, reusable PHP and MySQL based PDO class for easily connecting to multiple database servers simultaneously within a script without having to go through a bunch of hoopla. Tidbits have been pieced together from the following sources with a little tweaking of my own (such as the ability to have default database values or to pass them as arguments):
Continue reading “PHP – Simple PDO Class for Connecting to a MySQL Database”
As mentioned in a previous post, if you’re Email Server is running out of hard drive space and you’re in a world of hurt, there are several steps you must take to get that space back. Even if you have your user’s tidy up their mailbox and you force delete out their RecoveryItems folders, you will essentially be creating free whitespace to store more messages but the size of your database will never shrink below it’s current state. To actually shrink size of the database file, you will have to do the following:
- Have the end users get rid of all their unimportant emails and empty their Deleted Items folder.
- Purge all of the user’s RecoveryItems folders. To learn how, read this.
- Either create a new mailbox database, mount it, move all the mailboxes to it, then dismount and delete the old database
— OR —
Dismount the databases and run the defrag utility
Either way, both scenarios are extremely time consuming so get your blanket and sun tan lotion because you’re never getting off that beach, just the way you never got into the NHL, ya jackass!
Continue reading “Exchange Server 2010 – Shrink Database Size – OR – Reclaim Lost Database Storage Space”