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]