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]