Category: BACKUP & RECOVERY
For BACKUP & RECOVERY articles under category MySql.
Perform Mysql Physical Backup using Percona Xtrabackup
Perform Mysql Physical Backup using Percona Xtrabackup The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running. Percona XtraBackup is a free, online, open source, complete database backups solution for all versions of Percona Server for MySQL and MySQL. Percona XtraBackup performs online non-blocking, tightly compressed, highly secure full backups on transactional […]
721 Total Views, 3 Views Today
Steps to Install Percona XtraBackup for MySQL
Steps to Install Percona XtraBackup for MySQL The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running. Percona XtraBackup is a free, online, open source, complete database backups solution for all versions of Percona Server for MySQL and MySQL. Percona XtraBackup performs online non-blocking, […]
912 Total Views
Step by Step Migrate Database from Non-ASM to ASM in Oracle
Step by Step Migrate Database from Non-ASM to ASM in Oracle This article is a continuation of a recent article where we have demonstrated Offline Restore or Clone Database on the same server or rename database in Oracle click here to go through it. In this article, we will perform a Step by Step Migrate […]
1,187 Total Views, 3 Views Today
How to Rename Database and DBID using DBNEWID in Oracle
Rename Database and DBID using DBNEWID in Oracle In this article, we are going to demonstrate rename of the database along with DBID using utility DBNEWID in Oracle. The question comes in mind why we require to rename DB? Whenever we do clone a database to a target (clone DB) server from the source (production […]
1,079 Total Views, 1 Views Today
RMAN Full Database Backup Scripts in Oracle
RMAN Full Database Backup Scripts in Oracle. In this article, we are going to prepare a script for RMAN full database backup which includes backup of datafiles, control files, spfile along with archives. This RMAN full database script will create a backup in a specified location (local directory) on the database server. Generally, we do […]
1,404 Total Views, 5 Views Today
Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle
Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle Here we are going to demonstrate multiplexing of Control Files in Oracle using available options SPFILE, PFILE & RMAN. Before moving ahead first we will have a basic understanding of Control Files in Oracle. Control File is a physical file on OS level and […]
2,599 Total Views
Mysql Logical Backup using mysqlsh – Import
Mysql Logical Backup using mysqlsh – Import This blog post is a continuation of the previous blog post Mysql Logical Backup using mysqlsh – Export Click here to read more. In the previous blog, we saw How to perform the export of the Database and Table using mysqlsh. Now in this post, we will see How to perform an import of […]
1,425 Total Views
Mysql Logical Backup using mysqlsh – Export
Mysql Logical Backup using mysqlsh – Export In this article, we are going to demonstrate MySQL Logical Backup using mysqlsh – Export. There are several ways to backup MySQL data. Those are: – 1) Physical Backup 2) Logical Backup Physical Backup:It […]
2,084 Total Views, 10 Views Today
Mysql Logical Backup using myloader – Import
Mysql Logical Backup using myloader – Import This blog post is a continuation of the previous blog post Mysql Logical Backup using mydumper – Export Click here to read more. In the previous blog, we saw How to perform the export of the Database and Table using mydumper. Now in this post, we will see […]
1,438 Total Views, 2 Views Today
Mysql Logical Backup using mydumper – Export
Mysql Logical Backup using mydumper – Export In this article, we are going to demonstrate Mysql Logical Backup using mydumper – Export. There are several ways to take the backup of MySQL data. Those are: – 1) Physical Backup 2) […]
1,837 Total Views, 1 Views Today
Recent Comments