RE: [PHP-WIN] MySQL Dump
| From: | Gustav Wiberg | Date: | Mon, 14 May 2007 12:00:00 +0000 |
| Subject: | RE: [PHP-WIN] MySQL Dump | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-27898@lists.php.net to get a copy of this message | ||
Hi!
Ok... Thanx!
Best regards
/Gustav Wiberg
-----Original Message-----
From: Mikael Grön [mailto:php@emgee.se]
Sent: Monday, May 14, 2007 1:41 PM
To: ''php windows' (php-windows@lists.php.net)'
Subject: Re: [PHP-WIN] MySQL Dump
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@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