That’s for scaling databases. Mostly used by a few plugins:
http://wordpress.org/extend/plugins/hyperdb/
http://wordpress.org/extend/plugins/shardb/
They don’t put one blog in one db though.
Ok, so WP_USE_MULTIPLE_DB is not what I’m looking for.. Thanks, Andrea_r, for clearing that much up anyway. I still need to look at options for restoring a single blog out of dozens, potentially hundreds (educational institution rolling out to several thousand staff). I’d really appreciate any advice from experienced WP admins on the best way to go about this. Thanks
DBA advises that extracting tables from previous backups and restoring to current db is not advisable as it may corrupt.
Wait. Your DBA says that restoring tables from backup might cause database corruption?
Your DBA is right, but that’s… well it’s a known risk. It’s not a high-risk process, and I do it all the time on databases that run up to the SQL size limit.
You restore the tables, that’s all. It’s straightforward, standard, and business have been doing it that way for years. Did you DBA have a reason other than possible corruption?
Honestly? It doesn’t come up often. Users have the option to make their own backups of content just using the internal Export.
the sysadmin above was only referencing a condition that would be common to any kind of partial restore to a single db, regardless of platform.
so…. the process you were worried about still stands. extract a backup of the db, find the tables you want, plunk them back in the db.
the sysadmin above was only referencing a condition that would be common to any kind of partial restore to a single db, regardless of platform.
Oh, I had to wrap my head around that. There IS an automagic way to say ‘Hey, DB backup, take tables A B and C and restore them!’ but … even our DBAs just extract the backup, pull the tables, and plunk them back in (after deleting the corrupted ones). There’s more backing up and making sure you have full everythings involved, but we never use the automagic. it doesn’t allow for fine tuning 🙂
Again, we’re basically in agreement here. 😀
That’s great. I just wanted to be sure of the best option. Thanks very much to you both for the advice. Much appreciated.
