[Gllug] Extract the data from a MySQL database's *files*?
Daniel P. Berrange
dan at berrange.com
Thu Apr 1 14:28:54 UTC 2010
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 ?
|: 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
More information about the GLLUG