18 messages in com.mysql.lists.mysqlRe: Problem reading from a text file
FromSent OnAttachments
Margie Wiers04 Apr 2000 10:41 
Margie Wiers04 Apr 2000 11:01 
Keith Vance04 Apr 2000 11:28 
Paul DuBois04 Apr 2000 11:37 
sin...@mysql.com04 Apr 2000 11:38 
Steve Ruby04 Apr 2000 11:49 
Gerald Clark04 Apr 2000 11:58 
Margie Wiers04 Apr 2000 12:32 
Margie Wiers04 Apr 2000 12:46 
Steve Ruby04 Apr 2000 13:25 
Steve Ruby04 Apr 2000 13:27 
Paul DuBois04 Apr 2000 13:36 
Margie Wiers04 Apr 2000 14:01 
Paul DuBois04 Apr 2000 14:16 
Steve Ruby04 Apr 2000 14:44 
Ian White04 Apr 2000 14:47 
Keith Vance04 Apr 2000 15:00 
Margie Wiers05 Apr 2000 05:27 
Subject:Re: Problem reading from a text file
From:sin...@mysql.com (sin@mysql.com)
Date:04/04/2000 11:38:09 AM
List:com.mysql.lists.mysql

Margie Wiers writes:

Hello all,

I've created a table in a text file (profile.txt) and now cannot get the mysql client to read from this file. According the the Manual (19.4) I should be able to do this. This is what I've done (in DOS)

mysql>use mycolors;

mysql>mycolors < profile.txt;

And this is always what I get

ERROR 1064: You have an error in your SQL syntax

I've tried putting in the complete filepath, and using other variations, but can't get the mysql client to read this file. Can anyone help?

My setup is PHP 3.0.xx / MySQL 3.23.12 / Apache 1.3.11 on Win95 (yes, I know)

TIA, Margie

Hi!

If that text file does not contain valid SQL commands, then consider using mysqlimport to populate your tables.

Regards,

Sinisa

+----------------------------------------------------------------------+ | TcX ____ __ _____ _____ ___ == mys@tcx.se | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic | | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sin@mysql.com | | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +----------------------------------------------------------------------+