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: 244
mysql
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