This post will guide you to set up and automate the MySQL logical backups using mysqldump on Ubuntu Linux. We will set-up MySQL backup using mysqldump and automate it with Holland backup framework on Ubuntu. Towards the end of the post, you have the steps to be executed in a single block which includes steps […]
This post is for the backup script for MySQL database on Linux with mail. It’s a linux shell script for taking logical backup using mysqldump and sending status email. The backup shell script works as follows: – The script takes backup using mysqldump and compresses it. – Upon success, it will attempt to ship the […]
How to Restore A Table / Database From Full Backup using MySQL Grants & mysqldump.
Moving, copying or renaming database is a very basic activity. I have just noted a few commands for reference to quickly follow the required operation. 1. Rename database on Linux Machine: A. Use RENAME DATABASE Command [MySQL 5.1]. RENAME DATABASE db_name TO new_db_name; B. mysql -uroot -pPASSWORD -e “drop database if exists NEW-DB-NAME; create database […]
Change Is Inevitable