[RESOLVED] Trouble Exporting a database

kroleig1

I ave created a database on one computer and want to move it to another. I cant seem to find a quick way to export the database using the query browser. And if I try doing it at the cmd line I get a error 1045 access denied error.

This is the line I used at the command prompt.

mysqldump nunu > nunu121707.sql;

Is there any way to add my password to this line. I can log in to the client with my password just fine. Even doing it from the mysql cmd client gives me an error message.

Any help will be greatly appreciated.

I did not find any similar issues in the forums

Thanks
-r

bradgrafelman

If you want to add your username and password to login to the database, you can use the --user=username and --password=password options. For a list of the options available and a description of them, type mysqldump --help at a command prompt.

kroleig1

yes that worked..! Thanks. I just used:
mysqldump -u root -p sitename > sitenmbkp.sql

It prompted me for the password and I could then retrieve it from the bin directory just fine.

Thank you for your help
-r