Reply to thread

First of all, thanks for updating the link to the sql but I got myself a little problem.


So when I try to import the sql into my database I get this error:

[CODE]C:\Users\Administrator\AppData\Roaming\DBeaverData\drivers\clients\mysql_8\win\mysql.exe -u root --host=localhost --port=3306 hotel

Task 'MySQL restore' started at Mon Jan 02 22:38:34 CET 2023

ERROR 1366 (22007) at line 372: Incorrect string value: '\xC3\x84\xC3\xA4ni...' for column `hotel`.`catalog_items`.`catalog_name` at row 2807


Task 'MySQL restore' finished at Mon Jan 02 22:38:35 CET 2023

2023-01-02 22:38:35.322 - IO error: Process failed (exit code = 1). See error log.

2023-01-02 22:38:35.322 - java.io.IOException: Process failed (exit code = 1). See error log.

    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.validateErrorCode(AbstractNativeToolHandler.java:242)

    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:223)

    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:262)

    at org.jkiss.dbeaver.ext.mysql.tasks.MySQLNativeToolHandler.doExecute(MySQLNativeToolHandler.java:47)

    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:83)

    at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39)

    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

[/CODE]


As you can see on the next photo I'm missing a lot of tables since it stops importing I guess.

[MEDIA=imgur]JdDGbyz[/MEDIA]


Maybe I missed out on something but I don't think so. Is there something wrong with the sql?


Thanks in advance.


Top