Search Results
https://dev.mysql.com/doc/internals/en/capability-flags.html
The capability flags are used by the client and server to indicate which features they support and want to use. Value 0x00000080 Server Enables the LOCAL INFILE request of LOAD DATA|XML. See mysql_real_connect() CLIENT_TRANSACTIONS Value 0x00002000 ...CLIENT_IGNORE_SIGPIPE Value 0x00001000 Client Do not issue SIGPIPE if network failures occur (libmysqlclient ...
https://dev.mysql.com/doc/refman/8.4/en/charset-applications.html
For a script that executes in a Web environment, the script must handle character encoding properly for its interaction with the MySQL server, and it must generate pages that correctly indicate the encoding so that browsers know how to display the ...For the per-database or server-startup techniques, the settings control the character set for data ... For applications that store data using the default ...If applications ...
https://dev.mysql.com/doc/refman/8.4/en/windows-installation.html
Note MySQL 8.4 Server requires the Microsoft Visual C++ 2019 Redistributable Package to run on Windows platforms. Recommended MSI Installation Method The simplest and recommended method is to download the MSI and let it install MySQL Server, and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options.html
Note The presence of the server_uuid system variable does not change the requirement for setting a unique server_id value for each MySQL server as part of preparing and running MySQL replication, as described earlier in this section. The following ...Command-Line Format --server-id=# System Variable server_id Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 1 Minimum Value 0 Maximum Value 4294967295 This variable specifies the server ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.restore.html
To restore a MySQL instance from a backup to a database server: Shut down the database server. 240426 13:17:07 MAIN INFO: Backup Image MEB version string: 8.4.0 240426 13:17:07 MAIN INFO: MySQL server version is '8.4.0' 240426 13:17:07 MAIN INFO: ...Use, for example, the copy-back-and-apply-log command, which converts the raw backup into a prepared backup by updating it to a consistent state, and then copies the tables, indexes, metadata, and any other required files onto a target ...
https://dev.mysql.com/doc/workbench/en/wb-manage-server-connections.html
The Manage Server Connections dialog is another way to manage MySQL connections. After the MySQL connection manager is launched, you are presented with the Connection tab of the Manage Server Connections dialog. Figure 5.13 Manage Server ...This ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-copying-to-other-server.html
On Server 1: $> mysqldump --databases db1 > dump.sql Copy the dump file from Server 1 to Server 2. On Server 2: $> mysql < dump.sql Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE ...Then ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-versioning.html
cloud: Suffix indicating this version of MySQL Server was built for the cloud only. Server Versioning 3.1.2.1.1 Server Versioning The MySQL Server included in MySQL HeatWave on AWS uses a versioning system consisting of three numbers, an update ...
https://dev.mysql.com/doc/refman/8.4/en/windows-troubleshooting.html
When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. The MySQL server uses the error log to record information relevant to the error that prevents the server from ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-instance-server-logs.html
The Administration - Server Logs tab displays log information for the MySQL server represented by each connection tab. For more information, see The Slow Query Log Figure 6.3 Navigator Management: Instance: Server Logs: Slow Log . For each ...Error ...