Skip to main content

I can 't download database backups (openfileslimit)

Unnamed User
  • Edited

Hi all,

When i download a backup from cPanel > Backup > Full backup or Account Backups, the files from site are there, but on /mysql directory there is no database but a file with name openfileslimit and content: 40000

From research I did on the internet and here, I understood that there is a "limit" in mysql.

First I made a change on /etc/my.cnf file, to increase this limit. On line "open_files_limit" i set value as 750000 (open_files_limit=750000) > restart sql > create and download a new backup > on /mysql directory still openfileslimit and content: 40000.

After that, on /etc/systemd/system/mysqld.service.d. I found LimitNOFILE=40000. I supposed it was the content inside openfileslimit on /mysql directory. I changed it to 1850000. > Restart sql > create and download a new backup > on /mysql directory still openfileslimit and content: 1850000.

Then, on /etc/systemd/system/mysqld.service.d i set limitNOFILE=infinity. Restart sql > create and download a new backup > on /mysql directory still openfileslimit and content: 750000. I thought that it is the value of "open_files_limit=750000" at /etc/my.cnf. 

I set the line "open_files_limit=750000" as comment (#open_files_limit=750000). Restart sql > create and download a new backup > the /mysql directory is empty!

From tweak settings > sql i changed "Allow cPanel & WHM to determine the best value for your database service's open_files_limit configuration" to "off". Restart sql > create and download a new backup > the /mysql directory is empty!

What else do I have to check? What am I missing?

OS:AlmaLinux v8.10.0 STANDARD standard | cPanel Version: 120.0.11

Comments

9 comments

Date Votes
  • cPRex Jurassic Moderator

    Hey there!  From your description, I'm not completely sure what you're trying to fix.  I guess I'm not sure how you're just getting a single file from the MySQL backups on the machine.

    If you are also in cPanel, there is a separate "Download a Database Backup" section - does the same behavior happen there?

    0
  • Unnamed User
    • Edited

    Hi and sorry if I wasn't clear.

    Every time i get a backup from cPanel, i have got the files from entire website except database. 

    On backups files, on directory /mysql (which used to be a backup of database) there is no database only a file named "openfileslimit".

    This also happens in backups of the previous days.

    If a client asks me for a backup of the previous days or weeks, I only have to give him the files. The database does not exist in the backup directories.

    From cPanel > Backup > Download a Database Backup, i can download database, but if i want a previous days database backup i can 't have it.

    0
  • cPRex Jurassic Moderator

    Thanks for the clarification.  That's definitely odd - does the same thing happen if you manually create a backup of that account with /scripts/pkgacct?  Does this happen with all accounts on the server?

    0
  • Unnamed User

    Hi and thnx for your reply.
    This is happen to all server accounts.
    Ι ran /scripts/pkgacct xngprod

    and i get this:

    [root@hs21 ~]# /scripts/pkgacct xngprod
    [2024-07-18 09:20:04 +0300] pkgacct started.
    [2024-07-18 09:20:04 +0300] pkgacct version 10 - user : xngprod - tarball: 1 - target mysql : default - split: 0 - incremental: 0 - homedir: 1 - mailman: 1 - backup: 0 - archive version: 4 - running with uid 0
    [2024-07-18 09:20:04 +0300] pkgacct using '/usr/local/cpanel/3rdparty/bin/pigz -6 --processes 1 --blocksize 4096 --rsyncable' to compress archives
    [2024-07-18 09:20:04 +0300] pkgacct working dir : /home/cpmove-xngprod
    [2024-07-18 09:20:04 +0300] Copying Reseller Config...[2024-07-18 09:20:04 +0300] Done
    [2024-07-18 09:20:04 +0300] Copying Suspension Info (if needed)...[2024-07-18 09:20:04 +0300] Done
    [2024-07-18 09:20:04 +0300] Copying Team Info (if needed)...[2024-07-18 09:20:04 +0300] Done
    [2024-07-18 09:20:04 +0300] Copying installed SSL certificates and keys...[2024-07-18 09:20:04 +0300] Performing “ApacheTLS” component....
    [2024-07-18 09:20:04 +0300] Completed “ApacheTLS” component.
    [2024-07-18 09:20:04 +0300] Done
    [2024-07-18 09:20:04 +0300] Copying DKIM keys....[2024-07-18 09:20:04 +0300] Done
    [2024-07-18 09:20:04 +0300] Copying Bandwidth Data....[2024-07-18 09:20:04 +0300] Performing “Bandwidth” component....
    Summary databases … done!
    [2024-07-18 09:20:04 +0300] Completed “Bandwidth” component.
    [2024-07-18 09:20:04 +0300] Done
    [2024-07-18 09:20:04 +0300] Copying Dns Zones.......xngprod.com...[2024-07-18 09:20:04 +0300] Done
    [2024-07-18 09:20:04 +0300] Copying Mail files....[2024-07-18 09:20:04 +0300] Performing “MailConfig” component....
    [2024-07-18 09:20:04 +0300] Completed “MailConfig” component.
    [2024-07-18 09:20:04 +0300] Done
    [2024-07-18 09:20:04 +0300] Copying proftpd file....[2024-07-18 09:20:04 +0300]Done
    [2024-07-18 09:20:04 +0300] Performing “Logs” component....
    ...log file sizes [8919308 byte(s)]......xngprod.com-bytes_log......2024.xngprod.com-ssl_log.bkup......xngprod-imapbytes_log......xngprod.com......xngprod.com-ssl_log......2024.xngprod.com-ssl_log......2024.xngprod.com......2024.xngprod.com.bkup...[2024-07-18 09:20:04 +0300] Completed “Logs” component.
    [2024-07-18 09:20:04 +0300] Copy userdata...[2024-07-18 09:20:04 +0300] Done
    [2024-07-18 09:20:04 +0300] Copy custom virtualhost templates...[2024-07-18 09:20:04 +0300] Done
    [2024-07-18 09:20:04 +0300] Copying mailman lists and archives....Done copying mailman lists and archives.
    [2024-07-18 09:20:04 +0300] Copying homedir.............
    [2024-07-18 09:20:05 +0300] Done
    [2024-07-18 09:20:05 +0300] Fixing up EA4 .htaccess blocks: /home/xngprod/2024.xngprod.com/.htaccess  /home/xngprod/public_html/.htaccess  Done.
    [2024-07-18 09:20:05 +0300] Performing “Postgresql” component....
    [2024-07-18 09:20:05 +0300] Completed “Postgresql” component.
    [2024-07-18 09:20:05 +0300] Performing “Mysql” component....
    [2024-07-18 09:20:05 +0300] Determining mysql dbs...Use of uninitialized value $version_line in pattern match (m//) at /usr/local/cpanel/Cpanel/MysqlUtils/Dump.pm line 65.
    Use of uninitialized value $mysqldump_ver in concatenation (.) or string at /usr/local/cpanel/Cpanel/Pkgacct/Components/Mysql.pm line 119.
    [2024-07-18 09:20:05 +0300] ...mysqldump version: ...
    [2024-07-18 09:20:05 +0300] ...mysql version: 8.0...[2024-07-18 09:20:05 +0300] Saving mysql privs...[2024-07-18 09:20:05 +0300] Done
    [2024-07-18 09:20:05 +0300] Saving mysql authentication information...[2024-07-18 09:20:05 +0300] Done
    [2024-07-18 09:20:05 +0300] Storing MySQL databases...
    [2024-07-18 09:20:05 +0300] Storing database littlebu_shopdata
    [2024-07-18 09:20:05 +0300] Can’t find mysqldump!
    [2024-07-18 09:20:05 +0300]     ...propagated at /usr/local/cpanel/Cpanel/Try.pm line 230.
    [2024-07-18 09:20:05 +0300] Storing database xngprod_test_db
    [2024-07-18 09:20:05 +0300] Can’t find mysqldump!
    [2024-07-18 09:20:05 +0300]     ...propagated at /usr/local/cpanel/Cpanel/Try.pm line 230.
    [2024-07-18 09:20:05 +0300] Storing database xngprod_uction
    [2024-07-18 09:20:05 +0300] Can’t find mysqldump!
    [2024-07-18 09:20:05 +0300]     ...propagated at /usr/local/cpanel/Cpanel/Try.pm line 230.
    [2024-07-18 09:20:05 +0300] Storing database xngprod_uction_2024
    [2024-07-18 09:20:05 +0300] Can’t find mysqldump!
    [2024-07-18 09:20:05 +0300]     ...propagated at /usr/local/cpanel/Cpanel/Try.pm line 230.
    [2024-07-18 09:20:05 +0300] Done
    [2024-07-18 09:20:05 +0300] ...Done
    [2024-07-18 09:20:05 +0300] ...Done
    [2024-07-18 09:20:05 +0300] Completed “Mysql” component.
    [2024-07-18 09:20:05 +0300] Performing “MysqlRemoteNotes” component....
    [2024-07-18 09:20:05 +0300] Completed “MysqlRemoteNotes” component.
    [2024-07-18 09:20:05 +0300] Performing “CpUserFile” component....
    [2024-07-18 09:20:05 +0300] Completed “CpUserFile” component.
    [2024-07-18 09:20:05 +0300] Performing “Cron” component....
    [2024-07-18 09:20:05 +0300] Readable crontab file (/var/spool/cron/xngprod) found; copying …
    [2024-07-18 09:20:05 +0300] Completed “Cron” component.
    [2024-07-18 09:20:05 +0300] Performing “Quota” component....
    [2024-07-18 09:20:05 +0300] Completed “Quota” component.
    [2024-07-18 09:20:05 +0300] Performing “Integration” component....
    [2024-07-18 09:20:05 +0300] Completed “Integration” component.
    [2024-07-18 09:20:05 +0300] Performing “AuthnLinks” component....
    [2024-07-18 09:20:05 +0300] Completed “AuthnLinks” component.
    [2024-07-18 09:20:05 +0300] Performing “APITokens” component....
    [2024-07-18 09:20:05 +0300] Completed “APITokens” component.
    [2024-07-18 09:20:05 +0300] Performing “DNSSEC” component....
    [2024-07-18 09:20:05 +0300] Completed “DNSSEC” component.
    [2024-07-18 09:20:05 +0300] Performing “Custom” component....
    [2024-07-18 09:20:05 +0300] No custom components to perform.
    [2024-07-18 09:20:05 +0300] Completed “Custom” component.
    [2024-07-18 09:20:05 +0300] Performing “AutoSSL” component....
    [2024-07-18 09:20:05 +0300] Completed “AutoSSL” component.
    [2024-07-18 09:20:05 +0300] Storing Subdomains....
    [2024-07-18 09:20:05 +0300] Done
    [2024-07-18 09:20:05 +0300] Storing Parked Domains....
    [2024-07-18 09:20:05 +0300] Done
    [2024-07-18 09:20:05 +0300] Storing Addon Domains....
    [2024-07-18 09:20:05 +0300] Performing “Password” component....
    [2024-07-18 09:20:05 +0300] Completed “Password” component.
    [2024-07-18 09:20:05 +0300] Performing “DigestShadow” component....
    [2024-07-18 09:20:05 +0300] Completed “DigestShadow” component.
    [2024-07-18 09:20:05 +0300] Copying shell.......[2024-07-18 09:20:05 +0300] Done
    [2024-07-18 09:20:05 +0300] Performing “WebCalls” component....
    [2024-07-18 09:20:05 +0300] Completed “WebCalls” component.
    [2024-07-18 09:20:05 +0300] Performing “BrandCustomizations” component....
    [2024-07-18 09:20:05 +0300] Completed “BrandCustomizations” component.
    [2024-07-18 09:20:05 +0300] Performing “PublicContact” component....
    [2024-07-18 09:20:05 +0300] Completed “PublicContact” component.
    [2024-07-18 09:20:05 +0300] Performing “MailLimits” component....
    [2024-07-18 09:20:05 +0300] Completed “MailLimits” component.
    [2024-07-18 09:20:05 +0300] Performing “LinkedNodes” component....
    [2024-07-18 09:20:06 +0300] Completed “LinkedNodes” component.
    [2024-07-18 09:20:06 +0300] Creating Archive ......................................................
    [2024-07-18 09:22:16 +0300] Done
    [2024-07-18 09:22:16 +0300] pkgacctfile is: /home/cpmove-xngprod.tar.gz
    [2024-07-18 09:22:19 +0300] md5sum is: 1975750a68075807fc3bd353aa2589a8
    [2024-07-18 09:22:19 +0300]
    [2024-07-18 09:22:19 +0300] size is: 2276071756
    [2024-07-18 09:22:19 +0300]
    [2024-07-18 09:22:19 +0300] homesize is: 3147890688
    [2024-07-18 09:22:19 +0300]
    [2024-07-18 09:22:19 +0300] homefiles is: 45522
    [2024-07-18 09:22:23 +0300]
    [2024-07-18 09:22:23 +0300] mysqlsize is: 95674170
    [2024-07-18 09:22:23 +0300] pkgacct completed

    I see a problem repeating itself: Can’t find mysqldump!

    PS1: Recently we faced a know problem with mysql.(Upstream issue: MySQL 8.0.38 does not start) Maybe in our attempts to fix the problem we messed something up...

    PS2: I have also requested support for another issue we are experiencing. It's in the database section. It is possible that the two problems have a common source (-u: command not found)

    0
  • Unnamed User
    • Edited

    Also when I ran the command which mysqldump, I got those results

    [root@hs21 ~]# which mysqldump
    /usr/bin/which: no mysqldump in (/usr/local/cpanel/3rdparty/lib/path-bin:/usr/share/Modules/bin:/usr/local/cpanel/3rdparty/lib/path-bin:/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin:/opt/cpanel/composer/bin:/root/bin)
    on [root@hs21 ~]# find / -name mysqldump, I got those results: 
    [root@hs21 ~]# find / -name mysqldump
    find: ‘/proc/2213342’: No such file or directory
    Maybe mysql reinstalling is the solution, but
    1st which command i need? whm run on Almalinux 8.10
    2nd if mysql re-installation it is necessary, i want version 3.0.37 not 3.0.38 (because of the previous problem we faced)
     
     
    0
  • cPRex Jurassic Moderator

    Ah, so that's a clue!

    You shouldn't need to reinstall MySQL to deal with this issue.  Checking a working AlmaLinux 8 system we can see that specific command is provided by the mysql-community-client package:

    [root@host /]# rpm -qf /usr/bin/mysqldump
    mysql-community-client-8.0.38-1.el8.x86_64

    Can you try reinstalling just that package?

    0
  • Unnamed User

    Hi again,

    please i wont a command for mysql 8.0.37, because with mysql 8.0.38 database server doesn't start.

    0
  • quietFinn

    Execute command:
    rpm -qf /usr/bin/mysqldump
    It tells you the package you have to reinstall.

     

    0
  • cPRex Jurassic Moderator

    You are just reinstalling the mysql-community-client package on the server, so you'll get the correct version.  We aren't updating any packages with this work.

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post