View Review Details

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

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?
Full Threads Oldest First
  • Failed to open file error,  November 03 2008
    Rating: StarStarStarStarStar
    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: StarStarStarStarStar
      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
 
Sign up today to receive special discounts,
product alerts, and news from O'Reilly.
Privacy Policy >
View Sample Newsletter >