Oh yeah, of course. :)
Mike
Gustav Wiberg skrev:
Hi there!
Username and password for root (for all databases then) you mean?
/Gustav
-----Original Message-----
From: Mikael Grön [mailto:php@xxxxxxxx]
Sent: Monday, May 14, 2007 1:32 PM
To: ''php windows' (php-windows@xxxxxxxxxxxxx)'
Subject: Re: MySQL Dump
mysqldump -uusername -p -A > output.file
Enter password: [password]
Done
Gustav Wiberg skrev:
Hi there!
Thanx! Does this mean that I can't use option -ALL databases when using usernames and passwords?
(I want to create a backup each night for every database we own with mysqldump)
Best regards
/Gustav Wiberg
-----Original Message-----
From: Mikael Grön [mailto:php@xxxxxxxx]
Sent: Monday, May 14, 2007 11:49 AM
To: 'php windows' (php-windows@xxxxxxxxxxxxx)
Subject: Re: MySQL Dump
mysqldump -uusername -ppassword database > output.file
or
mysqldump -uusername -p database > output.file
which lets you specify the password cloaked right after you've hit enter.
Remember, no spaces between -u and the username or -p and the password.
Mike
Gustav Wiberg skrev:
Hi!
Trying to figure out mysqldump. How would i type to making a backup of a database with specific username and password with mysqldump?
I've tryed making a backup-schema through MySQL Administrator but there it says... Wrong password. I've changed the password type to Obscure but it doesn't seem to matter.
Best regards
/Gustav Wiberg
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
