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
[mysqld]
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?