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]
