Install a same version of MySQL and copy all datadir, watch for privileges on dir. On old disk find /etc/my.cnf and find the 'datadir' parameter, that all you must copy where the new instance has its own datadir.
Claudio On Jun 16, 2011 7:51 PM, "leegold" <leeg...@fastmail.fm> wrote: > Hi, > > I have a situation where the box with a mysql server will not boot. But > I can boot it from a CD and browse the hard drive and I can mount > partitions so files and data are accessible. I want to somehow take the > Mysql DB structure and content, copy it, and move it to a bootable > working unit. Normally I'd run the script that puts it "all" into a > comma delimited file that can be reconstituted at a later date. But in > my case I can only copy and paste files from an unbootable unit to a > working server and try to reconstitute it from there. > > It is Ubuntu 10.4 server. Is what I want to do possible? What > directories and files would I need to copy? First I would have a working > Mysql server on the new unit then I assume I would copy to the new > server and process the data if necessary...any help on how to proceed > appreciated. > > Thanks, > > Lee G. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com >
