I'm trying to import a dump ~500MB, ~300 tables using the
SOURCE command from withing the MySQL command line environment. Everything seems to go well with tables being created and being filled with data, but then at some point it just freezes.
Opening up another MySQL command line and checking
SHOW FULL PROCESSLIST, shows
| 13458 | someuser | localhost | mydatabase | Sleep| 11639 | | NULL |
If I try and change to
mydatabase and issue a
SHOW TABLES, that command also freezes and if I open up a third command prompt, and issue a
SHOW FULL PROCESSLIST, in addition to the original sleeping process I get the line:
| 13675 | someuser | localhost | mydatabase | Field List | 7861 | Waiting for table flush | |
tee session.out for logging, but the last three lines in the log file are:
Query OK, 0 rows affected (1.24 sec)
Query OK, 0 ro
that is, the last line is truncated as shown above.
If someone knows what is wrong and how to fix it, that would be fantastic, but failing that, any advice on debugging this further would be appreciated.