DBeaver Error 1146 (42S02) on SQL database restore- Table 'acumatica.AUNotification' doesn't exist I am trying to restore a database dump from a file for an online SQL course I'm taking into DBeaver. When I restore it, however, it runs for a little bit and then I get the error message

ERROR 1146 (42S02) at line 4037: Table 'acumatica.AUNotification' doesn't exist


I've tried:


Manually dropping the table via the mysql command line, and then copying the CREATE TABLE statement from the .sql dump file to manually create it.
Reinstalling SQL
Using sqldump except I think it just dumped the existing file.
Doing mysql -u root -p --database=acumatica &lt; dump-acumaticadb-201903141403.sql


All of my attempts to restore it work for a little bit- when I refresh the database in DBeaver, it shows the table aunotification and all preceding tables. There are no subsequent tables. Also, I'm using the utf8mb4 charset, so I don't think that's the issue.

I would really appreciate any help someone could give- the other threads I've found online have not helped me.

Here's the full error message in DBeaver after restoring the database:

/usr/bin/mysql --host=localhost --port=3306 -u root acumatica
Task 'MySQL script' started at Sun Mar 22 11:43:56 PDT 2020
ERROR 1146 (42S02) at line 4037: Table 'acumatica.AUNotification' doesn't exist
Task 'MySQL script' finished at Sun Mar 22 11:44:01 PDT 2020
2020-03-22 11:44:01.556 - IO error: Process failed (exit code = 1). See error log.
2020-03-22 11:44:01.557 - java.io.IOException: Process failed (exit code = 1). See error log.
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:182)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:237)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:52)
    at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)


https://imgur.com/a/Tvcc9k3 error log screenshot

https://pastebin.com/KfCRW2G2 create statements and surrounding file
The create table may not have used quotes around the table name, while a reference to it does.

Unless lower_case_table_names=1 is set upon database creation, the case of the tablenames has to be respected when quoted.