From: Jan Steinman
Date: January 9 2013 3:33pm
Subject: Help restoring database: MacOS Server (Snow Leopard)
List-Archive: http://lists.mysql.com/mysql/228868
Message-Id: <45B1CFB2-2CB7-4CC3-8A1D-256BE38581B6@Bytesmiths.com>
MIME-Version: 1.0 (Apple Message framework v1085)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

I accidentally dropped a crucial database. My only backup is via Apple's =
Time Machine.

First, I stopped mysqld and copied (via tar) the database in question =
from the backup. Restarted, but drat -- most of the tables were =
apparently using innodb's ibdata1 file, as only the MyISAM tables showed =
up in phpMyAdmin.

I copied the ibdata1, but then mysqld wouldn't start, complaining about =
no mysql.sock, which was odd, because it was there.

I then copied (via tar) the entire set of all databases, but am still =
having problems, I think related to Time Machine's ACL lists and =
extended attributes.

Anyone have experience and wise words on restoring a database from Time =
Machine?

Thanks!

----------------
:::: Books are associated with communities of writers, printers, =
proofreaders and a host of other people with whom the writer =
interacts... Granted, there are some websites that provide well written =
and researched articles and information. Unfortunately, many are not. =
The Internet may be more of a time using machine than TV. And its usage =
is not always positive. -- Pat Murphy
:::: Jan Steinman, EcoReality Co-op ::::