0

I have new MariaDB 10.5.15 installation and database files coming from MariaDB 10.2. How can I "import" these files into new server's database?

Background

After upgrading a jail from FreeBSD 11.3 to 12.1, MariaDB 10.2 was somehow removed and I had no option to make a sql dump.

I installed MariaDB 10.5 because 10.2 is no longer available. I recreated my database in new installation and then copied over old files. I can connect to DB and SHOW TABLES but can't select from any table. Error is Table 'mydb.mytable' doesn't exist in engine. I found here Database corruption with MariaDB : Table doesn't exist in engine that probably ibdata1 was missing.

It was not missing but obviously it does not know about my tables since they are just copied. I tried overwriting it with old ibdata1 which prevented MariaDB from starting.

Milan
  • 878
  • 2
  • 15
  • 32
  • 1
    If you have the exact full database directory from 10.2, a 10.5 instance will start on it. You can't mix and match files. – danblack Apr 04 '22 at 22:33

0 Answers0