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]