Category Archive: MySQL

Dec 01

Solved – AWS RDS MySQL ERROR 1227 (42000) at line : Access denied

When your are trying to import your data into RDS MySQL, it may prompt with following error message. “ERROR 1227 (42000) at line xxx: Access denied; you need (at least one of) the SUPER privilege(s) for this operation”   This can be fixed by removing the DEFINER from MySQL dump. You can use following simple …

Continue reading »

Jan 12

How to Move MySQL Data Directory to New Location on CentOS

In default MySQL installation, Data Directory pointed to “/var/lib/mysql/” . As a best practice, it’s recommended to move Data directory to new location which contains more disk space than default root partition. This tutorial guides you how to Move MySQL data directory to new location on CentOS or RHEL. Even data directory contains data, you …

Continue reading »

Apr 21

Automatically Backup MySQL Databases on Windows

Task Scheduler - Create Task

Unlike on Linux, when MySQL is running on Windows, most of sys-admins including myself found that backup MySQL Databases on Windows is little bit hard. When trying to automate it, then it would definitely become challenge . However there are lots of free and commercial tools are available to automate MySQL backup process on windows. …

Continue reading »

Older posts «

Fetch more items