2,306
edits
Changes
Jump to navigation
Jump to search
Line 28:
Line 28: + + + + +
no edit summary
restore .sql.gz
restore .sql.gz
zcat /path/to/file.sql.gz | mysql -u 'root' -p 'password' your_database
zcat /path/to/file.sql.gz | mysql -u 'root' -p 'password' your_database
=== Save SELECT to file ===
SELECT hostname FROM VTS_sistema WHERE INTO LOCAL OUTFILE '/tmp/hostnames_VTS_sistema' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
mysql -h20.1.40.66 -u xe50582 -p -D workflow -e "SELECT hostname FROM controles_sistemas WHERE cod_plataforma='UNX'" > hostnames_unix_workflow.txt