Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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-cluster-manager/8.4/en/mcm-create-cluster.html
See also Section 4.5, “Importing MySQL NDB Clusters into MySQL Cluster Manager”. Caution While it is possible to import into a cluster that was created without this option, it is not advisable, since the cluster is not protected against ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-results.html
Export or Import data directly from or into the result set. Figure 6.23 Exporting a Result Set Import into a Result Set Records from a CSV file can be imported into the result set of the visual SQL editor. The export and import operations shown in ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-steps.html
Only one schema: Catalog.Schema.Table -> Catalog.Table: Merges each schema into a single database. Figure 10.8 MySQL Workbench migration: Source Objects Migration The migration process now converts the selected objects into MySQL compatible objects ... This example migrates a Microsoft SQL Server database to MySQL and includes an image for each ...