Announcement

Collapse
No announcement yet.

Database Backup Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Backup Error

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

    http://www.vbulletin.com/docs/html/m...nce_ssh_backup

    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!!!

  • #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


    • #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


      • #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

        Loading...
        Working...
        X