Database Backup Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • falconking
    Senior Member
    • Sep 2006
    • 215
    • 3.6.x

    Database Backup Error

    Using SSH (putty), I have followed the instructions posted here:



    to take a backup of my db, thru this command:

    PHP Code:
    mysqldump --opt --u king -p vb backup.sql 
    but I receive the following error (although I am 100% sure that the username, the dbname and password are all correct) :

    Code:
    mysqldump: Got error: 1044: Access denied for user 'king'@'localhost' to database 'vb' when selecting the database
    What seems to be wrong here?! Is it permissions?!
    How can I fix this, please!!!
  • copiertalk
    Senior Member
    • Oct 2005
    • 851
    • 3.7.x

    #2
    see if their is a prefix for the username, database or even both. Cpanel added a prefix to mine when I set the username and database up.
    www.Copiertalk.com - Everything Copier , Printer, Fax

    Comment

    • Hayk
      Senior Member
      • Sep 2007
      • 504
      • 5.2.x

      #3
      Show the exact folder of backup, e.g.

      HTML Code:
      mysqldump --opt -Q -u king -p vb > www/dump/backup.sql
      And be sure that username and dbname are correct.
      vBProjects - Professional vBulletin Services and Solutions
      vBSpring - Premium vBulletin Add-ons

      Comment

      • flnz400
        New Member
        • Feb 2008
        • 29

        #4
        Pretty sure it should look more like this...

        mysqldump --opt -uDB_UN-pPW-Dadmin_forum >
        /home/DB_UN/DB_DBNAME-$(date +%Y%m%d%H).sql

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...