Seite 1 von 1

Table 'text' is full

Verfasst: 05.08.2022, 19:27
von Xilo
While importing a phpmyadmin-backuo of a mediawiki 1.31 with MyooosDumper 5.0.19 under xampp7.4 i get after a while the error :
MySQL-ERROR MySQL meldet: The table 'text' is full (ALTER TABLE `text` ADD PRIMARY KEY (`old_id`); -> The table 'text' is full)

Mediawiki uses Mysql with Innodb and so a normal backup-restore is not possible without errors (just as in Joomla).
At Stackoverflow i found that in Innodb's my.cnf stands innodb_data_file_path = ibdata1:10M:autoextend:max:512M
But which entries are necessary for Mysqldumper ?

Re: Table 'text' is full

Verfasst: 06.08.2022, 10:37
von r23
Hello,

welcome to mod,


the MySQL manual says
If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. See Section 8.4.6, “Limits on Table Size”.

Solutions in the MySQL manual
https://dev.mysql.com/doc/refman/8.0/en ... limit.html

Good luck

Ralf