A script to create those 256 little buggers
Keeper of the Dark Chocolate
Greets:
A small script to create and assign those dbs to your user:
[link removed - drmike]
Used with CPanel.
xxUSERNAMExx is your CPanel hosting account username
xxUSERPASSWORDxx is your CPanel hosting account password
xxMYSQLUSERNAMExx is your MySQL username
It's hard coded for the CPanel 'x' theme. Please note the urls. If you're using something besides 'x', please review the 2 URLs in there.
Please also note the 10 second time outs. It will take time to run. The timeouts are a good idea.
Hardcoded for 256 databases. Your MySQL user has to be created a head of time.
I think that's all the docs you need in there.
Hope this helps,
-drmike
edit: You need to start the count at 0 as the 00 database is needed.
I actually run this script in batches to prevent timeouts. 0 to 50, 51 to 100, etc.
Also the prefix that CPanel adds onto the database and user names is not needed. CPanel will do that for you.
Everyday at WPMU DEV we help hundreds of WP Users. Become a member today to:
- Download 250+ Premium Plugins and Themes
- Get unlimited support from WordPress Experts
- Get help with your WordPress or BuddyPress projects
Help & Support from WPMU DEV members and staff
Keeper of the Dark Chocolate
Someone pointed out to me that the script got deleted. I've gone ahead and replaced it. I made some changes to the description in the previous post concerning the file.
Does it work like the one Andrew put together?
I used that yesterday and it worked nice.
Get personal, comprehensive and timely support and assistance
from WordPress Experts
Keeper of the Dark Chocolate
Andrew put one together? First I knew about it. I know he has this:
Not everybody has true ssh access so the dbsql generator won't work.
Yeah, that's the one.
Who needs SSH access for that? PhpMyAdmin will run it OK.
Well, unless someone is on a cpanel (or other) host, and then they can't run DB creation queries. If that's the case, they're stuck anyway.
Nevermind. I see your script is for cpanel anyways. ;)
Keeper of the Dark Chocolate
Which was the point of the script. :)
Get personal, comprehensive and timely support and assistance
from WordPress Experts
Any reason this script has been removed? i know its 3 years later, but I sure would find it handy.
Allows you to scale your standard Multisite install to allow for millions of blogs... also will vastly improve the performance of your site!