[Gllug] Extract the data from a MySQL database's *files*?

[Daniel P. Berrange]

On Thu, Apr 01, 2010 at 03:26:36PM +0100, Richard Jones wrote:
> On Thu, Apr 01, 2010 at 02:39:55PM +0100, Richard Huxton wrote:
> > On 01/04/10 14:29, Richard Jones wrote:
> > >
> > > I've got a friend who has a VM image.  This image used to be a MySQL
> > > database instance, but for various reasons we cannot boot it any more.
> > >
> > > However, the raw MySQL database files are still on there.
> > >
> > > Can we extract the data somehow?  Can we tell another MySQL instance
> > > to look at these files?
> > 
> > If you have actual files, then yes. Can you mount the image's virtual 
> > disks OK?
> 
> Yup, the /var filesystem is fine, it just cannot be booted because
> there is no operating system.
> 
> So I have the /var/... mysql files, including a Wordpress database,
> and I just want to extract that to another MySQL instance.

Can you re-install the same version of the original OS distro in a new VM, 
add mysql there, and then copy the data files over into the new install ?

Regards,
Daniel
-- 
|: http://berrange.com      -o-    http://www.flickr.com/photos/dberrange/ :|
|: http://libvirt.org              -o-             http://virt-manager.org :|
|: http://autobuild.org       -o-         http://search.cpan.org/~danberr/ :|
|: http://entangle-photo.org       -o-       http://live.gnome.org/gtk-vnc :|
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug