how to repair all tables in all databases on a mysql server

This comes in handy, and I have to google it every time I need it12. So, here’s a copy for reference later… mysqlcheck --repair --use-frm --all-databases Run it as root, with MySQL running. It’ll repair every table in every database. Give it time to chew for awhile. It spews out the status of every table as it works. Here’s what it found with my FeverËš database tables (which now work just fine):...

August 10, 2013 · 2 min

Hippie Hosting server now has room to grow

I'd been getting nervous, seeing the storage on our Hippie Hosting Co-op server filling up. We were over 80% full, with less than 18GB left until we were in serious trouble. So, I did some digging. I was getting ready to start deleting some of the bigger video files in my web hosting account, to make space. Turns out, that wasn't necessary. I use this to find directories that have lots of stuff in them:...

July 15, 2012 · 2 min

Enterprise-Class WordPress

I'd been thinking that WordPress might be tricky to scale, but between WP-Cache and the newly announced HyperDB, I think WP might well have some legs in it. WP-Cache stores pages as static files, and dramatically reduces the load on the database. This makes sites more responsive, and at least theoretically able to survive a Slashdotting or Digging. Matt just announced the other side of the equation. Enterprise-level database connectivity. They're releasing the (previously custom) database class that was developed for WordPress....

May 28, 2007 · 1 min

How to migrate from Drupal 5 to WordPress 2

I migrated my blog from Drupal 5 to WordPress 2 nearly 2 weeks ago. The process wasn't as painful as I thought it would be, thanks to a handy howto via vrypan.net. Another resource I refer to every time I get into tweaking MySQL rows is UrbanMainframe's MySQL search and replace tipsheet. Thanks to both of these great resources for helping me through the migration. This guide is intended only to document what I did....

May 15, 2007 · 3 min

Help - Slow MySQL Insert?

I've been struggling with this for what feels like months. On a project, we're using a third party hosting provider, who offers us space on a managed server, complete with everything we need to run Drupal in a shared hosting environment. We're running a copy of Provisionator on the server to help us deploy lots of Drupal sites easily. Here's where it gets messy. We can create new databases just fine, but importing a ....

November 14, 2006 · 2 min

Estimating blog feed subscribers in Drupal

Guesstimating the size of an RSS feed audience is always a huge shot in the dark, but sometimes I get curious about how many people subscribe to this silly blog. If I was willing to surrender my feeds to Feedburner, I could get some pretty detailed stats. But, I don't want to hand over that. So, I thought about digging into the accesslog that's stored in Drupal's database. I've set my copy to store access logs for the past 2 weeks, and it dutifully records which pages are viewed, as well as the IP address the request came from....

August 15, 2006 · 2 min

Upgrading MySQL on MacOSX Server

I just upgraded our TLC development/staging/small-deployment server from MySQL 4.0 to 5.0.22. I'd never upgraded a MySQL server before (always just installed a fresh copy on a new box, or updated along with MacOSX) so I wanted to do some testing before making the plunge on a deployment server. We've got a bunch of databases on that box, running everything from weblogs.ucalgary.ca to some custom apps written here. I did a quick RTFM , but the MySQL manual recommended not jumping right from 4....

June 22, 2006 · 3 min

More on MySQL backups

I'm just putting some additional refinements to my automated server backup process, and have rolled together a handy script to backup each database into its own backup file (so I can restore a single database, rather than blowing them all away to restore from an --all-databases backup. I'm going to work on making a fancier / more dynamic script based on MySOL's show databases command to get all databases backed up individually without having to remember to add them to the backup script....

March 15, 2006 · 2 min

B2 to WordPress Migration is Not Smooth

A friend of mine wanted to migrate from an aging B2 installation to a shiny new WordPress setup. I figured it should be a simple process, given that WP was spawned from B2's loins and all. It should have been relatively trivial - tweak some database fields, massage some data, and done. Not so fast, smartass. Turns out that all of the tips I found were, well, a bit short. They either didn't work at all, or sorta worked, but not enough to be useful....

October 9, 2005 · 3 min

Godaddy Database Goofup

So, it's 4:50pm Friday afternoon. I'm about to click "Publish" on a post about the random image rotator dealie. Boom. WordPress throws up a big old "Error establishing a database connection" error screen. Crap. I login to my Godaddy account page, hit the database manager, and PHPMyAdmin can connect. The database is there, and running. WTF. I notice my ShortStat table has ballooned to over 100MB of data. That's insane, so I truncate it....

October 7, 2005 · 3 min