/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

0 vote212 views1 answer
Load utilities in sql server
SQL
0 vote180 views2 answers
Mysql set foreign_key_checks=0
SQL
1 vote208 views1 answer
Add multiple row table pl sql
SQL
2 votes182 views1 answer
Mysql find tables with name
SQL
13 votes185 views2 answers
Display users in mysql
SQL
0 vote212 views1 answer
Drop table BigQuery table columns
SQL
2 votes193 views1 answer
Sql find missing values between two tables
SQL
3 votes175 views1 answer
Postgresql if null then 0
SQL
2 votes302 views2 answers
How to DROP a table in mysql
SQL
4 votes198 views2 answers
How to insert ip address in mysql using php
SQL

Share