{"id":185,"date":"2018-09-03T19:40:29","date_gmt":"2018-09-03T19:40:29","guid":{"rendered":"http:\/\/www.beer.org\/blog\/?p=185"},"modified":"2018-09-03T19:40:29","modified_gmt":"2018-09-03T19:40:29","slug":"recover-your-zoneminder-data-after-inadvertent-loss-of-ib_logfile01","status":"publish","type":"post","link":"https:\/\/www.beer.org\/blog\/index.php\/2018\/09\/03\/recover-your-zoneminder-data-after-inadvertent-loss-of-ib_logfile01\/","title":{"rendered":"Recover your zoneminder data after inadvertent loss of ib_logfile[01]"},"content":{"rendered":"

In the unlikely event that you’ve lost your Mysql ib_logfile[01] files, you will google and try to figure out whether you can get the data back.\u00a0 All the googling will tell you that all of your data is in those log files but that’s not true as of any recent version of mysql.\u00a0 I was looking around in \/var\/lib\/mysql\/zm\/ and noticed the .ibd files were sizable which suggested the data was actually in there instead.\u00a0 After some googling, I found you can import data back into a freshly created Zoneminder DB.<\/p>\n

I decided to uninstall\/reinstall zoneminder\u00a0 from scratch and then recreate the DB:<\/p>\n

https:\/\/stackoverflow.com\/questions\/18761594\/how-do-i-do-a-clean-re-install-of-zoneminder<\/p>\n

After doing that, I did the following:<\/p>\n

(there are shell commands interspersed with the mysql commands so you can see the order of operations):<\/p>\n

 <\/p>\n

\n

lock tables Devices write;
\nalter table Devices discard tablespace;
\n# cp -p saved\/Devices.idb \/var\/lib\/mysql\/zm\/
\nalter table Devices import tablespace;<\/p>\n

lock tables Events write;
\nalter table Events discard tablespace;
\n# cp -p saved\/Events.idb \/var\/lib\/mysql\/zm\/
\nalter table Events import tablespace;<\/p>\n

lock tables Filters write;
\nalter table Filters discard tablespace;
\n# cp -p saved\/Filters.idb \/var\/lib\/mysql\/zm\/
\nalter table Filters import tablespace;<\/p>\n

lock tables Frames write;
\nalter table Frames discard tablespace;
\n# cp -p saved\/Frames.idb \/var\/lib\/mysql\/zm\/
\nalter table Frames import tablespace;<\/p>\n

lock tables Groups write;
\nalter table Groups discard tablespace;
\n# cp -p saved\/Groups.idb \/var\/lib\/mysql\/zm\/
\nalter table Groups import tablespace;<\/p>\n

lock tables Logs write;
\nalter table Logs discard tablespace;
\n# cp -p saved\/Logs.idb \/var\/lib\/mysql\/zm\/
\nalter table Logs import tablespace;<\/p>\n

lock tables MonitorPresets write;
\nalter table MonitorPresets discard tablespace;
\n# cp -p saved\/MonitorPresets.idb \/var\/lib\/mysql\/zm\/
\nalter table MonitorPresets import tablespace;<\/p>\n

lock tables Monitors write;
\nalter table Monitors discard tablespace;
\n# cp -p saved\/Monitors.idb \/var\/lib\/mysql\/zm\/
\nalter table Monitors import tablespace;<\/p>\n

lock tables Servers write;
\nalter table Servers discard tablespace;
\n# cp -p saved\/Servers.idb \/var\/lib\/mysql\/zm\/
\nalter table Servers import tablespace;<\/p>\n

lock tables States write;
\nalter table States discard tablespace;
\n# cp -p saved\/States.idb \/var\/lib\/mysql\/zm\/
\nalter table States import tablespace;<\/p>\n

lock tables TriggersX10 write;
\nalter table TriggersX10 discard tablespace;
\n# cp -p saved\/TriggersX10.idb \/var\/lib\/mysql\/zm\/
\nalter table TriggersX10 import tablespace;<\/p>\n

lock tables Users write;
\nalter table Users discard tablespace;
\n# cp -p saved\/Users.idb \/var\/lib\/mysql\/zm\/
\nalter table Users import tablespace;<\/p>\n

lock tables ZonePresets write;
\nalter table ZonePresets discard tablespace;
\n# cp -p saved\/ZonePresets.idb \/var\/lib\/mysql\/zm\/
\nalter table ZonePresets import tablespace;<\/p>\n

lock tables Zones write;
\nalter table Zones discard tablespace;
\n# cp -p saved\/Zones.idb \/var\/lib\/mysql\/zm\/
\nalter table Zones import tablespace;<\/p>\n<\/blockquote>\n

After that, ‘systemctl restart zoneminder’ and hope for the best.<\/p>\n","protected":false},"excerpt":{"rendered":"

In the unlikely event that you’ve lost your Mysql ib_logfile[01] files, you will google and try to figure out whether you can get the data back.\u00a0 All the googling will tell you that all of your data is in those log files but that’s not true as of any recent version of mysql.\u00a0 I was… Continue reading »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-185","post","type-post","status-publish","format-standard","hentry","category-tech-stuff"],"_links":{"self":[{"href":"https:\/\/www.beer.org\/blog\/index.php\/wp-json\/wp\/v2\/posts\/185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beer.org\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.beer.org\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.beer.org\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.beer.org\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=185"}],"version-history":[{"count":1,"href":"https:\/\/www.beer.org\/blog\/index.php\/wp-json\/wp\/v2\/posts\/185\/revisions"}],"predecessor-version":[{"id":186,"href":"https:\/\/www.beer.org\/blog\/index.php\/wp-json\/wp\/v2\/posts\/185\/revisions\/186"}],"wp:attachment":[{"href":"https:\/\/www.beer.org\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.beer.org\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.beer.org\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}