drupalib A place for library drupallers to hang out

Not sure if any of you noticed (well, at least a couple of you did since you emailed me), but the downtime today was due to a move to a new web hosting service. My previous one, WebServe, was sinking fast so I bailed. Their customer support over the last few months has dwindled to NULL, and last weekend I actually phoned tech support and got routed to a call center somewhere where "Jack" the dweeb wasn't even able to look up my user info based on my domain. His technical knowledge was equally lacking. A few days before I called I lost access to my Drupal modules page due to WebServe turning off PHP's parse_ini_file for security reasons -- and they are one of those web hosts that mails your your replacement password in a plain text email with your username and login URL. Finally, I started getting access denied errors on one of my other Drupal sites when trying to post comments. So, knowing when enough is enough, I grabbed all my files and SQL dumps and jumped ship. I'm now on BlackSun thanks to my friend and fellow Drupalhead Dave Kisly.

The migration went well. For the first time I'm using a single MySQL database for my four Drupal sites, so the trickiest part was converting all those prefixless database table names into ones with site-specific prefixes. Search and replace on EXIST `, TABLE `, and INTO `, replacing the matched string with itself plus a prefix in all the SQL dump files, did the trick. Another important step in the single-db-per-site-to-shared-db migration was updating all the 'name' values in each site's sequences table to reflect the table prefix.

Also, some of my template files didn't FTP properly but once I did a fresh upload of the templates directory all weirdness disappeared. The last step in the migration was truncating all the database tables that start with 'cache_', which brought things 100% upright.