Migration from SQLite to MySQL

  • In the Wiki I find the instructions to migrate from Liveconfig using SQLite to using MySQL. I experience a problem in the third step:


    Zitat

    Schritt 3: Import der Daten
    Importieren Sie nun die in Schritt 1 exportierten Daten in MySQL:


    $ mysql -u liveconfig -p -h localhost LIVECONFIG < /root/dump.sql
    Enter password: ************


    I get the error ERROR at line 91: Unknown command '\\'. Line 91 is a very long line beginning with


    SQL
    INSERT INTO APPTEXTS (AT_ID, AT_REV, AT_APPID, AT_LANG, AT_TITLE, AT_DESC_SHORT, AT_DESC_LONG, AT_VENDOR_URL) VALUES


    and it continues with all the values on the same line. 91. Likely the script lcdbdump needs some correction to avoid long long lines?

  • Hello,


    the problem was an incorrect escaping of a description in the Application Installer, which broke the SQL generated by lcdbdump.
    We've updated the lcdbdump utility, please re-download it (here) and try again.
    If you still experience any problems, please let me know.


    Best regards


    -Klaus Keppler


    (SHA1 of the new lcdbdump tool: 362bbf92349b3b8a481cad8d86b5274b855847b2)

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!