Failed to open file error | O'Reilly Media

View Review Details

Book:		Learning SQL
Subject:		Failed to open file error
Date:		2008-09-01 09:54:54
From:		Anonymous Reader

Rating: When I try to use the source command to populate my database, I get an error that says, "Failed to open file 'C:\file location', error: 2. What am I doing wrong?

Learning SQL

See larger cover

Full Threads

Oldest First

Failed to open file error, November 03 2008

Rating:
Submitted by cj brown [Respond | View]

Looks like the example needs to be compiled before I can use... I get this error.

-> source C:\Users\CJ\Desktop\LearningSQLExample_sql.txt;

ERROR:
Unknown command '\U'.
mysql: Character set 'JDesktopLearningSQLExample_sql.txt;' is not a compiled cha
racter set and is not specified in the 'C:\mysql\\share\charsets\Index.xml' file
Charset is not found

Any assistanve will be appreciated.
Respectfully,
CJ

Failed to open file error, November 14 2008

Rating:
Submitted by johns2947 [Respond | View]

Check the name of your file. When you download it, it should be :

LearningSQLExample.sql

You can use that at is, without changing it to a .txt file

Make sure you opened the database first, as in the book instruction.

mysql> use bank;

then run source