Startseite » Forum » LiveConfig Forums (english) » Bugs and troubleshooting » Migration from SQLite to MySQL
Ergebnis 1 bis 2 von 2
  1. #1
    Erfahrener Benutzer
    Registriert seit
    09.07.2012
    Ort
    Spanien
    Beiträge
    271

    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:

    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

    Code:
    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?

  2. #2
    LiveConfig-Team Avatar von kk
    Registriert seit
    10.12.2010
    Beiträge
    3.172
    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)

Lesezeichen

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •