PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-general-options.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. --defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
To retain the same log file names if you change your host name to something else, you must explicitly use options such as --log-bin=old_host_name-bin. If these are binary logs, you must edit the binary log index file and fix the binary log file ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-reference.html
Firewall Group Profile Tables Firewall Account Profile Tables Firewall Group Profile Tables As of MySQL 8.0.23, MySQL Enterprise Firewall maintains group profile information using tables in the mysql system database for persistent storage and ...For ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when restoring tables from SQL dump files created from databases that are encrypted or that have their tables stored outside the data directory. For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups.html
For larger databases, where mysqldump would be impractical or inefficient, you can back up the raw data files instead. Using the raw data files option also means that you can back up the binary and relay logs that make it possible to re-create the ... To use replication as a backup solution, replicate data from the source to a replica, and then back up the ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-key-cache.html
(In other words, table index blocks are accessed using the same strategy as that employed for table data blocks.) An index block is a contiguous unit of access to the MyISAM index files. When data from any table index block must be accessed, the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-server.html
A typical my.cnf file might look like this: [mysqld] datadir=/usr/local/mysql/var socket=/var/tmp/mysql.sock port=3306 user=mysql [mysql.server] basedir=/usr/local/mysql The mysql.server script supports the options shown in the following table. If ...To run the server as some specific user, add an appropriate user option to the [mysqld] group of the global /etc/my.cnf option file, as shown later in this ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-crash-recovery.html
When performing crash recovery, it is important to understand that each MyISAM table tbl_name in a database corresponds to the three files in the database directory shown in the following table. File Purpose tbl_name.MYD Data file tbl_name.MYI Index ...If you cannot guarantee this, you must stop mysqld while you check the ... This ...For an explanation of ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
To use this function, the file must be located on the server host, you must specify the full path name to the file, and you must have the FILE privilege. The file must be readable by the server and its size less than max_allowed_packet bytes. If the ...LOAD_FILE(file_name) Reads the file and returns the file contents as a ...For ...mysql> SELECT CHAR(77,121,83,81,'76'); +--------------------------------------------------+ | CHAR(77,121,83,81,'76') | +--------------------------------------------------+ | 0x4D7953514C | +--------------------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT CHAR(77,77.3,'77.3'); +--------------------------------------------+ | CHAR(77,77.3,'77.3') | +--------------------------------------------+ | 0x4D4D4D | ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. This is done ...In the latter case, you should run REPAIR TABLE on the ...