Database Administrators Stack Exchange
Database Administrators Stack Exchange

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).

6 questions
3
votes
1 answer

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 installed mysql server with commands : > sudo…
gentiane
  • 141
  • 6
1
vote
1 answer

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 find a way to capture the output from mysqlshell's…
IGGt
  • 1,855
  • 3
  • 21
  • 39
1
vote
1 answer

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 locale en_US.UTF-8: No such file or…
membersound
  • 277
  • 1
  • 2
  • 10
0
votes
1 answer

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 for each row): \option resultFormat…
outis
  • 307
  • 2
  • 12
0
votes
0 answers

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 local MySQL server through socket…
outis
  • 307
  • 2
  • 12
0
votes
1 answer

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?
Mihir Rane
  • 3
  • 2