Jump to content

Archived

This topic is now archived and is closed to further replies.

maiesqueelio

mysql dump problems

Recommended Posts

I am having serious problems with this MySQL thingy.

 

I need to dump the contents of a database, but I have 2 problems.

 

1.) I try to run the mysql.exe from the \'bin\' folder and it starts but then the window dissappears.

 

2.) When I do the mysqldump i get GOT error: 1045 : Access denied for user \'ODBC@localhost\' (Using password YES) when trying to connect

 

I have also tried other users such as \'root@localhost\' and the results are similar

 

I have updated the password several times and I\'m quite sure that I got the right one. Please help.

 

Mario.

Share this post


Link to post
Share on other sites

shivabharat > I think \'mysqldump\' should be executed at the shell and it is not a mysql internal command.

 

To call mysqldump do this:

 

C:>cd mysqlbin

C:mysqlbin>mysqldump database > export.sql

 

OR

 

C:mysqlbin>mysqldump database > \"C:myfolderexport.sql\"

Share this post


Link to post
Share on other sites

Gentelemen, I truly appreciate the input from both of you, but my problem persists.

 

When I attempted one of your solutions I got this

C:Documents and SettingsMario> C:mysqlbin>mysqldump database > \"C:myfolderexport.sql

The system cannot find the path specified.

 

 

Another attempt yielded this

C:Documents and SettingsMario>C:>cd mysqlbin

\'C:\' is not recognized as an internal or external command,

operable program or batch file.

 

When I attempted to raise the mysql prompt (then I know I can do the dump) this is what I got:

C:Documents and SettingsMario> C:>cd mysqlbin

\'C:\' is not recognized as an internal or external command,

operable program or batch file.

 

If you can provide further input I would in your debt.

Mario

Share this post


Link to post
Share on other sites
When I attempted one of your solutions I got this

C:Documents and SettingsMario> C:mysqlbin>mysqldump database > \"C:myfolderexport.sql

The system cannot find the path specified.

 

If this is what you did then it\'s clear what the problem is:

 

This line: C:mysqlbin>mysqldump

 

Should be

 

C:mysqlbinmysqldump

 

You are simply trying to specify the path to the mysqldump command here.

 

So the correct full line should be:

 

C:mysqlbinmysqldump database > C:myfolderexport.sql

 

This calls mysqldump and redirects output to the file c:myfolderexport.sql

Share this post


Link to post
Share on other sites

I\'m one step closer... When I followed gizmola\'s (thank you) advice this is what I got

 

C:Documents and SettingsMario> C:mysqlbinmysqldump db_yucatica > C:tempex

port.sql

C:mysqlbinmysqldump: Got error: 1045: Access denied for user: \'ODBC@localhost

\' (Using password: NO) when trying to connect

 

When I checked the temp folder there was a file \'export.sql\' which means that when I get the password problem right I will get the database dump.

2.) When I do the mysqldump i get GOT error: 1045 : Access denied for user \'ODBC@localhost\' (Using password YES) when trying to connect

 

I have also tried other users such as \'root@localhost\' and the results are similar

 

I have updated the password several times and I\'m quite sure that I got the right one. Please help.

 

So if you can, please help with my password problem, I constantly refer to the MySQL documentation but have found no solution yet.

 

Mario

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.