You are not logged in.

#1 2025-08-02 13:15:14

phunni
Member
From: Bristol, UK
Registered: 2003-08-13
Posts: 794

[Solved] Trying to restore data from previous mariadb installation.

My server died and I was a little bit out of date on my db backups (I know, I know - I will learn from this). Thankfully, the death of the server doesn't seem to have been to do with the drives themselves - so I've put them in the new machine and mounted them in the new system.

I then tried following the steps here, but then the database wouldn't start and was complaining about plugin related things (I have no idea what or why) or complaining about things such as "Unknown/unsupported storage engine: InnoDB".

I thought I'd try a different tack and ran mariadbd-safe --datadir=/path/to/old/db/files and then run the command suggested on the wiki which, in my case, ended up being:

mariadb-dump --single-transaction --flush-logs --events --routines --master-data=2 --databases weather -u root -p | xz -z > weather.sql

This, however, resulted in complaints about my not using binary logging - which, I'm guessing, is to do with config differences in the old database and the new one? The new one is currently nothing more than a brand new install with mariadb-upgrade run on it.

Please help me get out of this data restoration hell and get hold of the data that is so tantalisingly close!

Thanks in advance!

Last edited by phunni (2025-08-02 15:12:00)

Offline

#2 2025-08-02 15:11:48

phunni
Member
From: Bristol, UK
Registered: 2003-08-13
Posts: 794

Re: [Solved] Trying to restore data from previous mariadb installation.

Nvermind - in the end I just used a GUI tool to create a SQL script containing the table create and insertion of all the data.

Offline

Board footer

Powered by FluxBB