I am trying to restore a MySQL dump of size around 18GB to another MySQL server, which is running inside a container using this command:
mysql -h example.com -u user -p matomo < dump.sql
But it fails with an error:
ERROR 1114 (HY000) at line 7238: The table 'piwik_log_link_visit_action' is full
Many other small tables are copied successfully, but while coping this table it fails with above error. The size of this table is more than 2GB.
Based on different suggestions available on Stack Overflow, I tried each one but nothing worked.
I tried adding 'autoextend' to the
I also tried to increase the
heap_table_size by adding following parameter to the
Also, I made sure that the server (from where I am running the dump restore command) has enough space (more than 20GB of storage available). But nothing worked.
I tried debugging this more and found that, the docker container where MySQL is running has overlay filesystem of size 5GB which starts getting filled and as soon as it fills 100%, I get above error.
Volume mounted on the container is of more than 30GB size. I am not sure from where this overlay file system is coming in docker. Overlay is something coming from docker I guess, but not sure where I can increase its size.
I can't even go inside the overlay directory and keep deleting or freeing the space. Can anyone please help me here.
[mysqladmin] user=user1 [mysqld] skip_name_resolve explicit_defaults_for_timestamp basedir=/opt/bitnami/mariadb port=3306 tmpdir=/opt/bitnami/mariadb/tmp socket=/opt/bitnami/mariadb/tmp/mysql.sock pid_file=/opt/bitnami/mariadb/tmp/mysqld.pid max_allowed_packet=256MB bind_address=0.0.0.0 log_error=/opt/bitnami/mariadb/logs/mysqld.log character_set_server=utf8 collation_server=utf8_general_ci plugin_dir=/opt/bitnami/mariadb/plugin innodb_data_file_path=ibdata1:10M:autoextend:max:10G max_heap_table_size=2G tmp_table_size=2G [client] port=3306 socket=/opt/bitnami/mariadb/tmp/mysql.sock default_character_set=UTF8 plugin_dir=/opt/bitnami/mariadb/plugin [manager] port=3306 socket=/opt/bitnami/mariadb/tmp/mysql.sock pid_file=/opt/bitnami/mariadb/tmp/mysqld.pid !include /opt/bitnami/mariadb/conf/bitnami/my_custom.cnf