Jan Steinman Help restoring database: MacOS Server (Snow Leopard)
Jan 09, 2013; 07:33
Jan Steinman
Help restoring database: MacOS Server (Snow Leopard)
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 ::::
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Jan 09
Reindl Harald Re: Help restoring database: MacOS Server (Snow Leopard)
Jan 09, 2013; 16:39
Reindl Harald
Re: Help restoring database: MacOS Server (Snow Leopard)
Jan 09
Karen Abgarian Re: Help restoring database: MacOS Server (Snow Leopard)
Jan 09, 2013; 09:22
Karen Abgarian
Re: Help restoring database: MacOS Server (Snow Leopard)
Jan 09
Jan Steinman Re: Help restoring database: MacOS Server (Snow Leopard)
Jan 09, 2013; 16:57
Jan Steinman
Re: Help restoring database: MacOS Server (Snow Leopard)
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!