Mysql import

Dryaf · 01-29-2010, 08:19 AM

Hello

I have a file data.sql I want to update my database with.

Code:

mysqlimport -u username -p db_password databasename data.sql

It ask me for password, I guess it is for database password which is db_password I enter it again but I get error :

Code:

1045 Access denied for user 'username'@'localhost' (using password: YES)

I ask why it ask me for password because I am sure the password I have entered which is db_password is the right one also I have full privileges over this database.

Thank you

idefiz · 01-29-2010, 08:28 AM

mysql -u username -p
enter
give password

what's the output?

Dryaf · 01-29-2010, 08:50 AM

When I do that I succeed to connect to mysql, I get message 'Welcome to MySQL monitor. Commands end with ...'.

Thank you

Dryaf · 01-29-2010, 08:50 AM

When I do that I succeed to connect to mysql, I get message 'Welcome to MySQL monitor. Commands end with ...'.

Thank you

prasanta · 01-29-2010, 09:33 AM

You can as well use this,

Code:

mysql -u username -p databasename < data.sql

Then enter the mysql password for the username. Initially you need to create the database.

--
Prasanta

idefiz · 01-29-2010, 09:41 AM

mysqlimport -u root -p databasename data.sql

and then give password

Dryaf · 01-29-2010, 10:36 AM

Thanks for you both.