0

I'd like to migrate databases I have created using XAMPP to the the LAMP stack.

I've installed php, apache and mariadb following this: Arch Wiki Apache

The databases, which are to be imported are not sql-files, but rather ibd and rfm-files located in the /opt/lampp/var/mysql/ directory.

My mariadb datadir is the default /var/lib/mysql.

My question now is how to migrate these ibd and frm files to LAMP correctly?

Alex
  • 751
  • 1
  • 6
  • 34

1 Answers1

0

You need the entire tree, not just the .ibd files.

Install the new MySQL first, then copy all the old tree on top. (Or play games with directory names.)

A potential problem: What version of MySQL are you coming from? Going to? There could be incompatibilities.

Rick James
  • 135,179
  • 13
  • 127
  • 222