/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

13 votes270 views2 answers
Oracle all source
SQL
5 votes322 views1 answer
Sql check if date is between 2 dates
SQL
0 vote284 views1 answer
How to see the content of tables in pgadmin
SQL
3 votes347 views1 answer
Postgresql if null then 0
SQL
4 votes319 views3 answers
Mysql update with join
SQL
1 vote306 views1 answer
How to select random rows from table
SQL
0 vote341 views3 answers
How to increase size of column in sql
SQL
16 votes333 views2 answers
Add column if not exists mysql
SQL
0 vote314 views1 answer
Cara menampilkan user di mysql terminal
SQL
11 votes317 views2 answers
Oracle all source
SQL

Share