I am using 5.0.26, community version

The sql file is at c:\db.sql

I tried

mysql -u root -p 11111 db < c:\db.sql (or enclosed by '', ``)

does not work

mysql -u root -p db < "c:\db.sql" (or enclosed by '', ``)

does not work

mysqlimport db < "c:\db.sql" (or enclosed by '', ``)

does not work

How can I do this simple job?

Thanks

(The sql file is less than 20M$B!K(B

What actually is the error you get? and what is actually in the db.sql
if its an output mysqldump, what you are doing should be good.

If its an export in CSV file you will have to import/load it in a
different fashion.

load data local infile 'db.sql' into table table_name;

On Feb 14, 3:53 pm, Vancouver <minghu...@gmail.com> wrote:
> I am using 5.0.26, community version
>
> The sql file is at c:\db.sql
>
> I tried
>
> mysql -u root -p 11111 db < c:\db.sql (or enclosed by '', ``)
>
> does not work
>
> mysql -u root -p db < "c:\db.sql" (or enclosed by '', ``)
>
> does not work
>
> mysqlimport db < "c:\db.sql" (or enclosed by '', ``)
>
> does not work
>
> How can I do this simple job?
>
> Thanks
>
> (The sql file is less than 20M$B!K(B