List:General Discussion« Previous MessageNext Message »
From:Shawn Green Date:October 30 2012 4:58pm
Subject:Re: Dumping drupal databases
View as plain text  
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


Thread
Dumping drupal databasesTim Johnson30 Oct
  • Re:Dumping drupal databases小刀30 Oct
    • Re: Dumping drupal databasesTim Johnson30 Oct
      • Re: Dumping drupal databasesHassan Schroeder30 Oct
        • Re: Dumping drupal databasesReindl Harald30 Oct
          • Re: Dumping drupal databasesTim Johnson30 Oct
            • Re: Dumping drupal databasesReindl Harald30 Oct
              • Re: Dumping drupal databasesTim Johnson30 Oct
                • Re: Dumping drupal databasesAnanda Kumar30 Oct
                  • Re: Dumping drupal databasesTim Johnson30 Oct
            • Re: Dumping drupal databasesTim Johnson30 Oct
            • Re: Dumping drupal databasesShawn Green30 Oct
              • Re: Dumping drupal databasesTim Johnson30 Oct
        • Re: Dumping drupal databasesTim Johnson30 Oct
      • Re: Dumping drupal databasesKishore Vaishnav30 Oct
        • Re: Dumping drupal databasesTim Johnson30 Oct
  • Re: Dumping drupal databasesTim Johnson30 Oct
    • Re: Dumping drupal databasesTim Johnson30 Oct
Re: Dumping drupal databasesTim Johnson31 Oct
  • Re: Dumping drupal databasesReindl Harald31 Oct
    • Re: Dumping drupal databasesTim Johnson1 Nov
      • Re: Dumping drupal databasesReindl Harald1 Nov
        • Re: Dumping drupal databasesTim Johnson1 Nov
Re: Dumping drupal databasesTim Johnson31 Oct