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?
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?
Comment