/Shell/Bash/Import mysql gz

Import mysql gz

Mysql import gz

zcat /path/to/file.sql.gz | mysql -u 'root' -p your_database

3

Source: serverfault.com

Import mysql gz

gunzip < myfile.sql.gz | mysql -u root -p mydb

0

Source: serverfault.com

Similar codes

0 vote369 views1 answer
Resume screen linux
Shell/Bash
0 vote352 views1 answer
Bash float operations
Shell/Bash
2 votes335 views1 answer
Get jq command
Shell/Bash
16 votes349 views2 answers
Got error: 1698: Access denied for user 'root'@'localhost' when trying to connect
Shell/Bash
0 vote330 views1 answer
Delete pid port
Shell/Bash
0 vote368 views1 answer
Xargs use arg multiple times
Shell/Bash
0 vote347 views1 answer
Ubuntu time tracker
Shell/Bash
0 vote326 views1 answer
Cpanel /home/cPanelInstall
Shell/Bash
2 votes335 views1 answer
Ubuntu startup script
Shell/Bash
2 votes322 views1 answer
Bash new folder
Shell/Bash

Share