[Klug-general] Restoring sql backups not all rows restoring

[Roger Gammans]

On Wed, 2014-08-13 at 12:45 +0100, Laurence Southon wrote:
> On 13/08/14 09:13, Nathan Friend wrote:
> > If your having trouble with the import just copy the files from on the
> > source server.  Shutdown MySQL first then tar up /var/lib/mysql directory.
> 
> If you need to keep the source database live, a work around I've used is
> this:
> ....

Nice trick,  but wouldn't using dm-snapshot be simpler ?

Everybody uses LVM these days don't they ? (unless perhaps they are
using btrfs, or zfs, but they have internal equivalents)


-- 
Roger Gammans <roger at gammascience.co.uk>