List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:June 16 2011 6:12pm
Subject:Re: How to copy file from an old server to reconstitute a database ?
View as plain text  
Lee,

You will need to take the datadir directory, typically found under
/var/lib/mysql/

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
running again.

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.

A

On Thu, Jun 16, 2011 at 6:50 PM, leegold <leegold@stripped> 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=1
>
>

Thread
How to copy file from an old server to reconstitute a database ?leegold16 Jun
  • Re: How to copy file from an old server to reconstitute a database ?Andrew Moore16 Jun
    • Re: How to copy file from an old server to reconstitute a database ?leegold18 Jun
      • Re: How to copy file from an old server to reconstitute a database ?Claudio Nanni19 Jun
  • Re: How to copy file from an old server to reconstitute a database ?Claudio Nanni16 Jun