PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table tablespaces. There are many reasons why you ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-importing-data.html
It is common when setting up a new instance of NDB Cluster to need to import data from an existing NDB Cluster, instance of MySQL, or other source. This can be imported using the mysql client, as shown later in this section. Such files can be ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-import.html
ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB API. ndb_import requires a connection to an NDB management server (ndb_mgmd) to function; it does not require a connection to a MySQL ...The name of the file must match that of the table; the file's extension, if any, is not taken into ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
The mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Most options to mysqlimport correspond directly to clauses of LOAD DATA syntax. Invoke mysqlimport like this: mysqlimport [options] db_name textfile1 ...For ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
Important This parameter is deprecated as of NDB 7.5.0, and is subject to removal in a future release. It is important to configure the cluster in such a manner that nodes in the same node groups are not placed on the same computer because a single ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
For the MySQL Enterprise Backup product, the file name of the binary log and the current position within the file are important details. This distinction is important mainly in MySQL 5.1, where a feature or bug fix might apply to the InnoDB Plugin ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
All three formats can be used in the same XML file; the import routine automatically detects the format for each row and interprets it correctly. If the file cannot be found, the following error results: ERROR 2 (HY000): File '/person.xml' not found ...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/5.7/en/alter-table.html
Important MySQL silently ignores inline REFERENCES specifications, where the references are defined as part of the column specification. Discarding and Importing InnoDB Tablespaces An InnoDB table created in its own file-per-table tablespace can be ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-bulk-data-loading.html
When importing data into InnoDB, turn off autocommit mode, because it performs a log flush to disk for every insert. To disable autocommit during your import operation, surround it with SET autocommit and COMMIT statements: SET autocommit=0; ...
https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature.html
After you have downloaded and imported the public build key, download your desired MySQL package and the corresponding signature, which also is available from the download page. Another method of verifying the integrity and authenticity of a ...