I am neither a DB administrator, nor a DevOps but I need to migrate a very large table (~500M rows) from one MySQL schema to another. For doing so, I use
mysqldumpbackup tool. Also, since the DB is an AWS DB, I establish an SSH connection to the Ubuntu server from terminal and then run the command from command line.
Everything works as needed and I can see the process being output on my terminal, but once my computer sleeps or I have an internet connection interruption, I am facing a problem:
client_loop: send disconnect: Broken pipe.
That's probably ok, but after reconnection to the Ubuntu server I don't see that process output on the terminal, nor I can see the corresponding process in the processes list.
I don't know if that can be, but once my terminal looses the connection with the server mysqldump terminates on the server without completion.
In order to be sure, I would like to know:
- if that can happen or no?
- Where mysqldump logs its process so I could take a look at the log file and see what happened?