Re: backing up database with mysqldump

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@mdanderson.org [mailto:dpgirago@mdanderson.org] Sent: Monday, October 25, 2004 11:24 AM To: Perry, Matthew (Fire Marshal's Office) Cc: php-db@lists.php.net Subject: Re: [PHP-DB] 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@fmo.hctx.net> 10/25/2004 11:14 AM To: php-db@lists.php.net cc: Subject: [PHP-DB] 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/