Empty database backup

  • Resolved roneycs

    (@roneycs)


    4 years, 10 months ago

    The file backup is being performed correctly, when checking the backup of the tables, it is completely empty

    File .sql

    #
# Powered by XCloner Site Backup
# https://www.xcloner.com
#
# Host: https://www.MYDOMAIN.com.br
# Generation Time: Apr 29, 2020 at 02:55
# PHP Version: 7.2.22
# Database Charset: utf8mb4
# MYSQL innodb_version: 5.7.20
# MYSQL protocol_version: 10
# MYSQL slave_type_conversions: 
# MYSQL version: 10.2.10-MariaDB
# MYSQL version_comment: MariaDB Server
# MYSQL version_compile_machine: x86_64
# MYSQL version_compile_os: Linux
# MYSQL version_malloc_library: system
# MYSQL version_ssl_library: OpenSSL 1.0.1e-fips 11 Feb 2013
# MYSQL wsrep_patch_version: wsrep_25.20
# MYSQL DEFAULT_CHARACTER_SET_NAME: utf8mb4
# MYSQL SCHEMA_NAME: utf8mb4_unicode_ci
#
# Database : my_db
# --------------------------------------------------------

#
# Finished at: Apr 29, 2020 at 02:55
#

    log

    2020-04-29 11:21:13 24459 [Warning] Aborted connection 24459 to db: 'my_db' user: 'my_user' host: 'localhost' (Got timeout reading communication packets)

    • This topic was modified 4 years, 10 months ago by roneycs.
    • This topic was modified 4 years, 10 months ago by roneycs.
Viewing 14 replies - 1 through 14 (of 14 total)
  • Plugin Support jimiero

    (@jimiero)

    Hello,

    Seems like you get a connection tiemout to your database, I’d suggest you to contact your hosting company and ask about why it’s getting tiemout.

    Thread Starter roneycs

    (@roneycs)

    I have a machine on the linode where I run the hestiacp cpanel I own the hosting

    Plugin Support jimiero

    (@jimiero)

    In that case please check why you get a connection timeout on your database, maybe try to increase the limits so such timeout doesn’t happen.

    Thread Starter roneycs

    (@roneycs)

    I’ll check

    • This reply was modified 4 years, 10 months ago by roneycs.
    Plugin Support jimiero

    (@jimiero)

    As mentioned, you need to solve your connection issue, nothing we can do on our side if you have issues with your database connection.

    Thread Starter roneycs

    (@roneycs)

    note that in php I have an execution variable.

    max_execution_time = 30

    change

    max_execution_time = 300

    I will test and give feedback

    Thread Starter roneycs

    (@roneycs)

    I made changes to the variables and nothing works

    Plugin Support jimiero

    (@jimiero)

    Those are php settings, you need to check your database settings.

    Thread Starter roneycs

    (@roneycs)

    I made several changes to my.conf

    max_allowed_packet
    interactive_timeout
    wait_timeout

    none worked

    Thread Starter roneycs

    (@roneycs)

    I did a test with another backup plugin and it is being done normally.

    UpdraftPlus was used.

    Could you please inform me on which level of mariadb do I need to make changes to run the plugin?

    [client]
port=3306
socket=/var/run/mysqld/mysqld.sock

[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log

symbolic-links=0
local-infile=0

skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1024M
table_open_cache = 10
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 240K

#innodb_use_native_aio = 0
innodb_file_per_table

max_connections=1000
max_user_connections=500
wait_timeout=300
interactive_timeout=6000
long_query_time=5

[mysqld]
skip-name-resolve
connect_timeout = 600
net_read_timeout = 600
net_write_timeout = 600
innodb_buffer_pool_size = 5G

!includedir /etc/mysql/conf.d/
    Plugin Support jimiero

    (@jimiero)

    Hello,

    In your mysql configuration, you should try increasing your *_timeout values to a higher value and see how it goes.

    Make sure after you changed those values, you also restart mysql server.

    Thread Starter roneycs

    (@roneycs)

    Variables were changed * _time

    I am using another plugin, which is working perfectly.

    Plugin Support jimiero

    (@jimiero)

    Hello,

    I don’t know what other plugins does, but the error you provided us, is coming from your environment, you can have a look on google:

    https://www.google.com/search?q=Got+timeout+reading+communication+packets&rlz=1C5CHFA_enRO882RO882&oq=Got+timeout+reading+communication+packets&aqs=chrome..69i57j0l7.186j0j7&sourceid=chrome&ie=UTF-8

    This issue should be fixed in the latest release, feel free to re-open the ticket if the issue persists.

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘Empty database backup’ is closed to new replies.