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

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

docw@globetrotter.net wrote:
> 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

On 22 Oct 2006 12:52:26 -0700, docw@globetrotter.net wrote:

>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

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 documented 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)

docw@globetrotter.net wrote:

> 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


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