I am currently using/installing SharDB to break up (partition) my database.
SharDB version is: 2.7.5 (Dev version)
I am trying to navigate the blog network into a 16db hash and my table structure is (rbs201db_[0-9a-f] and my global table is rbs201db_global. I am not using the home db or vipX config.
There are/were three issues:
1. Database migration tool created empty tables (and it didn't advance automatically as I found out after applying this patch. Thanks @webraket. (I moved the global tables manually after using the migration tool.)
2. After applying fix #1, all site admins seemed to work (unsure of blog 1 though since I was trying to access the admin settings) however the network admin section was inaccessible. Also have a feeling that blog 1 site admin was not available either because of a hyperlink request I looked at under Sites in one of the blog site admins. (This is blog network nested three directories deep, which could be the issue.) Fixed--or at least appear to be fixed--by copying the blog 1 tables into the global db. Since blog 1's tables are in two places, I'd like to find a fix so that there isn't unnecessary duplication if only one of the two places is utilized.
3. After applying fix #1 & #2, the extra column under network/sites is there to show what partition each site is on, but none of the fields are populated with any data. This is probably a 3.1 network admin upgrade issue, but a fix would be nice since I am not 100% certain I can get rid of my old database now. (I'm about 95% sure now that problems #1 & #2 fixed since I don't think there is any reference back to the original db, but a visual clue would be nice. :))
My WP is a 3.0.x site upgraded to 3.1 -- aka it was never wpmu. I think my sql server is 5.0.83 & my php version is PHP Version 5.2.17
Thank you in advance for any and all help and thanks Ron (@wpmuguru) for a great plugin.