Changes

== SQL ==

==SQL==

=== List databases ===

===List databases===

  SHOW databases;

  SHOW databases;

=== Open db ===

===Open db===

  USE dbname;

  USE dbname;

or

or

  CONNECT dbname;

  CONNECT dbname;

=== List tables ===

===List tables===

  SHOW TABLES;

  SHOW TABLES;

=== Show table fields ===

===Show table fields===

  SHOW COLUMNS FROM City;

  SHOW COLUMNS FROM City;

  DESCRIBE City;

  DESCRIBE City;

=== add .sql to MySQL database ===

===add .sql to MySQL database===

TODO: REVISAR

TODO: REVISAR

backup:   

backup:   

  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 ===

===Save SELECT to file===

  SELECT hostname FROM VTS_sistema WHERE INTO LOCAL OUTFILE '/tmp/hostnames_VTS_sistema' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';

  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

  mysql -h20.1.40.66 -u xe50582 -p -D workflow -e "SELECT hostname FROM controles_sistemas WHERE cod_plataforma='UNX'" > hostnames_unix_workflow.txt

=== Change DB password ===

===Change DB password===

SET PASSWORD [FOR user] = password_option

SET PASSWORD [FOR user] = password_option

  SET PASSWORD FOR 'jeffrey'@'localhost' = password_option;

  SET PASSWORD FOR 'jeffrey'@'localhost' = password_option;