422,024 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,024 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:
Folders:
file before reinstallation in feb2007 (inside this folder there is one file "ibdata1")
memberdirectory
mysql
petcatalog
test

Files:
athlon64-avlljt.err
athlon64-avlljt.pid
ib_logfile0
ib_logfile1
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
Hi....................

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?

Cheers!!

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

Atli
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!

Moderator
Jul 3 '07 #3

Post your reply

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