Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
--replicate-do-table=db_name.tbl_name Command-Line Format --replicate-do-table=name Type String Creates a replication filter by telling the replication SQL thread to restrict replication to a given table. You can also create such a filter by issuing ...On the source and each replica, you must set the server_id system variable to establish a unique replication ID in the range from 1 to 232 ... This section explains the server options and system variables that apply to replica servers and contains the following: ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
I .ibd file Each InnoDB tablespace created using the file-per-table setting has a filename with a .ibd extension. .ibz file When the MySQL Enterprise Backup product performs a compressed backup, it transforms each tablespace file that is created ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbinterpretedcode.html
To create an NdbInterpretedCode object, invoke the constructor, optionally supplying a table for the program to operate on, and a buffer for program storage and finalization. Description NdbInterpretedCode represents an interpreted program for use ... This section provides information about the NdbInterpretedCode class, which can be used to prepare and execute an NDB API interpreted ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
Create foreign key failed in NDB - parent table is not table 21023 MySQL error. Create foreign key failed in NDB - invalid parent table version 21024 MySQL error. Create foreign key failed in NDB - child table is not table 21025 MySQL error. Create ...Backup failed to insert table list (check configuration) 1347 MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
If you now execute a SHOW CREATE TABLE statement, you can see how the partitioning makeup of the table has been changed: mysql> SHOW CREATE TABLE tr\G *************************** 1. Another solution might appear to be to make a copy of the table ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
If you use USE_FRM for a table that was created by a different version of the MySQL server than the one you are currently running, REPAIR TABLE does not attempt to repair the table. With myisamchk --safe-recover, you can also use options that REPAIR ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
Source and target tables for replication do not have to be identical. A table on the source can have more or fewer columns than the replica's copy of the table. In addition, corresponding table columns on the source and the replica can use ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
Previously, these tables were created in individual tablespace files in the mysql database directory. Note Like the mysql.func system table, the Performance Schema user_defined_functions table lists loadable functions installed using CREATE FUNCTION. This table is created only if the server is built with NDBCLUSTER ...It contains ...The server ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
When you create a MERGE table, MySQL creates a .MRG file on disk that contains the names of the underlying MyISAM tables that should be used as one. Note The use of MERGE tables entails the following security issue: If a user has access to MyISAM ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-partial-options.html
The option can also be used with the backup-dir-to-image and image-to-backup-dir commands to select tables when creating or unpacking a backup image. The option can also be used with the backup-dir-to-image and image-to-backup-dir commands to select ...For an overview of partial backup and restore, as well as usage examples on the following options, see Section 4.3.5, “Making a Partial Backup” and Section 5.1.4, “Table-Level Recovery ...