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 there a way to have mysqlimport import to a table that does not match the text file it is reading from?? >From manual: mysqlimport strips any extension from the filename and uses the result to determine which table to import the file's contents into. Im sure someone can help me?? Rob -----Original Message----- From: rmck <[EMAIL 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 nothing else. To take some stress off of this server I was wondering if there is a way to have One Mysql server for loads and one to do querys?? I was thinking of turning on tcp/3306 and have a Load server use LOAD DATA LOCAL to load the data over tcp. So the current server would bascailly become my query server. Can you use LOAD DATA that way??? If not please direct me to the mysql tool that will do this, or a smarter way? thanks,rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
