Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-backups.html
The backup files can be copied into any directory on the computer where the replica's management host resides, as long as the MySQL and NDB binaries have read permissions in that directory. In this case, we assume that these files have been copied ... This section discusses making backups and restoring from them using NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
INTO OUTFILE to write the files, so you must have the FILE privilege to perform this operation, and an error occurs if a given .txt file already exists. INTO OUTFILE.) To enable data files to be written using a different format, mysqldump supports ... This section describes how to use mysqldump to create delimited-text dump ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-sql-format.html
This ensures that when the dump file is reloaded, it creates each database if it does not exist and makes it the default database so database contents are loaded into the same database from which they came. For reloading, you can specify a database ... This section describes how to use mysqldump to create SQL-format dump ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-upgrade-testing.html
Then you can dump the database and database object definitions from the production server and load them into the new server to verify that they are handled properly. After you have verified that the definitions are handled properly, dump the data ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
Invoke mysqlimport like this: mysqlimport [options] db_name textfile1 [textfile2 ...] For each text file named on the command line, mysqlimport strips any extension from the file name and uses the result to determine the name of the table into which ... The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
Installing Native Pluggable Authentication The mysql_native_password plugin exists in server and client forms: The server-side plugin is built into the server, but is disabled by default. The client-side plugin is built into the libmysqlclient ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-storage-layout.html
This operation can be slow if the table is large or if the indexes being rebuilt do not fit into the buffer pool. Less disk I/O is required to bring data into the buffer pool, or to perform full table scans. Once your data reaches a stable size, or ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-spatial-analysis.html
For a horizontal or a vertical linestring, the MBR is a rectangle degenerated into the linestring. For a point, the MBR is a rectangle degenerated into the point. For MyISAM and InnoDB tables, search operations in columns containing spatial data ...
https://dev.mysql.com/doc/refman/8.4/en/outer-join-simplification.html
When the optimizer evaluates plans for outer join operations, it takes into consideration only plans where, for each such operation, the outer tables are accessed before the inner tables. Table expressions in the FROM clause of a query are ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...