/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

4 votes161 views1 answer
SQL find text in SP
SQL
0 vote162 views1 answer
Sql server beginning of month
SQL
16 votes159 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote121 views1 answer
Oracle sysdba connect as another user
SQL
28 votes147 views4 answers
Show tables mysql
SQL
1 vote146 views1 answer
Mysql current time
SQL
0 vote111 views2 answers
Spring properties file for db
SQL
0 vote154 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote158 views1 answer
Mysql url data type
SQL
21 votes169 views3 answers
Sql server search column name in all tables
SQL

Share