MySQL

MySQL

Connecting to MySQL server in bash

 # Connect to mysql server
 mysql -u<username> -p -h <ip> --ssl-ca=server-ca.pem --ssl-cert=client-cert.pem --ssl-key=client-key.pem

MySQL commands

 show databases;      # show the databases
 use userdata_schema; # connect to a particular database
 show tables;         # list the tables within the database
 select * from table_name limit 10; # to see what's in a table (first ten entries)
 select * from user_location where user_id='6346669087044735461' order by sample_time desc limit 10;

Copy remote table to local file

 mysql -u<username> -p -h <ip> --ssl-ca=server-ca.pem \
                               --ssl-cert=client-cert.pem \
                               --ssl-key=client-key.pem \
                               userdata_schema \
                               -e "select * from user_location" > <export-file>.csv