Re: Help restoring database: MacOS Server (Snow Leopard)

2013-01-10 Thread Jan Steinman
Okay, panic over. I recursively stripped the ACLs and things are working. Next time I drop a table from phpMyAdmin, I'll carefully read the little thing that pops up saying I'm about to drop an entire database... :-( One gets so "yea, whatever" to warning notifiers...) Thanks to all who sent he

Re: Help restoring database: MacOS Server (Snow Leopard)

2013-01-09 Thread Karen Abgarian
Hi, It is not very surprising that the database cannot recover from a Time Machine backup. This generally applies to any software that is running at the moment the backup is taken. The InnoDB is especially sensitive to taking what is called a 'dirty' backup because it has a cache. You ma

Re: Help restoring database: MacOS Server (Snow Leopard)

2013-01-09 Thread Reindl Harald
Am 09.01.2013 16:33, schrieb Jan Steinman: > 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 >

Help restoring database: MacOS Server (Snow Leopard)

2013-01-09 Thread Jan Steinman
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 u