From: Shawn Green
Date: October 30 2012 4:58pm
Subject: Re: Dumping drupal databases
List-Archive: http://lists.mysql.com/mysql/228536
Message-Id: <50900748.9010806@oracle.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 10/30/2012 12:34 PM, Tim Johnson wrote:
> ... snip ...
>
>    Clearly, I have failed to pose my question clearly, because the
>    responses indicate that I have not been understood, so I will try
>    again:
>
>    *****************************************************************
>    mysqldump does not recognize the drupal databases!
>      Example :
>        linus:prj tim$ mysqldump event -hlocalhost -utim
>        -pXXXXXX > event.sql
>        mysqldump: Got error: 1049: Unknown database 'event' when
>        selecting the database
> ... snip ...

Your syntax is inverted. Put the name of the database at the end.

mysqldump -hlocalhost -utim -pXXXXXX event> event.sql

If you fail to do so, you would login as the 'anonymous user' if it is 
still enabled on that machine and that account typically has zero 
privileges.

Check the command-line syntax here:
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html


-- 
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN