You will need to take the datadir directory, typically found under
It would also be a good idea to grab your configuration file from
/etc/mysql/my.cnf or /etc/my.cnf (ubuntu tends to be the former).
Once transplanted into your new server remember to check that the
permissions on the implanted files. Starting the MySQL Server Daemon should
initiate the InnoDB Crash recovery procedure and you should be up and
That's a 50,000ft overview of the process but unless you're having some
other more serious issues with the data then the previous steps should get
you working again.
On Thu, Jun 16, 2011 at 6:50 PM, leegold <leegold@stripped> wrote:
> 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
> Lee G.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1