Skip to main content

Get a progress indicator when importing mysqlMySQL databases

Source Link
user
  • 1.1k
  • 7
  • 27
  • 39

Get a progress indicator when importing mysql databases

I often import MySQL databases, and this can take a while. There is no progress indicator whatsoever. Can one be shown, somehow? Either records imported, MB imported, or tables imported... anything is better than just waiting. Anybody any idea?

I use this command:

mysql -uuser -p -hhost database < largefile.sql

Files are between 40-300 MB, and the host is within the local network.