I have a Mysql db that is loaded with about 500,000 records a night using LOAD DATA
INFILE. This goes on for a month then a new table is created and so on. Then data is
then just queryed nothing else.
To take some stress off of this server I was wondering if there is a way to have One
Mysql
PROTECTED]
Sent: Apr 30, 2004 8:54 AM
To: [EMAIL PROTECTED]
Subject: One Mysql For loads and one for query
I have a Mysql db that is loaded with about 500,000 records a night using LOAD DATA
INFILE. This goes on for a month then a new table is created and so on. Then data is
then just queryed
At 10:34 -0700 4/30/04, rmck wrote:
I thought I could use mysqlimport, but I notice that the text files
need to be the same name as the table. My text files are named with
a time stamp every hour so I have 24 files that get loaded. And the
table name is nothing like the text files names.
Is