Re: Specifying a different tmp location

2001-11-26 Thread Martyn Wendon
for temporary files instead of the default /tmp directory Regards, Martyn - Original Message - From: "Delfim Machado" <[EMAIL PROTECTED]> To: "Martyn Wendon" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, November 26, 2001 10:57 AM Subject

Re: Symbolic Links to Data

2001-11-26 Thread Martyn Wendon
Hi Edward, I downloaded the latest (3.23.43) binaries for in rpm format from http://www.mysql.com and they installed fine. Kind Regards, Martyn - Original Message - From: <[EMAIL PROTECTED]> To: "Martyn Wendon" <[EMAIL PROTECTED]> Sent: Monday, November 26, 20

Re: Symbolic Links to Data

2001-11-26 Thread Martyn Wendon
you put a database called "mydata" in a user directory "/home/user1" the mysql user needs to have rights to the "user1" directory as well as the "mydata" directory. Hope that makes sense. Kind Regards, Martyn - Original Message - From: "Mike(

Specifying a different tmp location

2001-11-26 Thread Martyn Wendon
Hi, Using MySQL 3.23.43 on Red Hat Linux 6.2, is there a way to tell MySQL to use a different "tmp" location? I am having problems indexing a large table as mysql bombs out with an out of disk space error int the /tmp directory (which actually has about 500 megs free space). I know there is a c

Re: Symbolic Links to Data

2001-11-25 Thread Martyn Wendon
Jan, Thanks for the pointer, indeed it was a rights issue, and all sorted now. Regards, Martyn - Original Message - From: <[EMAIL PROTECTED]> To: "Martyn Wendon" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, November 25, 2001 7:53 PM Subject

Re: Symbolic Links to Data

2001-11-25 Thread Martyn Wendon
Hi Edward, No problems in general with the installation. Everything has been working fine, I need to move the database files as I am running out of space on the /var partition. Kind Regards, Martyn - Original Message - From: <[EMAIL PROTECTED]> To: "Martyn Wendon" &

Symbolic Links to Data

2001-11-25 Thread Martyn Wendon
Hello, I'm having some trouble in re-locating my MySQL databases to a different directory. My scenario is: Platform: Red Hat Linux 6.2 MySQL: 3.23.43 MySQL data currently stored in /var/lib/mysql The database name is "music" (so files are therefore in /var/lib/mysql/music) I wish to move the

Load Data Local Infile Question

2001-10-25 Thread Martyn Wendon
Hi, I have some text files (logs) that are tab delimited containing 3 columns. I'm loading them into MySql using the LOAD DATA LOCAL INFILE commands, but I want to load them into a table that has 4 fields, with the 4th field having a value equal to the name of the file being loaded. Is this poss

Best Table And Index Structure

2001-10-23 Thread Martyn Wendon
Hi, I'm new to MySQL and indeed SQL in general (coming from an MS Access and Flat Text File background). I have data in text form at the moment of the following fields: ID (Auto increment) ARTIST (Text up to 255 characters long) DESCRIPTION (Text up to 255 characters long) PRICE (Decimal up to