TH's picture

Hi,

a tklbam restore from a local path gives me the following error:

table: mysql/db
table: mysql/help_topic
ERROR 1064 (42000) at line 256: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version 
for the right syntax to use near
'(6) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_host' at line 2

This is what I did:

  1. Used Turnkey 13 lighttpd-php-fastcgi in a "template" VMWare VM and made the adjustments I needed.
  2. tlkbam'ed a backup into a local path.
  3. Prepared two "real" virtual machines with the OVF version of the appliance above.
  4. scp'ed the backup files from the template VM to the "real" ones.
  5. Tried a tklbam restore.

The template VM was changed to German keyboard and console, and I replaced MySQL with MariaDB+Galera.

Does anybody have an idea how to solve this, or perhaps where to look for the error?

Thanks in advance,

Tobi

Forum: 
Tags: 
TH's picture

Ok, that was easy.

As MariaDB+Galera are not in the sources.list of newly created appliances, I had to insert their repositories by hand, then installed these packages manually, to be sure.

Afterwards, the tklbam restore was successfull.

So it just was a discrepancy between the MySQL flavors.

Tobi

Add new comment