Re: MySQL Dump
| From: | Mikael Grön | Date: | Mon, 14 May 2007 11:40:37 +0000 |
| Subject: | Re: MySQL Dump | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-27897@lists.php.net to get a copy of this message | ||
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:/Gustav WibergHi! 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