Hi All, Tearing my hair out with this one! I am trying to load data from a text file from the command line, this is the syntax...
LOAD DATA INFILE 'users_1.csv' INTO TABLE 'ma0133' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'; The error I get is... ERROR 1049: Unknown database '\n'' ERROR: Can't connect to the server Hmm, I accessed the server using... mysql -u root -p <databasename> What am I doing wrong here? TIA Phil. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
