4

In a Virtual Box VM I had CentOS 7 server installed in a VDI HDD and for some reason “Something I did obviously…” I cant boot the machine with the messages bad magic number you need load the kernel

First, I have tried some things like clean the system with xfs_repair and the repair was good but still cant boot it. Try to change the UIDD from Grub to with out successes try to install Grub but at the moment to do chroot the filesystem gets chroot failed to run command /bin/bash…

Sadly I have a database which I didn’t recently backup. I can mount the disk, backup all my files but I haven’t figured out how to extract the database from MariaDB, I would like not lose that. Hopefully some one have some idea or know how to do it. Since it’s there right?

Giacomo1968
  • 58,727
denn0n
  • 303

1 Answers1

1

The data for Maria DB is stored in the directory:

/var/db/mysql/

Or:

/var/lib/mysql/

The separate folders in there should match your database name. So copy that whole directory — or just the databases you need — and you have your database data again.

To restore it, just build a new VM with MariaDB in place and once that is done, stop MariaDB and copy your databases into that same /var/db/mysql/ or /var/lib/mysql/ on your new setup.

So if your database name is /var/db/mysql/my_database/or /var/lib/mysql/my_database you then just need to copy my_database/ to the /var/db/mysql/ or /var/lib/mysql/ on your new MariaDB install.

Giacomo1968
  • 58,727