On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> wrote:
mysqldump -u username -p database_name > database_name.sql
To explain:
-u username Replace 'username' with the database username.
-p This signifies that you'll use a password
(at a prompt)
database_name The full name of the database to dump
> Redirects all output to a file, deleting
previous data, if any
I was a bit puzzled seeing "-p database_name", as I was expecting that
to be seen as the password. After a bit of experimentation, it turns
out that (for example)
-uUSERNAME
is treated the same as
-u USERNAME
but
-pPASSWORD
interprets PASSWORD as the password, but
-p WORD
prompts for the password and uses WORD as the next argument (no
relation to the password), in this case as the database name.
How very inconsistent and obnoxious. Daniel, thank you for the prompt
to look at this.
--
Tim McDaniel, [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
