This tag should be used for questions related with the MySQL Shell.
MySQL Shell is an advanced client and code editor for MySQL.
References:
Questions tagged [mysql-shell]
22 questions
0
votes
1 answer
Why does mysql shell not load any data when I use util.load_dump()?
I am using MySQL shell utilities 8.0.23 for both dump and load and the process goes as follows:
On one host:
I use util.dump_Instance() to create a dump of a mysql 8.0.23 instance with multiple schemas.
On another host:
I download partial files from…
Jules
- 41
- 1
- 1
- 4
0
votes
1 answer
Unable to run example mysqlsh report from 8.0 reference manual
https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-reporting-create-example.html
MySQL [127.0.0.1 ssl] JS> \show
Available reports: query, sessions, thread, threads.
MySQL [127.0.0.1 ssl] JS>
MySQL [127.0.0.1 ssl] JS> \show…
sksaha_DBA
- 21
- 1
- 6
0
votes
0 answers
How to continue a .sql database import in MySQL after the server has gone away
This is how the error happened - I was using MySQL shell to import a 16G .sql file that contains multiple tables using the source command and optimizations (as the first solution in this question, with maximum values indicated in MySQL…
lyra
- 1
- 1
0
votes
0 answers
Update ipAllowList in mysql shell
I haven't found the way to update ipAllowlist in innodbcluster using mysql shell. Is there a way to do this?
developthou
- 343
- 1
- 10
0
votes
0 answers
difference in query execution/loading between mysql and mysqlsh/mysqlshell
I am executing a query remotely using mysql utility and also through mysqlsh utility. I see that with mysql, entire dataset is loaded in memory at once, whereas in case of mysqlsh, it appears to be fetching a single row or a subset of rows at a…
user2599052
- 1,056
- 3
- 12
- 27
0
votes
1 answer
info about MySQL Shell
I'm using the MySQL shell for the first time.
I ran the following commands:
\connect --mysql root@localhost:3306
\use myschema
But, when I try to follow this instruction:
myColl = db.createCollection('my_coll')
I get the error:
…
Alessio Frabotta
- 117
- 11
-2
votes
1 answer
I am using Postgresql shell (this file and directory is not found)
I get this:
You are now connected to database "test" as user "postgres".
test=# \i C:/Users/ANUJ MISHRA/Downloads/human.sql
C:/Users/ANUJ: No such file or directory
