Search Results
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
Permissible locale values are the same as the legal values for the lc_time_names system variable (see Section 12.16, “MySQL Server Locale Support”). To use this function, the file must be located on the server host, you must specify the full ...
https://dev.mysql.com/doc/refman/8.4/en/timezone-problems.html
If you have a problem with SELECT NOW() returning values in UTC and not your local time, you have to tell the server your current time zone. This should be done for the environment in which the server runs (for example, in mysqld_safe or ...You can ...
https://dev.mysql.com/doc/refman/8.4/en/too-many-connections.html
If clients encounter Too many connections errors when attempting to connect to the mysqld server, all available connections are in use by other clients. By granting the privilege to administrators and not to normal users (who should not need it), ...The permitted number of connections is controlled by the max_connections system ...
https://dev.mysql.com/doc/refman/8.4/en/updating-yum-repo.html
Upgrading MySQL Upgrade MySQL components using standard yum (or dnf) commands, such as MySQL Server: sudo yum update mysql-server For platforms that are dnf-enabled: sudo dnf upgrade mysql-server Alternatively, you can update MySQL by telling Yum to ... For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can perform an in-place upgrade for MySQL (that is, replacing the old version and then running the new version using the old data files) with the MySQL Yum ...
https://dev.mysql.com/doc/refman/8.4/en/windows-and-ssh.html
This section describes how to get an encrypted connection to a remote MySQL server with SSH. Either do a remote forward (Set local_port: 3306, remote_host: yourmysqlservername_or_ip, remote_port: 3306 ) or a local forward (Set port: 3306, host: ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
(Bug #37101293) The server could not be built on Ubuntu 22.04 using Clang 13. (Bug #116779, Bug #37329617) The server could not be built on Fedora 40 (and possibly other Linux platforms) using cmake 3.11, due to an issue with TIRPC. (Bug #116164, ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica-backup-restore.html
To restore the backup on a replica server, follow the same steps outlined in Section 8.1, “Setting Up a New replica”. mysqlbackup then restarts the replication SQL thread, so more updates can be made on the replica servers. To backup a replica ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-report-options.html
This requires a connection to the MySQL server, and therefore, only works when backing up a running MySQL instance. Warning The system variable backup_progress is not yet defined for the MySQL Server. The estimated total is updated as per the data ... There are two options for controlling the progress reporting function of mysqlbackup: --show-progress and --progress-interval: --show-progress[={stderr|stdout|file:FILENAME|fifo:FIFONAME|table|variable}] Command-Line Format --show-progress[=destinations] Type Enumeration Valid Values stderrstdoutfile:FILENAMEfifo:FIFONAMEtablevariable The option instructs mysqlbackup to periodically output short progress reports known as progress indicators on its ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-table-update.html
Rename the original mysql.backup_progress table to mysql.backup_progress_old, and the mysql.backup_progress_new table to mysql.backup_progress. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-repository-options.html
The backup repository options are divided into two groups: the first one determines the structure of the backup, and the second one provides information on the original structure of the data on the backed-up server for future operations on the ...