Hi, You can create a symbolic link on windows for one specific database. i sent a thread about this. the doc is here :
http://dev.mysql.com/doc/mysql/en/windows-symbolic-links.html Mathias Selon Partha Dutta <[EMAIL PROTECTED]>: > When you create the tables, you can specify the DATA DIRECTORY and INDEX > DIRECTORY clause while creating the table to specify different paths. Not > sure if it works on Windows though. Should be a simple enough test.... > > -- > Partha Dutta, Senior Consultant > MySQL Inc, NY, USA, www.mysql.com > > Are you MySQL certified? www.mysql.com/certification > > > > -----Original Message----- > > From: mos [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, May 10, 2005 5:58 PM > > To: mySQL list > > Subject: How to put tables on a different drive??? > > > > I have a big whopping problem.<g> > > > > I have a large database that generates 25gb tables (let's call them > > GenTable1 to GenTableN). I'd like to put these tables on another drive > > because I'm running out of disk space. If I need to create another > > database > > (let's call it dbGen), so be it. (But it would be nice if it could exist > > in the same MySQL database, but that doesn't look possible. It appears > > MySQL forces all the tables to be under the same directory.) > > > > How can I get MySQL 4.10 to create the generated tables on another hard > > drive? The largest hard drive I can get is 320-400gb and that may not be > > enough for both my normal tables and generated tables. (I'm using Windows > > XP - NTFS) I need to reference the generated tables and normal tables in a > > join so it has to be done using 1 MySQL server. So I'd like my normal > > tables to be on one drive, and my generated tables to be on another drive. > > > > Does anyone have any ideas on how to put the GenTables on another drive? > > TIA > > > > Mike > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
