Multi server mysql backup success, but missing files - ipsconfig 3.2

Discussion in 'Installation/Configuration' started by Grafadie, Jan 20, 2022.

  1. Grafadie

    Grafadie New Member

    Welcome,
    i got problem with backup of mysql database for websites. Files are normaly comprest and backup but backup od database is missing.
    I got no errors. When run form command line
    Code:
    php /usr/local/ispconfig/server/backup-now.php --id=166 --type=mysql
    Making backup of website id=166, type=mysql, please wait...
    All operations finished, status success.
    
    it got success
    i have checked database information in config tables and everything look ok.
    There is information about backup in web_domain and web_database

    any clue how to investigate?

    ls -la /var/backup/web166
    Code:
    drwxr-x---  2 web166 client56      4096 Jan 20 09:51 .
    drwxr-x--- 24 root   root          4096 Jan 20 09:50 ..
    -rwxr-x---  1 web166 client56 113820095 Jan 20 09:24 manual-web166_2022-01-20_09-24.zip
    -rwxr-x---  1 web166 client56 113830479 Jan 20 09:51 manual-web166_2022-01-20_09-51.zip
    
     
    Last edited: Jan 20, 2022
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Is the mysql root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf correct?
     
  3. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    In those .zip files I suppose you'll find the backup of the database?
     
  4. Grafadie

    Grafadie New Member

    Yes

    Code:
    $clientdb_host                  = 'localhost';
    $clientdb_user                  = 'root';
    $clientdb_password              = 'corectpassword';
    
    Th0m
    olny webfiles in zip archive
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Is this an older website database? If yes, try to go to the website database settings, ensure that the correct website is selected in the website field and press save. then run the backup again.
     
  6. Grafadie

    Grafadie New Member

    did't see colleration between creation time and backup. This is new website - settings are ok. privileges for db are ok root got access on localhost and 127.0.0.1
    on main serwer there is no problem only on slave server is problem with mysql backup :/ in DB parent_domain_id is correct
    what shoud i check? where to look?
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    The away ISPConfig works changed over the years and such an issue can be caused when a database has been created with an older ISPConfig 3.1 version which did not had the website select field. But if your system is up to date and you created the website and database recently, then this is not the issue here.

    Are the database and website on the same system, or on separate systems?
     
  8. Grafadie

    Grafadie New Member

    website and db are in the same server (slave)

    if i good see last auto backup in slave od db was 2021-01-27_00-11 for one of first websites.

    any debug tool ?
     

Share This Page