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
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
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
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" &
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
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
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(
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
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
