ISPconfig SQL Backup

Discussion in 'General' started by ochorocho, Jun 26, 2014.

  1. ochorocho

    ochorocho Member

    Hey,

    i recently migrated my ISPconfig install to another server which worked very well.

    The old ISPconfig installation made automatic webspace AND Database backups.

    The new one with latest ISPconfig version does not do the database backup anymore.

    How to enable database backups again?

    Thanks.

    ochorocho
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Check that the mysql root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf is correct.
     
  3. ochorocho

    ochorocho Member

    Hey Till,

    i verified the password in the config file and corrected it.
    I'll wait till the backup routine is triggered tonight :)
    is there a way to trigger the backup manually?

    Thank you!
     
  4. ochorocho

    ochorocho Member

    Hey,

    still no SQL backups available.

    in /var/log/ispconfig/ispconfig.log is still get connection errors:

    Code:
    25.06.2014-01:57 - ERROR - Unable to connect to mysqlAccess denied for user 'root'@'localhost' (using password: YES)
    25.06.2014-01:58 - ERROR - Unable to connect to mysql: Access denied for user 'root'@'localhost' (using password: YES)
    Thanks.
     
  5. ochorocho

    ochorocho Member

    Hey...

    @fiza200, sorry i'm not getting what you talking about

    @Till, i verified the SQL Backup on a new installed CentOS 6.5 with ISPconfig 3.0.5.4.

    It does not do any SQL backups either.

    Thank you.

    Cheers,
    Jochen
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    This means that the mysql root password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf is wrong or your mysql server is not acessible on localhost at all for the root user.
     
  7. ochorocho

    ochorocho Member

    Yep, i double checkd it.
    The password is now correct but no SQL backups are created.

    I did NOT see this error on the other (clean) install and it does not do backups either.

    Cheers,
    Jochen
     
  8. kugman

    kugman New Member HowtoForge Supporter

    just run /usr/local/ispconfig/server/cron_daily.sh
    this runs the daily cron script that also takes the backups... thats the way i do manually trigger backups
     
  9. florian030

    florian030 Well-Known Member HowtoForge Supporter

    Be carefull: this will mess your statistics. This is not the way to run manual a backup. cron_daily creates every backups (and delete the outdate backups). say: run cron_daily 10x / a day a you have no really backups ;)
     

Share This Page