How does that help?  The database itself should be allowed to organize 
everything.

Ruben


On Thu, Oct 07, 2004 at 04:57:39PM -0700, Justin Smith wrote:
> Is it possible to create a database in a lower-level subdirectory of 
> MySQL's data directory?  We have almost 100,000 sites, and we would like 
> to have a separate database for each site.  However, it's very 
> impractical from a filesystem maintenance standpoint to have 100,000 
> subdirectories of MySQL's data directory.  What we would like to do is 
> break up the directories into something like this:
> 
> for site #12345:
> 
> [mysql datadir]/01/23/45/[databasename]
> 
> This would greatly improve the manageability of the table space.
> 
> Is this possible?
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

-- 
__________________________
Brooklyn Linux Solutions

So many immigrant groups have swept through our town 
that Brooklyn, like Atlantis, reaches mythological 
proportions in the mind of the world  - RI Safir 1998

DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002
http://fairuse.nylxs.com

http://www.mrbrklyn.com - Consulting
http://www.inns.net <-- Happy Clients
http://www.nylxs.com - Leadership Development in Free Software
http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from 
around the net
http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn....


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to