Hi.
By using DATA DIRECTORY='directory' or INDEX DIRECTORY='directory' in CREATE TABLE clause, you can specify where the MyISAM storage engine should put table's data and index file[s]. See: http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html Also,you may use 'datadir' server variable. See: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html Yves Arsenault <[EMAIL PROTECTED]> wrote: > Hello all, > > I have MySQL installed on a Mandrake Linux system, it is installed on > the /usr partition. > > I was wondering, is it possible to store some databases on the /var > partition while MySQL is installed on the /usr partition? > > And, if it is possible, can you store DB_A on /usr and DB_B on /var > (or at least 2 different partitions). > > Thanks, > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
