Import DB tables

Virtualmin
1
SYSTEM INFORMATION
OS type and version Ubuntu 24.04
Webmin version 2.510
Virtualmin version 7.40.1
Webserver version Apache v 2.4.58
Related packages SUGGESTED

I had a problem with Virtualmin after an Ubuntu OS update.
I installed a new version that is working.

At the time, I copied the database files since I didn’t have updated backups.

Now on the new machine I can’t import some tables and I get the error

MariaDB [gal2]> check table esmitems;
ERROR 2006 (HY000): Server has gone away
No connection. Trying to reconnect…
Connection id: 3
Current database: gal2

±--------------±------±---------±-------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
±--------------±------±---------±-------------------------------------------------------------+
| gal2.esmitems | check | Error | Table ‘esmitems’ is marked as crashed and should be repaired |
| gal2.esmitems | check | error | Corrupt |
±--------------±------±---------±-------------------------------------------------------------+
2 rows in set (0.058 sec)

The files are .frm and .ibd

Can anyone help?

2

try mysqlrepair gal2

3

It seems it’s not possible in MariaDB with an InnoDB table.

note : The storage engine for the table doesn’t support repair

4

DB is one of my weakest areas but it seems to me that knowing the MariaDB versions involved might be helpful. They seem to not officially support a community site in favor of paid support though. :frowning:

5

I have not done this, but there are recovery modes in innodb

6

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.