Page 1 of 1

How I can recover the databases and events?

Posted: Tue Jul 10, 2012 3:58 pm
by mvalenzuela
I'm migrating from CentOS 5.x to CentOS6.x and Zoneminder from v1.24 to 1.25 zm in different machines. This is installed and works fine on yours respects version, but now I need migrate the databases, events and images.

How I can recover the databases and events?

Best regards from Chile.
Old server
[root@camaras zoneminder]#
[root@camaras zoneminder]# rpm -qa |grep mysql
mysql-5.0.77-4.el5_5.3
php-mysql-5.1.6-27.el5
mysql-server-5.0.77-4.el5_5.3
[root@camaras zoneminder]# rpm -qa |grep httpd
httpd-manual-2.2.3-43.el5.centos.3
system-config-httpd-1.3.3.3-1.el5
httpd-2.2.3-43.el5.centos.3
[root@camaras zoneminder]# rpm -qa |grep zoneminder
zoneminder-1.24.2-3.4.el5.al
[root@camaras zoneminder]#
------------------------------------------------------

New server
[root@zminder httpd]# rpm -q mysql
mysql-5.1.61-1.el6_2.1.x86_64
[root@zminder httpd]# rpm -qa|grep mysql
mysql-5.1.61-1.el6_2.1.x86_64
mysql-server-5.1.61-1.el6_2.1.x86_64
php-mysql-5.3.3-3.el6_2.8.x86_64
mysql-devel-5.1.61-1.el6_2.1.x86_64
mysql-libs-5.1.61-1.el6_2.1.x86_64
[root@zminder httpd]# rpm -qa|grep httpd
httpd-tools-2.2.15-15.el6.centos.1.x86_64
httpd-2.2.15-15.el6.centos.1.x86_64

Re: How I can recover the databases and events?

Posted: Wed Jul 11, 2012 2:41 am
by skyking
I have a suggestion.
I fired up my new server and configured it, and migrated the cameras over. Once I had all the cams running, I kept the old server online to view old events if needed. After a few weeks it was deemed no longer necessary. I took down the old server and never looked back.
You can back up the DB either from command line or with phpmyadmin. Just remember to shut it down when you are done, it is a bit of a security risk.