> hoping my connection doesn’t drop
You don't perform resource-intensive operations on a big database over unreliable remote connections. Find another way to be closer to the server, ideally on the same machine, or the same LAN at least.
For manual stuff like this, using screen/tmux from a session on the server itself used to be the standard approach.
For manual stuff like this, using screen/tmux from a session on the server itself used to be the standard approach.