Shell closes before MySQL import completes

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Gary Fischman
    Senior Member
    • Jan 2001
    • 356
    • 3.0.10+

    Shell closes before MySQL import completes

    I have a big database (over 3M posts) and when I try to run an import, it takes a very long time. The problem is, after 1 hour, the shell closed by itself, killing the import before it completed. I assume there is a keystroke inactivity timeout on the shell.

    Should I try simply running the import in the background? E.g. -

    mysql -u username -p dbname < db_file.sql &

    Or is something else going on here?
  • mlx
    Senior Member
    • Jan 2001
    • 679
    • 3.8.x

    #2
    Could be your firewall cutting the "idle" connection after X minutes.

    Have a look at PuTTY's config: Connection -> Seconds between keepalives

    Or use screen to run the import.
    Planning to continue using VB 3.8 post EOL? Then join the VB 3.8 Forever group and vB3Forever.org!

    Comment

    • Gary Fischman
      Senior Member
      • Jan 2001
      • 356
      • 3.0.10+

      #3
      There is no firewall between me and the server.
      Never mind - I'll just go to the monitor connected directly to the server and do it.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...