This is what I do (assuming your user is 'root'):
/path-to-/mysqldump -uroot -pYOURPASSWORD --opt --all-databases > backup.sql
Alternatively you can pipe it into another database like so:
/path-to-/mysqldump -uroot -pYOURPASSWORD --opt --all-databases | /path-to-/mysql -hIPADDRESS -uroot -pYOURPASSWORD
Cheers, David Orlovich
On 26/10/2004, at 7:53 AM, Perry, Matthew (Fire Marshal's Office) wrote:
How do I provide a password?
I have been trying -p password[mypass] mysqldump sampledb > ./backup/file.txt
-Matt
_____
From: dpgirago@xxxxxxxxxxxxxx [mailto:dpgirago@xxxxxxxxxxxxxx] Sent: Monday, October 25, 2004 11:24 AM To: Perry, Matthew (Fire Marshal's Office) Cc: php-db@xxxxxxxxxxxxx Subject: Re: backing up database with mysqldump
MySQLdump is an executable program. From the command line:
C:\>mysqldump databasename > ./path/to/backup/file.sql (or file.txt )
C:\>mysqldump --help
gives all the options
dave
"Perry, Matthew (Fire Marshal's Office)" <Matthew.Perry@xxxxxxxxxxxx>
10/25/2004 11:14 AM
To:
php-db@xxxxxxxxxxxxx
cc:
Subject:
backing up database with mysqldump
I have attempted to follow the documentation for mysqldump both on mysql.com
and previous emails to this list server. Unfortunately none of the advice
has helped me successfully backup my database. I have been spoiled by
phpmyadmin backup procedures and have never had to manually set up a backup
system for a local server.
From shell> what should I enter tot to backup my database called "sampdb" to
a location "c:/backups"?
Everything I have tried spits out an error message.
-Matt
Dr David Orlovich, Senior Lecturer in Botany.
Department of Botany, University of Otago, P.O. Box 56, (Courier: 464 Great King Street) Dunedin, New Zealand.
Phone: (03) 479 9060 Fax: (03) 479 7583
Web: http://www.botany.otago.ac.nz/
Ecology, Conservation and Biodiversity Research Group: http://www.otago.ac.nz/erg/
Botanical Society of Otago: http://www.botany.otago.ac.nz/bso/
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
