Restore MySQL database from binary log

Restore MySQL database from binary log

To learn more about what is binary log and how to setup Click here MySQL binary log : mysqlbinlog utility

mysql

MySQL binary log : mysqlbinlog utility

April 30, 2016 Satya Prakash 2 Comments database recovery from binary log, Enable Binary Logs In MySQL Server, how to setup and use binary log, MySQL binary log, MySQL binary log : mysqlbinlog utility, MySQL binary logmysql, mysql db recovery from binary log, mysql log, mysql replication from binary log, mysqlbinlog utility, set up mysql binary log, Setup and Use of Binary log:, What is MySQL binary log, Why MySQL binary log?, why we need binary log

Mysql binary log is a special kind of logging facility provided by MySql by which we can record the log

mysql

Kill slow mysql queries

April 29, 2016 Satya Prakash 0 Comments A script for killing slow MySQL queries, automatically kill slow mysql queries, Kill slow mysql queries, linux - Assign a timeout period for MySQL queries, MySQL error during large queries. Timeout, mysql slow query, performance - Automatic kill/timeout slow queries in MySQL, performance - Mysql. Block/disconnect slow queries, Server-side SELECT statement timeouts, slow mysql query, time out slow mysql queries, timeout - How can I stop a MySQL query if it takes too long

A Shell script for killing slow MySQL queries: #!/bin/sh # Credentials for a MySQL user with PROCESS, SUPER permissions USERNAME=

mysql

Purge Binary log

April 28, 2016April 30, 2016 Satya Prakash 1 Comment binary log delete, binary log size reduce, MySQL, mysql binary log delete, mysql log, mysql log cleanup, mysql log file delete, mysql old log cleanup, Purge Binary log, reduce binary log size, remove old log mysql, show binary log

If you have enabled binary logging for the point-in-time recovery (or using replication in your environment) option and forgot to

python

Python Function

April 26, 2016 Satya Prakash 0 Comments define python fuction, learn python, python, python example, python function, python tutorial

What are functions? Functions are a convenient way to divide your code into useful blocks, allowing us to order our

linux

ntp – installation and configuration

April 26, 2016April 26, 2016 Satya Prakash 0 Comments adjust date time ntp, centos ntp server set up, Linux, linux ntp server, linux ntp service, network time server, network time set up, ntp, ntp - installation and configuration, ntp set up, ntp setup, ntpd revices

You need to install the following packages: ntp : ntpd server which continuously adjusts system time and utilities used to

mysql

MySQL trim function

April 24, 2016 Satya Prakash 0 Comments function, MySQL, mysql function, mysql string function, MySQL trim function, trim, trim in mysql

MySQL TRIM() function returns a string after removing all prefixes or suffixes from the given string. Syntax TRIM([{BOTH | LEADING

php-mysql

PHP – MySQL : Create Database

April 24, 2016April 24, 2016 Satya Prakash 0 Comments MySQL, pdo database connection php mysql, PHP, PHP - MySQL : Create Database, php database create mysql, php mysql, php mysql database create php code, php mysqli database create

[root@mysqlDB]# mysqladmin -u root -p create eduguru Enter password:****** This will create a MySQL database eduguru. This is a simple example

mysql

MySQL RAND Function

April 23, 2016 Satya Prakash 0 Comments MySQL, mysql function, MySQL RAND Function, mysql string function

MySQL has a RAND function that can be invoked to produce random numbers between 0 and 1: mysql> SELECT RAND(

mysql

mysql locate function

April 17, 2016 Satya Prakash 0 Comments locate in mysql, locate mysql function, MySQL, mysql function, mysql locate function, mysql string function

MySQL LOCATE() returns the position of the first occurrence of a string within a string. Both of these strings are

Eduguru

Author: Satya Prakash