Search Results
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-positions.html
Find the precise binary log event position corresponding to the point in time up to which you want to restore your database. Your database has now been restored to the point-in-time of interest, tp, right before the table pets.cats was dropped. The ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
Database privilege changes take effect the next time the client executes a USE db_name statement. Note Client applications may cache the database name; thus, this effect may not be visible to them without actually changing to a different database.
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
If a statement produces different errors on the source and the replica, the replication SQL thread terminates, and the replica writes a message to its error log and waits for the database administrator to decide what to do about the error. This ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
(If events access these tables explicitly for other purposes, you must grant the appropriate privileges on the tables.) Applying a binary log Table_map_log_event, which provides table metadata but does not make any database changes. Alternatively, ... The user account that is specified using the CHANGE REPLICATION SOURCE TO statement as the PRIVILEGE_CHECKS_USER account for a replication channel must have the REPLICATION_APPLIER privilege, otherwise the replication applier thread does not ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups.html
How you back up a database depends on its size and whether you are backing up only the data, or the data and the replica state so that you can rebuild the replica in the event of failure. There are therefore two choices: If you are using replication ... 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.4/en/replication-solutions-unexpected-replica-halt.html
Updates to the applier metadata repository are committed together with the transactions, meaning that the replica's progress information recorded in that repository is always consistent with what has been applied to the database, even in the event ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
To revoke all privileges from a user, use one of the following statements; either of these statements drops all global, database, table, column, and routine privileges for the named users or roles: REVOKE ALL PRIVILEGES, GRANT OPTION FROM ...[IGNORE ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
Creating Roles and Granting Privileges to Them Defining Mandatory Roles Checking Role Privileges Activating Roles Revoking Roles or Role Privileges Dropping Roles User and Role Interchangeability Creating Roles and Granting Privileges to Them ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-trigger.html
row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE DEFINER=`me`@`localhost` TRIGGER ...
https://dev.mysql.com/doc/refman/8.4/en/show-open-tables.html
The FROM clause, if present, restricts the tables shown to those present in the db_name database. SHOW OPEN TABLES output has these columns: Database The database containing the table. SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE ...