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
Last activity: Jul 5, 2021, 11:07 PM