On Tuesday 25 April 2006 23:40, Roy Souther wrote: > Are you running multiple Drupal sites from the same server? Are you > using virtual hosing? I am working on virtual hosting for CMS and would > like to exchange information with you if you are doing this.
Thanks Roy! I can see how this is going to work out. The bit to discover the databases is an added bonus - though there's only a few out of many dbs I need to do this for. But I didn't even think of using a loop for the dbs - I was thinking lower and running the script for each manually. If I change the db list to a variable, I can just set it, and run the script once. I like it - thanks for the idea! I knew I could pass the show tables to MySQL like this, but I thought it would spit out the border around the results - like you see when you're in the mysql shell. I shoulda just tried it.. :) As for my Drupal sites, I have 3 on my local server, and one on a remote server (excluding CLUG's site, but that one won't suffer from the same update problem - we don't control the database server there). Drupal allows hosting in a few different manners, but I opted to keep it simple and each sub-site is running it's own instance of drupal. Yeah, I'm using up a few more resources this way, but it's only 3 sites, with VERY VERY low volume, running on a relatively recent 64Bit server. I'm not worried about the resources here. Let me know what else you'd like to discuss on the virtual hosting. But we should maybe start a separate thread for that... :) Shawn _______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying
