424,269 Members | 1,298 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,269 IT Pros & Developers. It's quick & easy.

mysqldump problem

P: 2
Hi :-)...............,

I am having a problem with mysqldump with mysql 5.0.27 installed on a win xp pro sp2.

I just want to do a simple backup of all my databases.
I have xp installed in the D drive and the mysql datafiles in a folder "MySQL Datafiles" in the F drive.

This is my problem:

I go to this location "D:\Program Files\MySQL\MySQL Server 5.0\bin" from the command prompt and type:
Expand|Select|Wrap|Line Numbers
  1. mysqldump --user=root --password=password --databases
And I get the error:
The filename, directory name, or volume label syntax is incorrect.

When I type this command:
Expand|Select|Wrap|Line Numbers
  1. mysqldump --user=root --password=password petcatalog >petcatalogbackup
I get this error:
The system cannot find the file specified.

The files and folders that I have in F:\MySQL Datafiles are:
file before reinstallation in feb2007 (inside this folder there is one file "ibdata1")


I also have another small problem, though unrelated to the above:
I have created another user other than 'root' called 'phpuser' with all privileges, but when I try to remove all privileges of root when logged in as phpuser:
revoke all on *.* from root@localhost;

I get the error:
Error 1045: Access denied for user 'phpuser'@'localhost' (using password: YES)

Can you please tell me what is going wrong and how I can correct this problem.

Thanks in advance. :-)...................


"Tension is who you think you should be. Relaxation is who you are"
- An old Chinese proverb.
Jul 1 '07 #1
Share this Question
Share on Google+
2 Replies

P: 2

Had spent about 6 hours on this yesterday. Got really tired.......... Exhausted google too!!!!!

Finally found the solution just now, by trial and error! And its quite funny!!!!

The command that doesn't work when I give:
mysqldump --user=root --password=password petcatalog > petcatalogbackup

works when I give this!
mysqldump --user=root --password petcatalog > petcatalogbackup

It now asks for a password, I type 'password' and hit enter...... and it works!!!!!!

Found another thing.
"--databases" doesn't work, whereas "--all-databases" works!

If someone can tell me 'why' this strange thing has happened, it would be real nice.

And the 2nd part of my problem is still unsolved - Why I am not able to remove all the privileges of root?


"Tension is who you think you should be. Relaxation is who you are"
- An old Chinese proverb.
Jul 1 '07 #2

Expert 5K+
P: 5,058
Hi, and welcome to TSDN!

I'm moving this to the MySQL Forums.
Please try to refrain from posting in the Articles section!

Jul 3 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.