mysql

Creating a backup user with read-only permission for MySQL DB

by
mysql-backup-user-poster

Why do we need to create a user with read-only permission? Most people use “mysqldump” for taking the backup of MySQL. And when we automate the backup process the password of the user is saved in a file (Ex. script or mysql.inf ). If our backup user is a superuser and something went wrong in … Read more

Backup all MySQL Databases with a MySQL Backup Script

by
MySQL-Logo

In this article, we will create a simple MySQL backup script for taking backups of all your MySQL databases periodically. If your website or web app runs over a LAMP stack or you’re running a Linux OS whether it is Ubuntu or Centos, you can write a simple script for taking MySQL backups at a … Read more