Difference between revisions of "MySQL"
Jump to navigation
Jump to search
Rafahsolis (talk | contribs) |
Rafahsolis (talk | contribs) |
||
| Line 28: | Line 28: | ||
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 | ||
Revision as of 10:03, 1 October 2015
SQL
List databases
SHOW databases;
Open db
USE dbname;
or
CONNECT dbname;
List tables
SHOW TABLES;
Show table fields
SHOW COLUMNS FROM City;
DESCRIBE City;
add .sql to MySQL database
TODO: REVISAR backup:
mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
backup .sql.gz
mysql -uroot -ppassword mydb > myfile.sql.gz
restore:
mysql -u root -p[root_password] [database_name] < dumpfilename.sql
restore .sql.gz
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