Search Results
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
At the initial start up of the server, the following happens, given that the data directory of the server is empty: The server is initialized. The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-yum-repo.html
At the initial start up of the server, the following happens, given that the data directory of the server is empty: The server is initialized. Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
For example, you can use IGNORE 1 LINES to skip an initial header line containing column names: LOAD DATA INFILE '/tmp/test.txt' INTO TABLE test IGNORE 1 LINES; When you use SELECT ... For example, many programs can export data in comma-separated ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-storage-requirements.html
Important Starting the cluster with the --initial option does not remove Disk Data files. You must remove these manually prior to performing an initial restart of the cluster. The following items apply to Disk Data storage requirements: ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-rpm.html
After installing from RPM, you still need to configure the cluster; see Section 25.3.3, “Initial Configuration of NDB Cluster”, for the relevant information. See Section 25.3.3, “Initial Configuration of NDB Cluster”, for information about ... This section covers the steps necessary to install the correct executables for each type of NDB Cluster node using RPM packages supplied by ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-startup-messages.html
Possible startup messages with descriptions are provided in the following list: Initial start, waiting for %s to connect, nodes [ all: %s connected: %s no-wait: %s ] Waiting until nodes: %s connects, nodes [ all: %s connected: %s no-wait: %s ] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mgm-client-commands.html
TRUNCATE TABLE does not work for this purpose because this removes only the table data; the data nodes continue to store an NDBCLUSTER table's definition until a DROP TABLE statement is issued that causes the table metadata to be dropped. Using the ... In addition to the central configuration file, a cluster may also be controlled through a command-line interface available through the management client ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-basics.html
Important All management servers must be restarted with the --reload or --initial option to force the reading of the new configuration. It is not necessary (or usually even desirable) to use --initial when restarting the existing data nodes. In ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
The --ndbcluster option is ignored (and the NDB storage engine is not enabled) if --initialize is also used. (It is neither necessary nor desirable to use this option together with --initialize.) --ndb-allow-copying-alter-table=[ON|OFF] Command-Line ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...