Is there anyway I can figure out the pattern of which blog will be in which database using multidb? I'm using 4096 database, and so it's a bit tough to figure out which blog will go into which database. So many! :)
Is there anyway I can figure out the pattern of which blog will be in which database using multidb? I'm using 4096 database, and so it's a bit tough to figure out which blog will go into which database. So many! :)
For the following multi-db settings:
16 dbs - blog 25 is in db 8 (first char of above)
256 dbs - blog 25 is in db 8e (first 2 chars of above)
4096 dbs - blog 25 is in db 8e2 (first 3 chars of above)
Responses (3)
Erstwhile founder — 12th July 2009 (2 years ago) #
Blogs are placed into databases based on the first few characters on an MD5 hash of the blog id.
Thanks,
Andrew
Member — 11th March 2010 (2 years ago) #
Is there a way of figuring out where a blog was created? It would certainly help me when debugging things.
Developer — 11th March 2010 (2 years ago) #
You can use http://premium.wpmudev.org/db-tools/md5.php
Enter the blog id - e.g. 25
25 will return 8e296a067a37563370ded05f5a3bf3ec
For the following multi-db settings:
16 dbs - blog 25 is in db 8 (first char of above)
256 dbs - blog 25 is in db 8e (first 2 chars of above)
4096 dbs - blog 25 is in db 8e2 (first 3 chars of above)
Become a member