Database Export

I’ve started a job where they have Matomo for analytics, and I decided to update the Matomo version. The upgrade of the software went fine, but the database upgrade failed.

The error was SQLSTATE[HY000]: General error: 1114 The table '#table_anme' is full

I’ve found that this is likely caused by innodb_data_file_path | ibdata1:12M:autoextend

I tried increasing this value but the variable is read-only. Do I need to stop the MySQL server, add this in a config file e.g. `/etc/mysql/mysql.conf.d/table_size.cnf as

innodb_data_file_path = ibdata1:12M:autoextend:max:512M

On the topic I’ve asked my boss if we can remove some old data but he wants it kept. Is there a way I can export the data for an older time period so I can keep the database smaller but reimport the data at a later stage if the boss requires it?

In one recent case, a user had this error:
SQLSTATE[HY000]: General error: 1114 The table 'xxxdbdata\/tmp\/#sql999_9999_00' is full

They fixed it by doubling the table size. :slightly_smiling_face:

Their specific case was in Aurora:

1 Like