macOS copying mySQL database to server

[mark2288]

So I'm trying to learn some SQL and I'm trying to copy a sample database to mySQL server and I get this error:

pu108710:~ Mark$ mysql -umysql -pPASSWORD sampleDB < mysqlsamp.sql
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'sampledb'

any ideas what i'm doing wrong? thanks in advance for any help!

 

[lee1210]

Your user doesn't have create database privileges. This thread addresses this:
http://bytes.com/forum/thread714421.html

-Lee

 

[mark2288]

thanks Lee. seems that issue is fixed. now when i do it, i get this error:

pu108710:~ Mark$ mysql -uroot -pPASSWORD DBname < mysqlsamp.sql
ERROR 1049 (42000): Unknown database 'dbname'

ideas? thanks again for the help!

 

[AlmostThere]

Make sure the database exists before trying to connect to it (either create it manually or put it in the script and remove from the command line)

 

[mark2288]

went ahead and created the database then copied the sample into it. thanks a lot for the help!

do you any of you know of any good mySQL tutorial sites/books?