RE: [PHP-WIN] MySQL Dump
| From: | Gustav Wiberg | Date: | Mon, 14 May 2007 11:39:00 +0000 |
| Subject: | RE: [PHP-WIN] MySQL Dump | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-27896@lists.php.net to get a copy of this message | ||
Hi there!
Username and password for root (for all databases then) you mean?
/Gustav
-----Original Message-----
From: Mikael Grön [mailto:php@emgee.se]
Sent: Monday, May 14, 2007 1:32 PM
To: ''php windows' (php-windows@lists.php.net)'
Subject: Re: [PHP-WIN] 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@emgee.se]
> Sent: Monday, May 14, 2007 11:49 AM
> To: 'php windows' (php-windows@lists.php.net)
> Subject: Re: [PHP-WIN] 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