Search Results
https://dev.mysql.com/doc/refman/8.4/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. In a WITH CHECK OPTION clause for an updatable view, the LOCAL and CASCADED keywords ...It ...
https://dev.mysql.com/doc/refman/8.4/en/view-metadata.html
To obtain metadata about views: Query the VIEWS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/8.4/en/windows-testing.html
In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant tables. For more information about mysqlshow, see Section 6.5.6, “mysqlshow — Display ...
https://dev.mysql.com/doc/refman/8.4/en/windows-troubleshooting.html
Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist These messages often occur when the MySQL base or data directories are installed in different locations than the default locations (C:\Program Files\MySQL\MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-system-monitoring.html
To be able to monitor the generated SQL, the Performance Schema tables must be enabled. The SQL is registered under the performance_schema.events_statements_current, performance_schema.events_statements_history, and ... For general X Plugin ...
https://dev.mysql.com/doc/refman/8.4/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-prep-gather.html
Before backing up a particular database server for the first time, gather some information and use it to make some planning decisions, as outlined in the following table. Table 4.1 Information Needed to Back Up a Database Information to Gather ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/exec-option.html
The --exec-when-locked option of mysqlbackup lets you specify a command (together with the desired command arguments) to run near the end of the backup while the database's non-InnoDB tables are still locked. For example, you can use this option to ...This command can copy or create additional files in the backup ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/intro.html
While optimized for use with InnoDB tables, MySQL Enterprise Backup is capable of backing up and restoring all kinds of tables created by any kinds of storage engines supported by MySQL. MySQL Enterprise Backup 8.4.6 is a backup utility for MySQL ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-exitcodes.html
The meaning of each code is explained in Table 17.1, “MySQL Enterprise Backup Exit Codes and Messages” by its associated exit message. MySQL Enterprise Backup returns one of the following exit codes as it exits an operation. Users can, for ...