/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

1 vote152 views1 answer
Jq unencode string
Shell/Bash
0 vote130 views2 answers
How to see deleted commit in git
Shell/Bash
0 vote154 views1 answer
Batch rename folders & trim spaces & add prefix / suffix
Shell/Bash
39 votes141 views6 answers
Install brew mac
Shell/Bash
0 vote164 views1 answer
Git overwrite remote files
Shell/Bash
0 vote140 views1 answer
Kali linux connect to wifi from terminal
Shell/Bash
0 vote201 views1 answer
Failed to start firewalld - dynamic firewall daemon.
Shell/Bash
0 vote133 views1 answer
Git the .git folder (to manage your local repo cloned many remote repos)
Shell/Bash
4 votes139 views1 answer
Brew install wine
Shell/Bash
0 vote146 views1 answer
Install latest golang on ubuntu
Shell/Bash

Share