/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 vote218 views3 answers
Between keyword sql
SQL
1 vote246 views1 answer
Update from select oracle
SQL
9 votes240 views4 answers
How to alter table column name in mysql
SQL
0 vote256 views1 answer
Postgresql like
SQL
0 vote219 views2 answers
How to find max and min salary in sql
SQL
0 vote243 views1 answer
Search from comma separated values in sql server
SQL
0 vote183 views1 answer
Now() -1 mysql
SQL
0 vote225 views1 answer
Components/Fields of Internal Table
SQL
0 vote214 views1 answer
Get duplicate entry sql
SQL
0 vote221 views1 answer
Luu ckeditor vao mysql
SQL

Share