Showing entries 1 to 10 of 42
10 Older Entries »
Displaying posts with tag: MySQL-Articles (reset)
Export MySQL database table to CSV (delimited / Excel) file

Today lets talk a little about converting a MySQL table to CSV (Excel). My friend was looking to export MySQL to Excel, I saw couple of questions for export MySQL tables to CSV on forums. Since I saw the question often, I thought of writing out all the ways I can think of for exporting […]

A tale of Corrupt InnoDB table, MySQL crash & recovery

I’m going to narrate you a story that happened around a crashing MyQL, Corrupted InnoDB table and finally the recovery by table restore. We will see how our database administrator detected the issue and what he did to resolve it. A day in MySQL Database Consultant’s day was taking its shape while a friend called […]

Reset root password on Galera Cluster (Percona or MariaDB)

Reset MySQL root password for Galera Cluster ( Percona Xtradb / MariaDB )

MySQL to Galera Cluster Migration, Deadlock, Back to basics

This post is a lab experiment learning from migration to the Percona Xtradb Cluster (Galera) and a very unexpected DEADLOCK scenario which took me back to basics. (root@localhost) [test]>insert into app values (1); ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction Little background: We needed to work on migrating the […]

Restoring MySQL Database from xtrabackup – facepalm moments

Learning from facepalm moments of a MySQL database restore from Percona Xtrabackup.

corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads”

This post explains on the usage of mysql_repair_threads for repairing myisam table & the processlist status Repair with N threads

Fixing inconsistency on MySQL Slave of Galera Cluster

This blog post explores the syncing options for an inconsistent MySQL slave of Galera cluster node using pt-table-sync

Setting-up second mysql instance & replication on Linux in 10 steps

This is a quick setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.

pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain

This post discuss the pt-table-checksum & error "Waiting to check replicas for differences: 0% 00:00 remain" with a use-case and solution.

MySQL 1018 (HY000): Can’t read dir errno: 13 – Permission denied

MySQL ERROR 1018 (HY000): Can't read dir of './sakila/' (errno: 13 - Permission denied) caused due to moving database to a different partition and using softlink on CentOS and it's fix for SELinux.

Showing entries 1 to 10 of 42
10 Older Entries »