/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 votes381 views4 answers
What is sql
SQL
2 votes313 views1 answer
Oracle sql drop column if exists
SQL
0 vote386 views1 answer
How to print sql query
SQL
13 votes381 views4 answers
Mysql remove foreign key constraint
SQL
5 votes376 views1 answer
Purge undo tablespace usage
SQL
4 votes340 views1 answer
Create table if not exist in sqlite
SQL
1 vote357 views2 answers
Postgresql get difference in hours between two dates
SQL
1 vote387 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote337 views2 answers
How to list all values of a column that start with a letter in sql
SQL
10 votes344 views1 answer
Query to find object dependencies in oracle
SQL

Share