/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

6 votes193 views1 answer
Allsource oracle
SQL
0 vote194 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote226 views1 answer
Trigger stock phpmyadmin
SQL
1 vote182 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
1 vote196 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote198 views3 answers
Insert query in ci
SQL
0 vote182 views1 answer
Copying query result to excel
SQL
2 votes185 views1 answer
Get hour from date sql
SQL
10 votes165 views2 answers
Sql merge statement
SQL
0 vote197 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL

Share