/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

3 votes306 views1 answer
Difference sql vs mysql
SQL
9 votes332 views2 answers
Cmd to rename a collumn name in sql
SQL
2 votes286 views1 answer
Sql select in list
SQL
0 vote297 views1 answer
How to check replication lag in mySQL
SQL
0 vote343 views1 answer
Calculate age in sql
SQL
0 vote335 views1 answer
Create function in microsoft sql server
SQL
-1 vote379 views4 answers
Full outer join in sql
SQL
23 votes322 views4 answers
How to uninstall postgresql in ubuntu
SQL
3 votes329 views1 answer
Stpop start psql server
SQL
0 vote368 views1 answer
Sql statement show all emails with dome
SQL

Share