Pipe viewer import mysql database
$ pv /path/to/sqlfile.sql | mysql -uUSERNAME -pPASSWORD -D DATABASE_NAME
This display progress bar and remaining time during the import database process.
Written by Jose Ruzafa
Related protips
1 Response
i like it. How to redirect the output to a file?
pv /path/to/sqlfile.sql | mysql -uUSERNAME -pPASSWORD -D DATABASENAME > log.txt 2> errorlog.txt
not work.
over 1 year ago
·
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Shell
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#