1
Make the gp mysql command behave more like the mysql command and actually execute commands or scripts
- Open
- Subscribe
|
D |
Dave Hilditch |
I would like to be able to run commands like this:
mysql -u username -p -D database_name -e "SELECT * FROM wp_spro_slow_query_log" -B > /tmp/slow_query_log_output.tsv
But I don't want to have to remember the username, password and db name so ideally I could do:
gp mysql -login {site.url} -e "SELECT * FROM wp_spro_slow_query_log" -B > /tmp/slow_query_log_output.tsv
or maybe:
gp mysql -execute {site.url} "SELECT * FROM wp_spro_slow_query_log" > /tmp/slow_query_log_output.tsv