Search Results
https://dev.mysql.com/doc/refman/9.7/en/table.html
With INTO to populate user variables, and with INTO OUTFILE or INTO DUMPFILE to write table data to a file. TABLE can also be used in many cases in place of the SELECT in CREATE TABLE ... TABLE is a DML statement which returns rows and columns of ...
https://dev.mysql.com/doc/refman/9.7/en/windows-and-ssh.html
This userid value might not be the same as the user name of your MySQL account. Log in to your server with the SSH session you just created. Create a new file in Windows and link to MySQL using the ODBC driver the same way you normally do, except ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-capacity-options.html
Note that backups created with the --skip-unused-pages option cannot be restored using copy-back-and-apply-log. Note If a user runs a FLUSH LOGS statement while backup is in progress for a replica, the backup process will fail. Warning This option ... These options limit the resources used by the backup process, in order to minimize backup overhead for busy or huge databases, or specify behaviors of the process when encountering resource ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/customize-your-cluster.html
The default values are recommended for most deployments, but advanced users can override the defaults by passing the following options to the dba.createCluster() and Cluster.addInstance() commands: Pass the groupName option to the ... When you ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-batch-code-execution.html
Executable Scripts On Linux you can create executable scripts that run with MySQL Shell by including a #! line as the first line of the script. If you need to create a MySQL Shell script that is independent of the protocol used for connecting to the ... As well as interactive code execution, MySQL Shell provides batch code execution from: A file loaded for ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-encrypted-connections.html
For example: mysql-js> var session=mysqlx.getSession({host: 'localhost', user: 'root', password: 'password', ssl_ca: "path_to_ca_file", ssl_cert: "path_to_cert_file", ssl_key: "path_to_key_file"}); Sessions created using mysqlx.getSession(), ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-debug-diagnostics.html
If you omit it, the utility creates a file named Temp.zip in the named path. For example: {"customShell": ["command1", "command2", "command3"]} Important These commands run with the privileges of the user running MySQL Shell and should be used with ... The debugging and diagnostics utility util.debug.collectDiagnostics() enables you to collect diagnostic data on your MySQL ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-load-binlogs.html
If the location specified exists and contains a dump created by this utility, the snapshot information in that dump is used as the starting point for the binary log dump. Requirements and Restrictions The following must be true: The directory must ...This utility enables you to load a binary log dump from local or cloud ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/specifying-instances.html
For example, to connect as the user myuser to the MySQL server instance at www.example.com, on port 3306 use the connection string: myuser@www.example.com:3306 To use this connection string with an AdminAPI operation such as dba.configureInstance(), ... MySQL Shell enables you to work with various APIs, and supports specifying connections as explained in Connecting to the Server Using URI-Like Strings or Key-Value ...
https://dev.mysql.com/doc/ndb-operator/9.7/en/deployment-configuration.html
Whenever a user creates, modifies, or deletes a Kubernetes object of type NdbCluster, NDB Operator receives a change event, and updates the NDB Cluster running in Kubernetes Cluster accordingly. Since this is greater than 1, the NDB Cluster is ...