Results 1 to 11 of 11

Thread: backup directadmin : mysqldump error

  1. #1
    Join Date
    Dec 2008
    Posts
    495

    backup directadmin : mysqldump error

    Hi

    When I want to backup from directadmin, I have these error on all databases :

    Error while backing up database admin_Liens
    Error while backing up database admin_Liens: The sql file is 0 bytes in size: /home/admin/admin_backups/admin/backup/admin_Liens.sql
    mysqldump error output: mysqldump: Got error: 1045: Access denied for user 'da_admin'@'localhost' (using password: YES) when trying to connect
    When I run mysqldump manually, with da_admin user, there are no problem. It is just when I want to run from directadmin backup.
    I run last version of DA. There was no backup before, because admin of this server never used it.

    Do you have an idea about this problem ?

  2. #2
    Join Date
    Jun 2003
    Location
    California
    Posts
    26,123
    Which backup are you using?

    Jeff
    +1 951 643-5345
    Third-Party DirectAdmin administration and support
    Dedicated Servers, Dedicated Reseller Accounts
    NoBaloney Internet Services div. Qnito Incorporated
    848 North Rainbow Blvd., Suite #3789
    Las Vegas, NV 89107-1103

  3. #3
    Join Date
    Dec 2008
    Posts
    495
    This one : Admin Backup/Transfer (address : serveurxxx:2222/CMD_ADMIN_BACKUP)

    After, I take option CRON or NOW (same error)

    thanks for your help

  4. #4
    Join Date
    Jun 2003
    Location
    California
    Posts
    26,123
    Check ownership/permissions of your mysql files. That's all I can think of.

    Jeff
    +1 951 643-5345
    Third-Party DirectAdmin administration and support
    Dedicated Servers, Dedicated Reseller Accounts
    NoBaloney Internet Services div. Qnito Incorporated
    848 North Rainbow Blvd., Suite #3789
    Las Vegas, NV 89107-1103

  5. #5
    Join Date
    Dec 2008
    Posts
    495
    Thanks

    I reverify, and all is ok. All permissions are the same than other VPS in the same server.
    And no problem in other VPS.

  6. #6
    Join Date
    Jul 2008
    Location
    Maastricht
    Posts
    2,850
    Try this.
    Go to: /usr/local/directadmin/conf
    create a file there called my.cnf and add this:
    Code:
    [client]
    user=da_admin
    password=thepassword_here
    Does it work then?
    Greetings, Richard.

  7. #7
    Join Date
    Dec 2008
    Posts
    495
    Thanks.
    This file is already here with same permissions than the other VPS.

  8. #8
    Join Date
    Dec 2008
    Posts
    495
    I've found the problem !!!

    It is because I've a bad password in /root/.my.conf

    That a little ... stupid ? or like a small bug.

    Thanks for your help

  9. #9
    Join Date
    Jul 2008
    Location
    Maastricht
    Posts
    2,850
    Well... it's not a bug. Normally there is no .my.conf in /root so you might wonder how that got there and where you need it for.

    Edit: Sorry. I know how it got there but I ment to say you normally don't need it there. If you forget about it, then it can cause these kinds of problems.
    Last edited by Richard G; 10-13-2012 at 05:49 AM.
    Greetings, Richard.

  10. #10
    Join Date
    Dec 2008
    Posts
    495
    It is usefull to have .my.cnf to use with tuning-primer or mysqltuner.
    But "normally", I have to put the good one password...

    I'm not sure it's a good idea that directadmin take password in this file, and not in his own files. But it is a detail.

    Thanks for all people trying to help me, with my stupid error.

  11. #11
    Join Date
    Jul 2008
    Location
    Maastricht
    Posts
    2,850
    You're welcome. And it's not a stupid error. Anybody can make mistakes or sometimes forget about a setting they made elsewhere. Happens to everybody.

    Anyway, good to see it's solved.
    Greetings, Richard.

Similar Threads

  1. mysqldump error output
    By bralain in forum MySQL / PHP
    Replies: 2
    Last Post: 10-01-2012, 04:41 AM
  2. mysqldump error
    By wtfbrb in forum Reseller-Level Difficulties
    Replies: 4
    Last Post: 07-16-2010, 01:44 PM
  3. Admin Backup/Transfer mysqldump error
    By jirawat in forum General Technical Discussion & Troubleshooting
    Replies: 4
    Last Post: 07-01-2009, 03:15 PM
  4. mysqldump error while creating all accounts backup
    By tttomasz in forum MySQL / PHP
    Replies: 1
    Last Post: 06-25-2009, 12:22 PM
  5. Subject: An error occurred during the backup (mysqldump error output)
    By seachen in forum Reseller-Level Difficulties
    Replies: 0
    Last Post: 08-27-2008, 02:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •