MySQL Dump
in [Windows]
|
Prev: Gantt-charts in PHP?
Next: Printing via webapp
From: Gustav Wiberg on 14 May 2007 05:41 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
From: =?ISO-8859-1?Q?Mikael_Gr=F6n?= on 14 May 2007 05:49 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 > >
From: Gustav Wiberg on 14 May 2007 06:28 Hi there! Thanx. Does this mean that I have to this on each database if I want to create ba -----Original Message----- From: Mikael Grön [mailto:php(a)emgee.se] Sent: Monday, May 14, 2007 11:49 AM To: 'php windows' (php-windows(a)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
From: Gustav Wiberg on 14 May 2007 06:30 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(a)emgee.se] Sent: Monday, May 14, 2007 11:49 AM To: 'php windows' (php-windows(a)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
From: =?ISO-8859-1?Q?Mikael_Gr=F6n?= on 14 May 2007 07:32
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(a)emgee.se] > Sent: Monday, May 14, 2007 11:49 AM > To: 'php windows' (php-windows(a)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 >> >> >> > > |