Questions tagged [mysql-shell]

Questions about the new-ish MySQL command line client and query editor. Also include the generic "mysql" tag and the version-specific tag. Not to be used for question about the old-style `mysql` CLI. More info [here](https://dev.mysql.com/doc/mysql-shell/8.0/en/mysqlsh.html).

Filter by
Sorted by
Tagged with
1
vote
0answers
6 views

Inndob Cluster - Automatically collect the output from mysqlsh?

Is there a way to take the output from mysqlshell and use it in a script or similar. I have set up a basic cluster for testing (3 x MySQL 8.0.27 databases, running on Debian 11). I am now trying to ...
0
votes
0answers
11 views

innodb cluster - accessing mysqlshell commands via a script

with mysqlshell and innodb cluster, is there a way of accessing the cluster.status() information without needing to log into mysqlshell first, as some of this information could be useful to access via ...
0
votes
1answer
39 views

How to start mysql-shell in mysql-js JavaScript mode?

How can I change the mysqlsh shell to mysql-js JavaScript mode? Somehow initially I'm in mysql-py, and I cannot switch to \js, only to \sql. Why? $ mysqlsh root@localhost:33060 Cannot set LC_ALL to ...
0
votes
1answer
94 views

How can the (JSON) formatted results from MySQL Shell be saved to a file?

Somewhat uniquely among official MySQL applications, MySQL Shell offers (easy) JSON output. From the MySQL shell prompt, typing the following will get you results as a JavaScript array of objects (one ...
0
votes
0answers
30 views

How can the default options (such as socket path) for MySQL Shell be set?

When I try to connect to my local server using MySQL Shell (rather than the old mysql command line client), it fails with the error: $ mysqlsh -u root ... MySQL Error 2002 (HY000): Can't connect to ...
0
votes
1answer
29 views

MySQL Shell dump utility - maximum possible chunk size?

The documentation https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-dump-instance-schema.html mentions that the min chunk size is 128kB. What is the maximum possible chunk size?
3
votes
1answer
2k views

Install mysql-shell from apt repository

I want to install and configure a high availability cluster for Mysql 8. To automate that, I want to use use apt repository (via ansible). My servers are debian jessy (8) distribution. I succesfully ...