Normal
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 hotelTask 'MySQL restore' started at Mon Jan 02 22:38:34 CET 2023ERROR 1366 (22007) at line 372: Incorrect string value: '\xC3\x84\xC3\xA4ni...' for column `hotel`.`catalog_items`.`catalog_name` at row 2807Task 'MySQL restore' finished at Mon Jan 02 22:38:35 CET 20232023-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.
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.