Is it possible to keep mysql migration running without keeping connection open?

Posted by taw on Stack Overflow See other posts from Stack Overflow or by taw
Published on 2010-04-20T03:59:52Z Indexed on 2010/04/20 4:03 UTC
Read the original article Hit count: 243

Filed under:

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).

© Stack Overflow or respective owner

Related posts about mysql