Is it possible to keep mysql migration running without keeping connection open?
- by taw
ALTER TABLE can easily take a few days - and during this time there's a non-negligible chance of connection getting terminated due to network problems. Is it possible to start ALTER TABLE (or CREATE TABLE ... SELECT ...; or some other very long running query) and leave it running without keeping connection open all the time?
(the obvious solution of screen + console mysql client won't easily work as there's no ssh running on that server, only mysqld).