Professional Web Applications Themes

ERROR 1064 when trying to load dump from sql file - MySQL

Hi, Can somebody tell me what's wrong with the following syntax: G:\>mysql -u root --password=testpw test2x < c:\test2x.sql I get: ERROR 1064 (42000) at line 34: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Note: test2x is the database name. thks...

  1. #1

    Default ERROR 1064 when trying to load dump from sql file

    Hi,

    Can somebody tell me what's wrong with the following syntax:

    G:\>mysql -u root --password=testpw test2x < c:\test2x.sql

    I get:

    ERROR 1064 (42000) at line 34: You have an error in your SQL syntax;
    check the manual that corresponds to your MySQL server version for the
    right syntax to use
    near '' at line 1

    Note: test2x is the database name.

    thks

    docw@globetrotter.net Guest

  2. #2

    Default Re: ERROR 1064 when trying to load dump from sql file

    Should be:
    mysql -u root -ptestpw test2x < 'test2x.sql'

    net wrote: 

    irampagemc@gmail.com Guest

  3. #3

    Default Re: ERROR 1064 when trying to load dump from sql file

    On 22 Oct 2006 12:52:26 -0700, net wrote:
     

    The error is in the statement that starts on line 34 of your sql
    script c:\test2x.sql. As you didn't post the script, we can't
    tell what went wrong.
    The MySQL error codes are doented in the manual, by the way.
    --
    ( Kees
    )
    c[_] Build a fire for a man and he will be warm for
    a day, but set fire to that man and he will be
    warm forever! (Sun Tzu) (#443)
    Kees Guest

  4. #4

    Default Re: ERROR 1064 when trying to load dump from sql file

    net wrote:
     


    So you have an error on line 34, and you are asking us what's wrong with it
    without posting it?


    --
    Brian Wakem
    Email: http://homepage.ntlworld.com/b.wakem/myemail.png
    Brian Guest

Similar Threads

  1. Flash9.ocx Crash info!! Dump File
    By Superman75 in forum Macromedia Flash Player
    Replies: 28
    Last Post: December 18th, 07:58 AM
  2. null 500 error when trying to load ANY .cfm file
    By jgladnick in forum Coldfusion Server Administration
    Replies: 1
    Last Post: November 2nd, 09:22 AM
  3. Replies: 2
    Last Post: October 14th, 04:49 PM
  4. dump log/text continuously to file
    By Andreas O. Jaunsen in forum PERL Beginners
    Replies: 0
    Last Post: September 23rd, 07:29 PM
  5. How to locate memory dump file
    By Rebecca in forum SCO
    Replies: 7
    Last Post: July 23rd, 03:39 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139