Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-partial-options.html
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 (TLR)”. --include-tables=REGEXP Command-Line Format ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-management-range-list.html
For information about working with tables that are partitioned by hash or key, see Section 26.3.2, “Management of HASH and KEY Partitions”. Dropping a partition from a table that is partitioned by either RANGE or by LIST can be accomplished ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-compression-internals.html
This section describes some internal implementation details about compression for InnoDB tables. These properties make this compression technique unsuitable for use in an update-intensive database system. When compression is working well for a data ...The information presented here may be helpful in tuning for performance, but is not necessary to know for basic use of ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
Backup failed to insert table list (check configuration) 1347 MySQL error. Backup failed to allocate table memory (check configuration) 1348 MySQL error. Table fragment fixed data reference has reached maximum possible value (specify MAXROWS or ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-access-linked-tables.html
You can use Microsoft Access as a front end to MySQL by linking tables within your Microsoft Access database to tables that exist within your MySQL database. When a query is requested on a table within Access, ODBC is used to execute the queries on ...Figure 5.24 Get External Data: Link To ODBC Database Option Chosen The Select Data Source dialog box appears; it lists the defined data sources for any ODBC drivers installed on your ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html
You can use Microsoft Access as a front end to MySQL by linking tables within your Microsoft Access database to tables that exist within your MySQL database. When a query is requested on a table within Access, ODBC is used to execute the queries on ...Figure 6.13 Get External Data: Link To ODBC Database Option Chosen The Select Data Source dialog box appears; it lists the defined data sources for any ODBC drivers installed on your ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-plugin.html
The MYSQL_FIREWALL plugin, along with server-side plugins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL_WHITELIST, implement Performance Schema and Information Schema tables that provide views into the registered profiles. Tables in the firewall ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations.html
Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were created. Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/9.7/en/column-count-limit.html
This section describes limits on the number of columns in tables and the size of individual rows. Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-migration.html
This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new ...MySQL Enterprise Backup The MySQL Enterprise Backup product lets you back up a running MySQL database with minimal disruption to operations while producing a consistent snapshot of the ...