Stack Overflow
Stack Overflow

Questions tagged [mysql-shell]

This tag should be used for questions related with the MySQL Shell.

MySQL Shell is an advanced client and code editor for MySQL.

References:

https://dev.mysql.com/doc/mysql-shell/8.0/en/

22 questions
8
votes
2 answers

How to change MySQL JS> to only MYSQL?

I did custom installation for MYSQL and only included MySQL shell, server, and python connector but I don't know from where Java script came from and because of that I can't connect python and Mysql. Please help
Harsh Srivastava
  • 85
  • 1
  • 1
  • 7
1
vote
2 answers

mysqlsh to dump and load full schema

I want to use mysqlsh to do the following: Dump the FULL schema of a given database (not just tables, but functions, triggers, everything related to this database schema, same as mysqldump -R DATABASE > DATABASE.sql) Load this full schema into a…
Tony B
  • 915
  • 1
  • 9
  • 24
1
vote
0 answers

How to execute mysql shell code from python .py file?

I have found this sample for uploading csv file to mysql server which is faster --> MySQL localhost osm JS > util.importTable("/usr/local/mysql/mysql-files/load_data.csv", {schema: "parallel", table: "parallel_load",…
Harold James
  • 37
  • 5
1
vote
2 answers

Load mysqlsh module in python

I am writing the code in python to automate the innodb cluster provisioning. Based on this example https://dev.mysql.com/doc/dev/mysqlsh-api-python/8.0/group__mysql.html mysql-py> from mysqlsh import mysql // Then you can use the module functions…
developthou
  • 343
  • 1
  • 10
1
vote
1 answer

Cannot set LC_ALL to locale en_US.UTF-8: JavaScript is not supported

I'm running mysql v8.0.23 in my local machine. $ sudo apt-get install mysql-server $ sudo snap install mysql-shell But when I try to enter mysqlsh enter into js mode, It is giving the following error: $ mysqlsh --js Cannot set LC_ALL to locale…
heheh
  • 194
  • 6
1
vote
1 answer

Setting up InnoDB Cluster - Error on opening connection

I am in the process of setting up an InnoDB cluster using the following tutorial (https://www.sqlshack.com/deploy-mysql-innodb-clusters-for-high-availability/). So far everything has worked: MySQL Server…
Andre
  • 131
  • 1
  • 14
1
vote
0 answers

MySQL SQL> ERROR: Not connected. Problem with creating a MySQL user

I asked this question here an hour ago. I got a message that my question is closed, because it already has an answer here: Create new user in MySQL and give it full access to one database. However, I think this is a mistake because I didn't find…
Phil
  • 23
  • 6
0
votes
0 answers

MySQL shell for VS Code rootCA.crt certificate error

I installed mysql on my Pop OS machine and since I prefer every thing to be in visual studio code I installed mySQL shell extension for VSCode but I get this error when I open it. it says Failed to connect please check if rootCA.crt certificate is…
Ammar
  • 1
  • 1
0
votes
0 answers

is there any way to give --quick option while using mysqlsh util.loadDump()?

is there any way to give --quick option to avoid the problem? [problem] oom killer activates while loading large tables using 'mysqlsh util.loadDump()'. On mysqldump, using quick option let's you write data into instance without buffering, avoid…
matty21031
  • 1
0
votes
0 answers

Using MySQL Shell to dump db into s3 bucket giving XML error when JSON is returned

I am trying to use Mysql Shell to do an instance dump and write the resulting data to an s3 bucket. However, the shell reports an error when it connects to s3, stating it cannot parse the returned XML: Failed to parse XML response:…
Jerry
  • 3,391
  • 1
  • 19
  • 28
0
votes
1 answer

Can I change the name of the mysql shell?

This isn't exactly an issue, but more of a check to make sure I'm not making a mistake. I recently started with mysql, and I couldn't access the shell. I looked through my path variables and found out mysql shell is actually called mysqlsh. i made a…
ori raisfeld
  • 41
  • 5
0
votes
0 answers

Mysql mysqlsh parallel import data load from csv

mysqlsh --version mysqlsh Ver 8.0.32 for macos13 on x86_64 - for MySQL 8.0.32 (MySQL Community Server (GPL)) This is working from mysql and records get loaded in table datafile test_sanjay.csv is like this 0,0,0,"run_intf_filter is handling Data…
Sanjay
  • 63
  • 7
0
votes
0 answers

how can i export database with shell without this error "couldn't find table "

I want to export database using shell in XAMPP firstly I write cd: \XAMPP\MYSQL\bin after this command done , I use this command "MYSQLDUMP -u root -p HR > HR.MYSQL" for exporting database HR output database is exported but without any tables what…
Eslam Gaber
  • 1
0
votes
1 answer

mysql ERROR: Util.checkForServerUpgrade: Can't connect to local MySQL server through socket

I run on my server mysql in version 5.7.40 mysql --version mysql Ver 14.14 Distrib 5.7.40, for Linux (x86_64) using EditLine wrapper And generally it works without any issues. I want to upgrade from 5.7.40 to 8.. and because of it I want to use…
Przemek
  • 647
  • 2
  • 8
  • 25
0
votes
0 answers

Run mysqlsh commands in Ansible playbook

I would like to create a mysql innodb cluster. SO I want to run the mysql shell commands in ansible playbook. But getting memory error. Below are the code and error- tasks: - name: get cluster status from dbboxes shell: mysqlsh…
Dumb
  • 83
  • 1
  • 10
1
2