So randomly, I have lost a category. It was there 2 days ago, now its gone. Could have been caused by an SEO module, not sure, don’t really care, just want to restore the category so I can then try replicate the error on the dev site.
So I have a backup job that runs daily, it does a backup of “Database and Media” which was setup via backup GUI. Viewing the list of backups I can see “1595296802_media.tgz” backups for every day. So when using the GUI to perform a rollback, I get the error “You need more permissions to perform a rollback.”
So naturally believing it is a permission problem, I reset the permissions following your guide Attempted the roll back again, it failed with the same error.
So I am thinking of trying to use the command line approach, I believe the issue is database only, so I am running the command
bin/magento setup:rollback -d 1598061602_media.tgz
However that fails with the error “The rollback file is invalid. Verify the file and try again.”
So I thought I would download the backup and manually replace the database using PHPMyAdmin, however I cannot find the database backup in the ZIP. Maybe someone knows where it is?
Is it possible to view the categories in the database, and see if this missing one exists?
So right now, I am stuck…
Do you have any other ideas I could attempt?