Search Results
https://dev.mysql.com/doc/refman/9.7/en/reloading-delimited-text-dumps.html
To reload a table, first change location into the output directory. For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file ...
https://dev.mysql.com/doc/refman/9.7/en/replication-bugs.html
If you have a repeatable test case that demonstrates the bug, please enter it into our bugs database using the instructions given in Section 1.6, “How to Report Bugs or Problems”. In this case, the replication thread stops and waits for you to ... When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug ...
https://dev.mysql.com/doc/refman/9.7/en/security-against-attack.html
INTO OUTFILE do not overwrite existing files and are writable by everyone. With this privilege, you can read any file into a database table. This could be abused, for example, by using LOAD DATA to load /etc/passwd into a table, which then can be ...
https://dev.mysql.com/doc/refman/9.7/en/stored-program-variables.html
Results from queries can be retrieved into local variables using SELECT ... INTO var_list or by opening a cursor and using FETCH ... System variables and user-defined variables can be used in stored programs, just as they can be used outside ...
https://dev.mysql.com/doc/refman/9.7/en/subquery-optimization-with-exists.html
This is done by pushing down an appropriate equality into the subquery's WHERE clause to make it more restrictive. To solve the dilemma of whether or not to push down conditions into the subquery, the conditions are wrapped within “trigger” ...
https://dev.mysql.com/doc/refman/9.7/en/what-is-mysql.html
The database structures are organized into physical files optimized for speed. Depending on your programming environment, you might enter SQL directly (for example, to generate reports), embed SQL statements into code written in another language, or ... MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-commands-single-file.html
The resulting file or directory goes into the current directory, or into the backup directory, if specified with --backup-dir; in either case, the destination directory must be empty. The --dst-entry=path option, along with --src-entry=path option, ... Besides the commands for creating and restoring single-file backups (namely, backup-to-image and copy-back-and-apply-log), mysqlbackup provides a number of other commands for you to work with single-file ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-remove.html
clusterSet.removeCluster() has the following syntax: clusterSet.removeCluster(clusterName[, options]) Clusters can be removed from a ClusterSet by removing the Cluster, but leaving it intact, or by removing the Cluster and dissolving it into its ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-requirements.html
The basis of an InnoDB ClusterSet deployment is an existing InnoDB Cluster at MySQL 8.0.27 or higher, and a number of standalone MySQL Server instances that can be formed into replica clusters to provide disaster tolerance for this primary cluster.
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-explanations-ml-explain-row.html
The following example enters a row of data to explain into a session variable. mysql> SET @variable = (JSON_OBJECT("column_name", value, "column_name", value, ...), model_handle, options); In the following example, assign the data to analyze into ...