I have an old PC, (Pentium III) running Ubuntu 8.04 and whose main
purpose is to run Zoneminder. It has worked almost flawlessly, with an occasional need to repair the mysql databases. 'Occasional' means two
or three times in about 12 years.
Last month, there was a power cut during a storm, and since then, the database hasn't worked. Zoneminder operates in real time, but nothing is recorded by the database, and the usual mysql repair instructions
appear to work fine, but nothing changes. When I look at a Monitor's
event listing, it shows hundreds of event records with their date and
time stamps, but with no data, as though the index is good but there is information available beyond. I can Force a fault, but I cannot cancel
it, and it does not appear in the events listing.
I am by no means an mysql programmer; when installing the Zoneminder,
back in 2010, I followed a script written by somebody who had done it
before. He is now dead, so I can't ask him for help. I have tried
researching mysql problems, but the responses all talk a language way
above my pay grade, and I have not found one answer that appears to
reference what I have. The nearest refer to recreating an old database.
I am not worried about recreating old data, I just want to restore the
full operation of Zoneminder. A new blank database using the existing Monitors would be just fine. I can describe to anybody who can help
what files I have and where they are.
Any help much appreciated, at a programming level that I can follow.
Davey <davey@example.invalid> wrote:
I have an old PC, (Pentium III) running Ubuntu 8.04 and whose main
purpose is to run Zoneminder. It has worked almost flawlessly, with
an occasional need to repair the mysql databases. 'Occasional'
means two or three times in about 12 years.
Last month, there was a power cut during a storm, and since then,
the database hasn't worked. Zoneminder operates in real time, but
nothing is recorded by the database, and the usual mysql repair instructions appear to work fine, but nothing changes. When I look
at a Monitor's event listing, it shows hundreds of event records
with their date and time stamps, but with no data, as though the
index is good but there is information available beyond. I can
Force a fault, but I cannot cancel it, and it does not appear in
the events listing. I am by no means an mysql programmer; when
installing the Zoneminder, back in 2010, I followed a script
written by somebody who had done it before. He is now dead, so I
can't ask him for help. I have tried researching mysql problems,
but the responses all talk a language way above my pay grade, and I
have not found one answer that appears to reference what I have.
The nearest refer to recreating an old database. I am not worried
about recreating old data, I just want to restore the full
operation of Zoneminder. A new blank database using the existing
Monitors would be just fine. I can describe to anybody who can
help what files I have and where they are.
Any help much appreciated, at a programming level that I can follow.It's pretty quiet here on Usenet nowadays, most people seem to have
emigrated elsewhere.
I *might* be able to help, I'm a long-term Linux user and I can work
with simple database issues (though I mostly use sqlite rather than
mysql).
I'm happy to continue here (i.e. on the newsgroup) or you can E-Mail
me direct with more information. My E-Mail address here will work.
Any help much appreciated, at a programming level that I can follow.
On 9/1/24 04:31, Davey wrote:
Any help much appreciated, at a programming level that I can
follow.
If possible I'd do a physical to virtual conversion of this system as working in a VM will make a lot of things easier -> faster.
What error messages do you have? Where are they?
Can you chase what might be causing any given error? Can you fix it?
I have an old PC, (Pentium III) running Ubuntu 8.04 and whose main
purpose is to run Zoneminder. It has worked almost flawlessly, with an occasional need to repair the mysql databases. 'Occasional' means two
or three times in about 12 years.
Last month, there was a power cut during a storm, and since then, the database hasn't worked. Zoneminder operates in real time, but nothing
is recorded by the database, and the usual mysql repair instructions
appear to work fine, but nothing changes. When I look at a Monitor's
event listing, it shows hundreds of event records with their date and
time stamps, but with no data, as though the index is good but there
is information available beyond. I can Force a fault, but I cannot
cancel it, and it does not appear in the events listing.
I am by no means an mysql programmer; when installing the Zoneminder,
back in 2010, I followed a script written by somebody who had done it
before. He is now dead, so I can't ask him for help. I have tried
researching mysql problems, but the responses all talk a language way
above my pay grade, and I have not found one answer that appears to
reference what I have. The nearest refer to recreating an old
database. I am not worried about recreating old data, I just want to
restore the full operation of Zoneminder. A new blank database using
the existing Monitors would be just fine. I can describe to anybody
who can help what files I have and where they are.
Any help much appreciated, at a programming level that I can follow.
| Sysop: | Luis Silva |
|---|---|
| Location: | Lisbon |
| Users: | 763 |
| Nodes: | 10 (0 / 10) |
| Uptime: | 179:45:27 |
| Calls: | 111 |
| Files: | 46,971 |
| Messages: | 11,214 |