Jeremy Davis's picture

Firstly, sorry for the slow reply. I have opened a new bug on our issue tracker. If you'd care to add more info directly there, please feel free. Otherwise posting back here is fine too.

Can you please tell me what version of TurnKey and TKLBAM you are using? Please give details for both the backup source system (i.e. where the backup came from) and the target system (i.e. where you restored the backup to).

FYI the info is easiest gathered from the commandline, e.g. on my local TKLDev (lines starting with '#' are the commands from a root shell):

# turnkey-version
turnkey-tkldev-14.1-jessie-amd64
# apt-cache policy tklbam
tklbam:
  Installed: 1.4.1+17+g71478bd
  Candidate: 1.4.1+17+g71478bd
  Version table:
 *** 1.4.1+17+g71478bd 0
        999 http://archive.turnkeylinux.org/debian/ jessie/main amd64 Packages
        100 /var/lib/dpkg/status

Also, it's probably a moot point now (~3 weeks too late), but you can roll back a restore. Obviously that's only relevant if you are restoring to the same machine as the backup came from, but it may be worth knowing.

I'm guessing from your post you probably don't, but if you still have access to the original DB (i.e. a full dump direct from MySQL - not what's in the backup), is it possible for you to sanitise it and share it with us (privately)? Also a copy of the DB dumped from the restored system would also be useful. If so (either the original DB or both), please email it/them to "support AT turnkleylinux.org". Then we can do some testing and try to understand why it didn't work for you. FWIW since TKLBAM v1.3 was released (almost 4 years ago) you are the first to report issues with MySQL views not restoring properly. So my guess is that there is either some recent regression or some edge case in your scenario that we aren't accounting for.

For future reference, I recommend regular testing of backups. You can do a restore (followed by a rollback) on the same machine if you'd like (and it's probably worth testing too) but personally I highly recommend at least occasional restore to a new machine (of the same TurnKey version, or at least the same major version).

Actually many TurnKey users use TKLBAM as a means to migrate data between a "dev" instance (often a local VM) and a "production" instance (often a Hub server). Using that sort of workflow has the bonus advantage of making regular testing of your backups a regular event. It also makes upgrading TurnKey versions (at least the initial testing/auditing phase as noted in the docs) an easy addition.

Also for future reference, you are best off starting a new thread (and link to a previous thread if you think it's relevant). You will get a much quicker response that way as unanswered threads, or new comments on active threads generally get priority over new posts to old threads.