PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/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/5.7/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/5.7/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, need not be loaded explicitly, and cannot be disabled by unloading it. The client-side ...
https://dev.mysql.com/doc/refman/5.7/en/old-native-pluggable-authentication.html
Installing Old Native Pluggable Authentication The mysql_old_password plugin exists in server and client forms: The server-side plugin is built into the server, need not be loaded explicitly, and cannot be disabled by unloading it. The client-side ... MySQL includes two plugins that implement native authentication; that is, authentication based on the password hashing methods in use from before the introduction of pluggable ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
If one subquery is nested within another and both are merged into a semijoin of an outer query, any specification of semijoin strategies for the innermost query are ignored. Examples: SELECT id, a IN (SELECT /*+ SUBQUERY(MATERIALIZATION) */ a FROM ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 8.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/optimizing-innodb-transaction-management.html
Where practical, wrap several related data change operations into a single transaction, by issuing SET AUTOCOMMIT=0 or a START TRANSACTION statement, followed by a COMMIT statement after making all the changes. Consider issuing COMMIT statements ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
MyISAM supports concurrent inserts: If a table has no free blocks in the middle of the data file, you can INSERT new rows into it at the same time that other threads are reading from the table. It is normally not useful to split a table into ...