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
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.
sqldumpexcept I think it just dumped the existing file.
mysql -u root -p --database=acumatica < 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://i.stack.imgur.com/6KNh1.jpg error log screenshot
https://pastebin.com/KfCRW2G2 create statements and surrounding file