Could happen to have a mysql database with a lot of tables and we want dump all of them, but we also want to make the logical dump process faster. Some of you could say that mydumper is the solution. It could be. But what if we don’t have the permission to install it or whatever? … Continue reading Dumping multiple mysql tables at once
I want to backup my databases without downtime… Well, there are couple approaches to this. One of them is to add a standby slave and use LVM snapshot approach. The second approach is to use percona xtrabackup. My problem is that I have some huge databases here, so taking local backups is out of the question. … Continue reading mysql hot backup with xtrabackup
The approach is simple: generate a list of installed packages on Debian-based systems and install this list of packages on the new box. This approach is useful when you want to install the same packages on another fresh OS install for example. 1. To export the list of installed packages, proceed as follows: [codesyntax lang=”bash”] … Continue reading How to install the same debian packages on another system
This is a short but potentially extremely handy guide to ghosting one Linux box to another (or simply making a full backup of a desktop/server). On the target machine: [codesyntax lang=”bash”] nc -p 2222 -l | bzip2 -d | dd of=/dev/hdb [/codesyntax] On the source machine: [codesyntax lang=”bash”] bzip2 -c /dev/hda | nc 10.111.1.206 2222 … Continue reading How to clone a running Linux system over network using netcat
With XenServer it is possible to create backups of VMs, even if they are running. The process is as follows: Search for the uuid of the VMs to backup First look for the uuid of the VMs to backup. We don’t want to backup the control domain itself, so we add is-control-domain=false to the vm-list … Continue reading Creating backups of running VMs in XenServer
To export just leave the filename blank as in this example: [codesyntax lang=”bash”] xe vm-export vm=VM-UUID filename= | gzip -c > /mnt/vm.xva.gz [/codesyntax] To import use /dev/stdin as filename: [codesyntax lang=”bash”] gunzip -c /mnt/vm.xva.gz | xe vm-import sr-uuid=SR-UUID filename=/dev/stdin [/codesyntax]