In the earlier post we discuss about how to take backup using mysqldump. Today will discuss about how to take backup using Percona XtraBackup. The Percona XtraBackup is a Physical Dump / Backup which consists of raw copies of data and data directories present in it. This type of backup is very useful and suitable for the databases which contains large and important data sets that need to recovered quickly when the disaster occurs. Creating a Backup: To create a backup, Xtrabackup script has to be called with backup, datadir and targetdir parameters. backup - is to create the backup datadir - which is where the MySQL data directory stored targetdir - backup directory, where we want to save the backup If the target directory does not exist, xtrabackup creates it. If the directory does exist and is empty, xtrabackup will succeed. xtrabackup will not overwrite existing files, it will fail with operating system error 17, file exists . The tool changes its working direct