Sample Header Ad - 728x90

How to restore MySQL DB via command line while closing the SSH session?

0 votes
1 answer
309 views
I am importing a large MySQL 8 database on Ubuntu 20.04 where the import takes > 24h. Unfortunatelly my provider reconnets every 24h which leads to a stop of the import. I am issuing this command on a ssh shell which blocks the cursor until finished: mysql -u user -p dbname import.txt 2>&1 The command should also save all output/errors to the txt file import.txt How can this be changed so that it results in a process number and I can close the session?
Asked by merlin (323 rep)
Jul 5, 2021, 08:02 AM
Last activity: Jul 5, 2021, 11:07 PM