If you're doing it interactively, you can just give it the -p flag and
it will prompt you.
Otherwise, I think the problem is you're overdoing it - the flag is
either "-p " or "--password=" followed by your password, so "-p mypass"
or "--password=mypass".
Also, I hope you meant you have been trying
mysqldump -p password[mypass] sampledb > ./backup/file.txt
This:
mysqldump -p sampledb > file.txt
Should get you started (and prompt for password), then move on to
mysqldump -p mypass sampledb > file.txt
Which should output it to the cwd, then you just need to get it going to
C:\backup\file.txt - which may, or may not, be as simple as replacing
file.txt with that (long time since windows commandline)
Cheers,
- 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: Perry, Matthew (Fire Marshal's Office)
[mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 1:53 PM
To: [EMAIL PROTECTED]
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
