SHOW VARIABLES;
SELECT @@GLOBAL.sql_mode;

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'total' cannot be null
Create mysqlId in the following way:
sql_mode= ""
SET sql_mode = '';


run mysql in background
https://faun.pub/restore-mysql-dump-in-the-background-82cd01be854b
First, start your restore process using the usual MySQL command
ubuntu@ip-172-31-2-182:~$ mysql -u remote -p snappoint < snappoint.sql
when it is prompt, enter the relevant password at the MySQL command prompt for the mentioned user
Press Ctrl + z to suspend the current process ( MySQL Process which just started )
Then Run the bg command to move the above-suspended process to the background and resume its operation
ubuntu@ip-172-31-2-182:~$ bg
[1]+ mysql -u remote -p snappoint < snappoint.sql &
Run the jobs command to see the list of running processes in the current shell session, in my case I have only one process which is my MySQL
ubuntu@ip-172-31-2-182:~$ jobs
[1]+  Running                 mysql -u remote -p snappoint < snappoint.sql &