Reloading database backup fails with table full error.

[sbotnick]

I'm attempting to reload a database dump on a new server and get the following table full error. Below the error is the table status output. I don't know much about the innards of mysql, but it looks like the data length exceeds the max data length. Any ideas on recovering from this issue and is it a bug of some sort? The target is CentOS8.1, the source CentOS7.x. Target filesystem space is adeqate- ~900GB for the ~230MB .sql file

# mysql -u root -p cacti < /home/user/mon01-int-cacti.sql
Enter password:
ERROR 1114 (HY000) at line 2308: The table 'poller_output' is full

MariaDB [(none)]> SHOW TABLE STATUS FROM cacti LIKE 'poller_output';
+---------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+---------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+
| poller_output | MEMORY | 10 | Fixed | 59580 | 2134 | 127272096 | 127126648 | 2983545 | 0 | NULL | 2020-01-31 03:08:11 | NULL | NULL | utf8mb4_unicode_ci | NULL | | |
+---------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+
1 row in set (0.00 sec)

[TheWitness]

You need to increase you maximum memory table space in MariaDB/MySQL. There is a setting for it. You will have to restart MariaDB/MySQL first.

It's something like

MAX_HEAP_TABLE_SIZE

You need to simply make larger.

[sbotnick]

That did it. Thank-you!