TurnKey Linux Virtual Appliance Library

TKLBAM Not Restoring DBs? (MySQL)

scott.modesto's picture

I just tried to do my first migration. Ran the restore in WebMin, and at the end it is not listing any DBs (MySQL) being restored. How can I tell if they are being backed up in the first place? and any ideas as to why it is not restoring them?

And, if I manually restore the DBs, and attempt to bring up the Joomla sites, I get an Error 500.

The TurnKey Package I am using is: turnkey-lamp-11.2-lucid-x86-vmdk
- On both the source and the new restore...

Thank you in advance.


Jeremy Davis's picture

I have heard that others have had issues

If the permissions and/or passwords on the database(s) have been changed from default. Are you restoring to the same appliance or to a clean install?

If you are restoring to an existing instance, then perhaps permissions/passwordd may be the reason why you are getting errors on manual DB restore too? Not sure, only guessing really...

Can you try restoring to a clean install? I guess it will depend on whether you are running on a VM or bare metal. If download quota isn't an issue, perhaps try restoring to a clean VM (even if you normally run bare metal).

Scott C's picture

Hi Jeremy, Thanks for the

Hi Jeremy,

Thanks for the reply. I am attempting to restore to a fresh vm image.

Interesting note. When the restore completes, at the end it says something like "Restoring Databases" and lists nothing under that. Then says you should reboot.... 

Jeremy Davis's picture

Ok well fresh VM should be ok

But obvously it's not... It should just work. The potential issues I mentioned above shouldn't be an issue with a restore to a clean appliance IMO.

The fact that nothing is listed on the screen under restored DBs is worrying but I don't have anything backed up with DBs ATM myself to be able to conform that the message itself is a concern. I'm assuming that you are trying your site after a restore and it's not working?

Unfortunately I haven't had enough experience with TKLBAM and DBs to know for sure what might be going on.

According to the TKLBAM docs, unless an override has been set, by default is should be backing up the whole DB. Perhaps post (or at least consult) the contents of /var/log/tklbam-restore so we can have a look whats actually happening on restore.

As for your question about knowing what has been backed up, the backup log should be /var/log/tklbam-backup. You can also run a simulation with the -s switch ie tklbam-backup -s

Perhaps also double check that the DB hasn't inadvertantly been disallowed via /etc/tklbam/overrides

Scott C's picture

Looks as if when I imported

Looks as if when I imported my DBs from my IIS machine, it messed up some of the permissions/user credentials. Thanks for your help! There is one issue I have noticed, if you upgrade WebMin, and if you dont upgrade it on the restore destination, then it breaks..

Jeremy Davis's picture

Good to know!

This info may well help others importing from alternative OS to TKL so thanks for posting.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)