daily backups of websites are empty.

Discussion in 'Installation/Configuration' started by oliware, Apr 30, 2013.

  1. oliware

    oliware New Member

    The daily backup of all my websites are failing. The database files are empty.

    I can restore all files, but the mysqldump is empty.

    fe: db_c1devoogdt_wp_2013-04-28_22-32.sql.gz has a size of 58 bytes, when I unzip the file, size is 0.

    How can I determine what is wrong?

    I have a lot of entries like this in my cron.log:

    mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

    But where can I find where it gets his password ?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Set the correct mysql root password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf
     
  3. oliware

    oliware New Member

    when I manually login with that password, I can logon, but...
    A typically buggie thing, my password is something like this:

    <?php

    $clientdb_host = 'localhost';
    $clientdb_user = 'root';
    $clientdb_password = 'abcd20C&';

    ?>

    Can it be that the & is causing problems ?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes, better use a password that does not contain chars that get interpreted on the shell as operators.
     
  5. oliware

    oliware New Member

    indeed that was the problem, this shouldn't happen anymore anno 2013
     

Share This Page