loading data into mysql 5.0

hi all,
just installed ver 5, and want to load up mysqldump
file, cant seem to do it, had anybody done thins yet?

from the command line, i've typed mysql dbasetest <
myfile.sql

give me the user denied error, is there switched on
the command to log root in?


thanks






__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: loading data into mysql 5.0

mysql -u root -p -D < file.sql

-u Let you inform the user.
-p Will ask for a password.
-D Will select a database upon connect.

All at the MySQL Manual, or even with "mysql --help". Download and read it.

Best regards,

On 11/3/05, Mark Mchugh wrote:
> hi all,
> just installed ver 5, and want to load up mysqldump
> file, cant seem to do it, had anybody done thins yet?
>
> from the command line, i've typed mysql dbasetest <
> myfile.sql
>
> give me the user denied error, is there switched on
> the command to log root in?
>
>
> thanks
>
>
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org