New to the community? Start here

Need help with installing

Hi,

Well this is my first multy db install and its just not working,

What I did was created 16 dbs with the names(their blank) as the sql code to create dbs got me a denied message

then I tried setting up structure in different ways but It doesnt work, what I have now is add_global_table(‘phytr’:wink:; phytr is the prefix that gets applied from my host because of the domain.

add_db_server(‘0’, ‘dc1′, 1, 1,’192.168.1.’,’127.0.0.1′, ‘phytr_blog0’, ‘phytr_blog’, ‘password’:wink:;

add_db_server(‘1’, ‘dc1′, 1, 1,’192.168.1.’,’127.0.0.1′, ‘phytr_blog1’, ‘phytr_blog’, ‘password’:wink:;

add_db_server(‘2’, ‘dc1′, 1, 1,’192.168.1.’,’127.0.0.1′, ‘phytr_blog2’, ‘phytr_blog’, ‘password’:wink:;

add_db_server(‘3’, ‘dc1′, 1, 1,’192.168.1.’,’127.0.0.1′, ‘phytr_blog3’, ‘phytr_blog’, ‘password’:wink:;

add_db_server(‘4’, ‘dc1′, 1, 1,’192.168.1.’,’127.0.0.1′, ‘phytr_blog4’, ‘phytr_blog’, ‘password’:wink:;

add_db_server(‘5’, ‘dc1′, 1, 1,’192.168.1.’,’127.0.0.1′, ‘phytr_blog5’, ‘phytr_blog’, ‘password’:wink:;

And all the rest are in same structure… What am I doing wrong? Can someone help please?

Thanks!

Fri, 20 Mar 2009 13:12:27
  • drmike
    • DEV MAN’s Mascot

    When you say phytr gets added on, do you mean as it phytr.wp_blogs or as in phytr_wp_blogs? Or in some other way?

    add_global_table(‘phytr’:wink:;

    That’s not correct. If you have a global table like ‘wp_globaldata’ the line will be

    add_global_table(‘globaldata’:wink:;

    You remove the prefix and put the rest of the name in there.

    Hope this helps,

    -drmike

  • Andrew
    • Champion of Loops

    Hiya,

    Can you post your entire db-config.php file?

    Also double check that your MySQL user has permissions for all of the databases.

    Lastly, make sure you created a global database. Look at the sample db-config.php for an example.

    Thanks,

    Andrew