You are here
TH - Wed, 2013/11/27 - 12:51
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:
- Used Turnkey 13 lighttpd-php-fastcgi in a "template" VMWare VM and made the adjustments I needed.
- tlkbam'ed a backup into a local path.
- Prepared two "real" virtual machines with the OVF version of the appliance above.
- scp'ed the backup files from the template VM to the "real" ones.
- 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:
Problem solved
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