Ah, good call. I'm too used to my database user matching my current user from unixland. (no, not root :P)
- Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 2:10 PM To: Perry, Matthew (Fire Marshal's Office) Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] backing up database with mysqldump C:\>mysqldump -uadministrator -p test > test.sql Enter password: ************** "Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]> 10/25/2004 01:53 PM To: [EMAIL PROTECTED] cc: Subject: RE: [PHP-DB] backing up database with mysqldump How do I provide a password? I have been trying -p password[mypass] mysqldump sampledb > ./backup/file.txt -Matt _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 11:24 AM To: Perry, Matthew (Fire Marshal's Office) Cc: [EMAIL PROTECTED] 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)" <[EMAIL PROTECTED]> 10/25/2004 11:14 AM To: [EMAIL PROTECTED] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php