/SQL/Mysql import gzip db

Mysql import gzip db

Mysql import gz

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

3

Source: serverfault.com

Mysql import gzip db

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

2

Similar codes

1 vote124 views1 answer
How to put value in variable mysql
SQL
0 vote134 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote128 views1 answer
Remove mysql from centos 7
SQL
0 vote118 views1 answer
Add colum date in sql
SQL
23 votes115 views6 answers
How to create table in sql
SQL
12 votes109 views4 answers
SQL Where
SQL
1 vote121 views1 answer
Oracle sql average
SQL
0 vote126 views1 answer
Install postgresql 12 on debian 10
SQL
33 votes116 views6 answers
Change column name in mysql
SQL
2 votes115 views1 answer
Sqlite insert if not exists
SQL

Share