This table that lists every MySQL Server option or variable, what version it was introduced or deprecated in, whether it’s dynamic or not, whether variables have session/global/both scope, and links to the version-specific documentation for that variable. Name Intr Depr
MySQL Trigger – after insert trigger
I want to populate automaticaly another table when new data is inserted: For table “source_table” define a after insert trigger DELIMITER $$ CREATE TRIGGER `source_table_AINS` AFTER INSERT ON `source_table` FOR EACH ROW — Edit trigger body code below this line.
MySQL Utilities – Brief overview of command-line utilities
MySQL Utilities This is a brief overview of the MySQL command-line utilities. See their respective manual pages for further details and examples: mysqlauditadmin Monitor the audit log. Copy, rotate, and configure the audit log mysqlauditgrep Search the audit log. Output results to
MySQL replication: PURGE BINARY LOGS and RESET MASTER
On MySQL master, “RESET MASTER” command, deletes all binary log files listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. This statement is intended to be used only
MySQL replication – master slave schema
Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous – slaves need not be connected permanently to receive updates from the master. This means
Save Apache log in MySQL database
Apache webserver can be configured to save access logs into database via Apache Module mod_log_config. This module provides for flexible logging of client requests. Logs are written in a customizable format, and may be written directly to a file, or to
mysql: –i-am-a-dummy
This option prevents MySQL from performing update operations unless a key constraint in the WHERE clause and / or a LIMIT clause are provided. mysql –i-am-a-dummy -uroot test For beginners, a useful startup option is –safe-updates (or –i-am-a-dummy, which has