Türker Yıldırım

Import a large SQL file into MySQL from the command line

Snippet
mysql -u root -p --default-character-set=utf8 shop < dump.sql

# same import, with a progress bar, which on a 4 GB dump is worth having
pv dump.sql | mysql -u root -p --default-character-set=utf8 shop