thomasjenk
New Pleskian
- Server operating system version
- Ubuntu 20.04
- Plesk version and microupdate number
- Plesk Obsidian Web Host Edition Version 18.0.49 Update #2
0
The issue began when I removed a subscription from a plesk server that was a staging site for the main site that was also on the same server. However unaware to me the wp-config for the live site had never been changed to point to a different MySQL database and when I removed the subscription, the MySQL database with all the sites additions since 16th May 2022 [were gone].
Unfortunately, after realising that this SQL server held such important data, I checked for backups however there were only backups of the main site running and no server backups or of the staging site. Looking on the server through SFTP I found both the mysql.daily.dump zip files and the SQL preupgrade backups, I tried running these commands in an SSH terminal
cd /var/lib/psa/dumps
ls -l mysql.daily*
zcat mysql.daily.dump.0.gz | plesk db
This did restore both the deleted subscription and SQL database, but without any of its table structure or table data. I was referred to plesk support through the servers hosting provider support who spent the evening reviewing our case and came back saying that ...it seems that this database dump is not for a single website... (which is correct) ...,but requires privileges necessary to make edits to the entire Plesk database (psa)...
After attempting the recovery myself, but to no luck, I'm now in a very tough spot.
Does anybody have any advice on how I can restore or recover the table data from those files in another way?
The issue began when I removed a subscription from a plesk server that was a staging site for the main site that was also on the same server. However unaware to me the wp-config for the live site had never been changed to point to a different MySQL database and when I removed the subscription, the MySQL database with all the sites additions since 16th May 2022 [were gone].
Unfortunately, after realising that this SQL server held such important data, I checked for backups however there were only backups of the main site running and no server backups or of the staging site. Looking on the server through SFTP I found both the mysql.daily.dump zip files and the SQL preupgrade backups, I tried running these commands in an SSH terminal
cd /var/lib/psa/dumps
ls -l mysql.daily*
zcat mysql.daily.dump.0.gz | plesk db
This did restore both the deleted subscription and SQL database, but without any of its table structure or table data. I was referred to plesk support through the servers hosting provider support who spent the evening reviewing our case and came back saying that ...it seems that this database dump is not for a single website... (which is correct) ...,but requires privileges necessary to make edits to the entire Plesk database (psa)...
After attempting the recovery myself, but to no luck, I'm now in a very tough spot.
Does anybody have any advice on how I can restore or recover the table data from those files in another way?