SOLVED: PHPRecipeBook restore from backup not showing data
Posted: Sat Apr 23, 2016 1:36 am
I just upgraded from Amahi 6 on Ubuntu to 8 on Fedora 21 (I know, late adopter). I backed up my recipe database and uploaded all the backups to an ftp server using phpMyBackup on a weekly cron job. I have 3 backups that are the exact same size since it has been about that long since I entered a new recipe. Anyway, I swapped hard drives, installed Fedora and got everything back up and running EXCEPT the phpRecipeBook. When I use phpMyBackup to import the backup file into the recipe database I see no change in the recipe webapp. MyBackup says it was successful, but I see no change, even after a reboot of the system and wiping the cache from my browser. I have tried multiple restore operations from different weeks and get the same result, nothing.
I was going to use phpMyAdmin to do a bit more manipulation of the database, but the recipebook database does not appear in the phpMyAdmin control panel.
Any hints on what might be going on here? I noticed that the phpRecipeBook looks different than the version I had before. Was there a change in the app that changed the database structure? If so, any hints on how to restore a backup from the previous version?
If I absolutely have to, I can plug the Ubuntu drive back in and pull the SQL file from the old drive although I'm not sure how much that would help. I was smart (read lucky) not to wipe and repurpose the drive that has the Ubuntu installation.
I was going to use phpMyAdmin to do a bit more manipulation of the database, but the recipebook database does not appear in the phpMyAdmin control panel.
Any hints on what might be going on here? I noticed that the phpRecipeBook looks different than the version I had before. Was there a change in the app that changed the database structure? If so, any hints on how to restore a backup from the previous version?
If I absolutely have to, I can plug the Ubuntu drive back in and pull the SQL file from the old drive although I'm not sure how much that would help. I was smart (read lucky) not to wipe and repurpose the drive that has the Ubuntu installation.