SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Apr 2002
    Posts
    10
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL 1148 error

    trying to you the 'load data infile' technique used in the mySQL tutorial, my windows XP machine returns an error 1148 (command not supported by this version).

    What I am trying to do is 'import' a .txt file with table data as the tutorial shows.

    I want to learn mySQL from the monitor and not through a GUI, so I would like to find a way to do this.

    Thanks,

  2. #2
    SitePoint Zealot
    Join Date
    Feb 2002
    Location
    UK
    Posts
    146
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    this has been a feature since version 3.23.49, see Security issues with LOAD DATA LOCAL

    you have two choices:

    either start mysql with the option --local-infile=1

    e.g. c:\mysql\bin> mysql --local-infile=1

    or add these lines to your 'my.cnf' file:

    [client]
    local-infile=1

    [mysqld]
    local-infile=1

    hope this helps


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •