Last active
January 5, 2022 18:17
-
-
Save sintret/00ef4f6d1a0aed79169e073a2ec117b3 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 & |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment