Tuesday, 20 December 2016

Back Up and Restore a MySQL Database

›
You can backup your MySQL data by using the mysqldump command. This command connects to the MySQL server and creates an SQL dump file $ m...
Tuesday, 13 December 2016

Grant on mysql 5.7

›
 Administrative privileges enable users to manage operation of the MySQL server.Privileges for database objects such as tables, indexes, vi...
Friday, 7 October 2016

mysql table is marked as crashed repair failed

›
mysql> repair table my_table; +------------------------------+--------+----------+-----------------------------------------------------...
Wednesday, 5 October 2016

Solved (without restart) Mysql slow query log is on but not logging anything

›
1.First cross check /etc/my.cnf to make it permanent slow_query_log = 1 slow_query_log_file = /var/log/mysql_slow_query.log 2.Permiss...
Tuesday, 16 August 2016

Solved Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work

›
Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replicati...
1 comment:
Wednesday, 8 June 2016

Dumping MySQL Stored Procedures, Functions and Triggers

›
Mysqldump will backup by default all the triggers but NOT the stored procedures/functions. There are 2 mysqldump parameters that control th...
Monday, 23 May 2016

Mysql slow query log not working

›
Add this in my.cnf and then restart MySQL server: general_log = 1 log=/var/log/mysql_slowquery.log You can check whether the general_l...
Wednesday, 18 May 2016

Mysql change table engine MyISAM to InnoDB

›
 The easiest way is ALTER TABLE table_name ENGINE = InnoDB; InnoDB uses row level locks

Command to optimize all MySQL tables one by one automatically

›
 use mysqlcheck with --optimize and --databases combination. mysqlcheck is a command-line interface for administrators  mysqlcheck -uroo...
Tuesday, 10 May 2016

Speedly MySQL InnoDB Shutdown

›
Depending on the size of the databases you have in mysql innodb the time it takes mysql to restart can be very slow.Some tricks that can sp...