[Solved] DB missing after Account recreation

[lsvcam]

Hello Team,

my account lsvcam has been deleted (due to inactivity, i guess).

I recreated it, but now the SQL-Database is missing. 

    $db_host        = 'johnny.heliohost.org';
    $db_database    = 'lsvcam_webcamData';
    $db_port        = '3306';

Any chance to get it back easily?

[wolstech]

There is a backup for your account from 2024-07-25 available that contains an lsvcam_webcamData database. That can still be downloaded from https://heliohost.org/backup/ even though it is almost 2 years old.

The files from your account should be available as recently as May 8 if you need them. Just let us know.

For the databases, Krydos could check for raw .frm and .ibd files off the server for you if you want to attempt recovery of newer data, but actually getting data from those is difficult if we can even find the files. To check he would need the names of the individual tables within the database.

[lsvcam]

Thank you.
The Database just consists of one Table: webcamLSVData
Would you please try to recover it?

In "files", from May, the database is not included?

Thanks!

[wolstech]

No, the backup from May will not contain databases. We were only able to recover the contents of the Home folder as of the day of the crash. The database server was damaged by the crash and associated disk issues, and the majority of the data was lost. 

If anything at all is recoverable, it's going to be raw server files that represent the table, and you'll need to spend some time trying to extract the data from them. The data will not be something that you can just import into a new account.

Escalating to Krydos.

[Krydos]

I emailed a link for you to download the newest backup. It contains your files from 2026-05-08 when the server was powered off, and two binary database files. The database files are .frm and .ibd. It should be possible to extract the data from them. I have googled it and found several different methods of recovering the data out of binary files like this. Let us know if you're able to extract your data and the method you used so we can provide this information to other people who have the same issue.