I have an old Dell PC, that I have used for many years to run a
Zoneminder installation. The PC runs Ubuntu 8.04LTS, Zoneminder is
v1.22.3.
It has worked pretty flawlessly for years, but suddenly I have been
getting the dreaded "Table './zm/Frames' is marked as crashed and
should be repaired" error message when trying to access any records. I
have gone round and round in the Zoneminder Forums, in which this is frequently discussed, but I cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered to be the correct
thing to do. If I try to navigate to:
</var/lib/mysql/zm>, as instructed, I get 'Permission denied', and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again, but I can't cross
this final hurdle.
Any help welcome.
On 2024-01-08, Davey <davey@example.invalid> wrote:
I have an old Dell PC, that I have used for many years to run a
Zoneminder installation. The PC runs Ubuntu 8.04LTS, Zoneminder is
v1.22.3.
It has worked pretty flawlessly for years, but suddenly I have been
getting the dreaded "Table './zm/Frames' is marked as crashed and
should be repaired" error message when trying to access any
records. I have gone round and round in the Zoneminder Forums, in
which this is frequently discussed, but I cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered to be the correct
thing to do. If I try to navigate to:
</var/lib/mysql/zm>, as instructed, I get 'Permission denied', and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again, but I can't
cross this final hurdle.
Any help welcome.
What is the error when using the sudo command?
On Mon, 8 Jan 2024 16:12:12 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
I have an old Dell PC, that I have used for many years to run aWhat is the error when using the sudo command?
Zoneminder installation. The PC runs Ubuntu 8.04LTS, Zoneminder is
v1.22.3.
It has worked pretty flawlessly for years, but suddenly I have been
getting the dreaded "Table './zm/Frames' is marked as crashed and
should be repaired" error message when trying to access any
records. I have gone round and round in the Zoneminder Forums, in
which this is frequently discussed, but I cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered to be the correct
thing to do. If I try to navigate to:
</var/lib/mysql/zm>, as instructed, I get 'Permission denied', and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again, but I can't
cross this final hurdle.
Any help welcome.
sudo: cd: command not found
Davey <davey@example.invalid> writes:
On Mon, 8 Jan 2024 16:12:12 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
I have an old Dell PC, that I have used for many years to run aWhat is the error when using the sudo command?
Zoneminder installation. The PC runs Ubuntu 8.04LTS, Zoneminder
is v1.22.3.
It has worked pretty flawlessly for years, but suddenly I have
been getting the dreaded "Table './zm/Frames' is marked as
crashed and should be repaired" error message when trying to
access any records. I have gone round and round in the
Zoneminder Forums, in which this is frequently discussed, but I
cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered to be the
correct thing to do. If I try to navigate to:
</var/lib/mysql/zm>, as instructed, I get 'Permission denied',
and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again, but I can't
cross this final hurdle.
Any help welcome.
sudo: cd: command not found
On Debian, sudo is a package, and possibly not installed by default.
i A sudo - Provide limited super user privileges to specific users
So you could try apt install sudo, but you need to be root for
that. :)
su - root
To switch to the root user.
On Mon, 8 Jan 2024 16:12:12 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
I have an old Dell PC, that I have used for many years to run aWhat is the error when using the sudo command?
Zoneminder installation. The PC runs Ubuntu 8.04LTS, Zoneminder is
v1.22.3.
It has worked pretty flawlessly for years, but suddenly I have been
getting the dreaded "Table './zm/Frames' is marked as crashed and
should be repaired" error message when trying to access any
records. I have gone round and round in the Zoneminder Forums, in
which this is frequently discussed, but I cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered to be the correct
thing to do. If I try to navigate to:
</var/lib/mysql/zm>, as instructed, I get 'Permission denied', and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again, but I can't
cross this final hurdle.
Any help welcome.
sudo: cd: command not found
On 2024-01-08, Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 16:12:12 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
I have an old Dell PC, that I have used for many years to run aWhat is the error when using the sudo command?
Zoneminder installation. The PC runs Ubuntu 8.04LTS, Zoneminder
is v1.22.3.
It has worked pretty flawlessly for years, but suddenly I have
been getting the dreaded "Table './zm/Frames' is marked as
crashed and should be repaired" error message when trying to
access any records. I have gone round and round in the
Zoneminder Forums, in which this is frequently discussed, but I
cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered to be the
correct thing to do. If I try to navigate to:
</var/lib/mysql/zm>, as instructed, I get 'Permission denied',
and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again, but I can't
cross this final hurdle.
Any help welcome.
sudo: cd: command not found
So try sudo su
and then run the command from there.
On Mon, 8 Jan 2024 17:47:52 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 16:12:12 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
I have an old Dell PC, that I have used for many years to run aWhat is the error when using the sudo command?
Zoneminder installation. The PC runs Ubuntu 8.04LTS, Zoneminder
is v1.22.3.
It has worked pretty flawlessly for years, but suddenly I have
been getting the dreaded "Table './zm/Frames' is marked as
crashed and should be repaired" error message when trying to
access any records. I have gone round and round in the
Zoneminder Forums, in which this is frequently discussed, but I
cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered to be the
correct thing to do. If I try to navigate to:
</var/lib/mysql/zm>, as instructed, I get 'Permission denied',
and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again, but I can't
cross this final hurdle.
Any help welcome.
sudo: cd: command not found
So try sudo su
and then run the command from there.
Well, it let me get into root, and all the way to /var/lib/mysql/zm.
So I entered the mysqlcheck command:
root@david-desktop:/var/lib/mysql/zm# mysqlcheck --all-databases --auto-repair
mysqlcheck: Got error: 1045: Access denied for user
'root'@'localhost' (using password: NO) when trying to connect.
Grrr.
Davey <davey@example.invalid> writes:
On Mon, 8 Jan 2024 16:12:12 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
I have an old Dell PC, that I have used for many years to run aWhat is the error when using the sudo command?
Zoneminder installation. The PC runs Ubuntu 8.04LTS, Zoneminder is
v1.22.3.
It has worked pretty flawlessly for years, but suddenly I have been
getting the dreaded "Table './zm/Frames' is marked as crashed and
should be repaired" error message when trying to access any
records. I have gone round and round in the Zoneminder Forums, in
which this is frequently discussed, but I cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered to be the correct
thing to do. If I try to navigate to:
</var/lib/mysql/zm>, as instructed, I get 'Permission denied', and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again, but I can't
cross this final hurdle.
Any help welcome.
sudo: cd: command not found
On Debian, sudo is a package, and possibly not installed by default.
i A sudo - Provide limited super user privileges to specific users
So you could try apt install sudo, but you need to be root for that. :)
su - root
To switch to the root user.
On 2024-01-08, Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 17:47:52 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 16:12:12 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
I have an old Dell PC, that I have used for many years to runWhat is the error when using the sudo command?
a Zoneminder installation. The PC runs Ubuntu 8.04LTS,
Zoneminder is v1.22.3.
It has worked pretty flawlessly for years, but suddenly I have
been getting the dreaded "Table './zm/Frames' is marked as
crashed and should be repaired" error message when trying to
access any records. I have gone round and round in the
Zoneminder Forums, in which this is frequently discussed, but
I cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered to be the
correct thing to do. If I try to navigate to:
</var/lib/mysql/zm>, as instructed, I get 'Permission denied',
and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again, but I
can't cross this final hurdle.
Any help welcome.
sudo: cd: command not found
So try sudo su
and then run the command from there.
Well, it let me get into root, and all the way to /var/lib/mysql/zm.
So I entered the mysqlcheck command:
root@david-desktop:/var/lib/mysql/zm# mysqlcheck --all-databases --auto-repair
mysqlcheck: Got error: 1045: Access denied for user
'root'@'localhost' (using password: NO) when trying to connect.
Grrr.
You need to run as a user with mysql access, eg. mysql -u root -p and
give a new password.
On Mon, 8 Jan 2024 20:06:53 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 17:47:52 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 16:12:12 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
I have an old Dell PC, that I have used for many years toWhat is the error when using the sudo command?
run a Zoneminder installation. The PC runs Ubuntu 8.04LTS,
Zoneminder is v1.22.3.
It has worked pretty flawlessly for years, but suddenly I
have been getting the dreaded "Table './zm/Frames' is
marked as crashed and should be repaired" error message
when trying to access any records. I have gone round and
round in the Zoneminder Forums, in which this is frequently
discussed, but I cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered to be the
correct thing to do. If I try to navigate to:
</var/lib/mysql/zm>, as instructed, I get 'Permission
denied', and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again, but I
can't cross this final hurdle.
Any help welcome.
sudo: cd: command not found
So try sudo su
and then run the command from there.
Well, it let me get into root, and all the way
to /var/lib/mysql/zm. So I entered the mysqlcheck command: root@david-desktop:/var/lib/mysql/zm# mysqlcheck --all-databases --auto-repair
mysqlcheck: Got error: 1045: Access denied for user
'root'@'localhost' (using password: NO) when trying to connect.
Grrr.
You need to run as a user with mysql access, eg. mysql -u root -p
and give a new password.
It let me get into mysql, thank you very much. And I have entered the database autorepair command, and it is sitting there doing something, although I don't know what. Hopefully, it will eventually decide that
it has worked. All fingers crossed. The cursor flashes for a while,
then goes still, then flashes again.
On Tue, 9 Jan 2024 11:23:35 +0000
Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 20:06:53 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 17:47:52 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 16:12:12 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
I have an old Dell PC, that I have used for many years toWhat is the error when using the sudo command?
run a Zoneminder installation. The PC runs Ubuntu 8.04LTS,
Zoneminder is v1.22.3.
It has worked pretty flawlessly for years, but suddenly I
have been getting the dreaded "Table './zm/Frames' is
marked as crashed and should be repaired" error message
when trying to access any records. I have gone round and
round in the Zoneminder Forums, in which this is
frequently discussed, but I cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered to be
the correct thing to do. If I try to navigate to:
</var/lib/mysql/zm>, as instructed, I get 'Permission
denied', and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again, but
I can't cross this final hurdle.
Any help welcome.
sudo: cd: command not found
So try sudo su
and then run the command from there.
Well, it let me get into root, and all the way
to /var/lib/mysql/zm. So I entered the mysqlcheck command: root@david-desktop:/var/lib/mysql/zm# mysqlcheck --all-databases --auto-repair
mysqlcheck: Got error: 1045: Access denied for user
'root'@'localhost' (using password: NO) when trying to connect.
Grrr.
You need to run as a user with mysql access, eg. mysql -u root -p
and give a new password.
It let me get into mysql, thank you very much. And I have entered
the database autorepair command, and it is sitting there doing
something, although I don't know what. Hopefully, it will
eventually decide that it has worked. All fingers crossed. The
cursor flashes for a while, then goes still, then flashes again.
After more than 2 hours, there was no change, so I terminated it. It complained about a broken pipe, so maybe it was still working. I'll
try it again later, maybe with a verbose option, to see if that does anything.
On Tue, 9 Jan 2024 13:52:43 +0000
Davey <davey@example.invalid> wrote:
On Tue, 9 Jan 2024 11:23:35 +0000
Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 20:06:53 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 17:47:52 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 16:12:12 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid>
wrote:
I have an old Dell PC, that I have used for many yearsWhat is the error when using the sudo command?
to run a Zoneminder installation. The PC runs Ubuntu
8.04LTS, Zoneminder is v1.22.3.
It has worked pretty flawlessly for years, but suddenly
I have been getting the dreaded "Table './zm/Frames' is
marked as crashed and should be repaired" error message
when trying to access any records. I have gone round and
round in the Zoneminder Forums, in which this is
frequently discussed, but I cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered to be
the correct thing to do. If I try to navigate to:
</var/lib/mysql/zm>, as instructed, I get 'Permission
denied', and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again,
but I can't cross this final hurdle.
Any help welcome.
sudo: cd: command not found
So try sudo su
and then run the command from there.
Well, it let me get into root, and all the way
to /var/lib/mysql/zm. So I entered the mysqlcheck command: root@david-desktop:/var/lib/mysql/zm# mysqlcheck
--all-databases --auto-repair
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to
connect.
Grrr.
You need to run as a user with mysql access, eg. mysql -u root
-p and give a new password.
It let me get into mysql, thank you very much. And I have entered
the database autorepair command, and it is sitting there doing
something, although I don't know what. Hopefully, it will
eventually decide that it has worked. All fingers crossed. The
cursor flashes for a while, then goes still, then flashes again.
After more than 2 hours, there was no change, so I terminated it. It complained about a broken pipe, so maybe it was still working. I'll
try it again later, maybe with a verbose option, to see if that does anything.
Well, that seems to be stuck, however ling I leave it. I tried the
mysqlcheck instruction with --verbose on the end, but it said nothing.
it seems to be doing something, but I don't know what, it's not
telling me, it never ends, but it complains 'aborted' if I stop it.
Most puzzling.
I think I'll sleep on it, and try again tomorrow.
How can I tell if it's actually doing anything? I started the same
process this morning, and again it seems to start the mysqlcheck
process without complaint. There is a '>' followed by a flashing cursor, which sometimes stops flashing, and then starts again. If I stop it with Cntrl-C, it tells me 'aborted'. But there is no other sign of progress,
it doesn't argue with the --verbose option, but it doesn't report
anything either. I am most puzzled. I'll let it run for 24 hours, that
really should be enough, even for a slow PC.
Davey <davey@example.invalid> wrote:
How can I tell if it's actually doing anything? I started the same
process this morning, and again it seems to start the mysqlcheck
process without complaint. There is a '>' followed by a flashing
cursor, which sometimes stops flashing, and then starts again. If I
stop it with Cntrl-C, it tells me 'aborted'. But there is no other
sign of progress, it doesn't argue with the --verbose option, but
it doesn't report anything either. I am most puzzled. I'll let it
run for 24 hours, that really should be enough, even for a slow
PC.
'top' will tell you if it's using CPU.
'strace' will tell you what syscalls it's making, best logged to a
file eg:
strace -f -tt -o file.log mysqladmin --whatever
-f logs all the child processes as well, and -tt timestamps each one
with microseconds.
Interpreting the strace log is a bit of a skill, but just looking at
the timestamps will tell you if it's in a loop doing something, or
stuck waiting for something which never happens.
However I suspect your bigger problem will be that you need to install
strace and the package repos are long gone. It seems like the
archives are at:
http://old-releases.ubuntu.com/ubuntu/
and you can replace 'archive.ubuntu.com' with
'old-releases.ubuntu.com' in your /etc/apt/sources.list and then
apt-get update to fetch them.
Theo
On Tue, 9 Jan 2024 19:08:43 +0000
Davey <davey@example.invalid> wrote:
On Tue, 9 Jan 2024 13:52:43 +0000
Davey <davey@example.invalid> wrote:
On Tue, 9 Jan 2024 11:23:35 +0000
Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 20:06:53 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 17:47:52 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 16:12:12 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid>
wrote:
I have an old Dell PC, that I have used for many yearsWhat is the error when using the sudo command?
to run a Zoneminder installation. The PC runs Ubuntu
8.04LTS, Zoneminder is v1.22.3.
It has worked pretty flawlessly for years, but suddenly
I have been getting the dreaded "Table './zm/Frames' is
marked as crashed and should be repaired" error message
when trying to access any records. I have gone round and
round in the Zoneminder Forums, in which this is
frequently discussed, but I cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered to be
the correct thing to do. If I try to navigate to:
</var/lib/mysql/zm>, as instructed, I get 'Permission
denied', and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again,
but I can't cross this final hurdle.
Any help welcome.
sudo: cd: command not found
So try sudo su
and then run the command from there.
Well, it let me get into root, and all the way
to /var/lib/mysql/zm. So I entered the mysqlcheck command:
root@david-desktop:/var/lib/mysql/zm# mysqlcheck
--all-databases --auto-repair
mysqlcheck: Got error: 1045: Access denied for user
'root'@'localhost' (using password: NO) when trying to
connect.
Grrr.
You need to run as a user with mysql access, eg. mysql -u root
-p and give a new password.
It let me get into mysql, thank you very much. And I have entered
the database autorepair command, and it is sitting there doing
something, although I don't know what. Hopefully, it will
eventually decide that it has worked. All fingers crossed. The
cursor flashes for a while, then goes still, then flashes again.
After more than 2 hours, there was no change, so I terminated it. It
complained about a broken pipe, so maybe it was still working. I'll
try it again later, maybe with a verbose option, to see if that does
anything.
Well, that seems to be stuck, however ling I leave it. I tried the
mysqlcheck instruction with --verbose on the end, but it said nothing.
it seems to be doing something, but I don't know what, it's not
telling me, it never ends, but it complains 'aborted' if I stop it.
Most puzzling.
I think I'll sleep on it, and try again tomorrow.
How can I tell if it's actually doing anything? I started the same
process this morning, and again it seems to start the mysqlcheck
process without complaint. There is a '>' followed by a flashing cursor, which sometimes stops flashing, and then starts again. If I stop it with Cntrl-C, it tells me 'aborted'. But there is no other sign of progress,
it doesn't argue with the --verbose option, but it doesn't report
anything either. I am most puzzled. I'll let it run for 24 hours, that
really should be enough, even for a slow PC.
Again, any help most welcome.
On 2024-01-10, Davey <davey@example.invalid> wrote:
On Tue, 9 Jan 2024 19:08:43 +0000
Davey <davey@example.invalid> wrote:
On Tue, 9 Jan 2024 13:52:43 +0000
Davey <davey@example.invalid> wrote:
On Tue, 9 Jan 2024 11:23:35 +0000
Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 20:06:53 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid> wrote:
On Mon, 8 Jan 2024 17:47:52 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid>
wrote:
On Mon, 8 Jan 2024 16:12:12 -0000 (UTC)
Simon <SimonJ@eu.invalid> wrote:
On 2024-01-08, Davey <davey@example.invalid>
wrote:
I have an old Dell PC, that I have used for manyWhat is the error when using the sudo command?
years to run a Zoneminder installation. The PC runs
Ubuntu 8.04LTS, Zoneminder is v1.22.3.
It has worked pretty flawlessly for years, but
suddenly I have been getting the dreaded "Table
'./zm/Frames' is marked as crashed and should be
repaired" error message when trying to access any
records. I have gone round and round in the
Zoneminder Forums, in which this is frequently
discussed, but I cannot get the:
<mysqlcheck --all-databases --auto-repair>
instruction to work, which is generally considered
to be the correct thing to do. If I try to navigate
to:
</var/lib/mysql/zm>, as instructed, I get 'Permission
denied', and I
cannot get beyond this. 'Sudo' doesn't work.
I feel that I am close to getting this working again,
but I can't cross this final hurdle.
Any help welcome.
sudo: cd: command not found
So try sudo su
and then run the command from there.
Well, it let me get into root, and all the way
to /var/lib/mysql/zm. So I entered the mysqlcheck command:
root@david-desktop:/var/lib/mysql/zm# mysqlcheck
--all-databases --auto-repair
mysqlcheck: Got error: 1045: Access denied for user
'root'@'localhost' (using password: NO) when trying to
connect.
Grrr.
You need to run as a user with mysql access, eg. mysql -u
root -p and give a new password.
It let me get into mysql, thank you very much. And I have
entered the database autorepair command, and it is sitting
there doing something, although I don't know what. Hopefully,
it will eventually decide that it has worked. All fingers
crossed. The cursor flashes for a while, then goes still, then
flashes again.
After more than 2 hours, there was no change, so I terminated
it. It complained about a broken pipe, so maybe it was still
working. I'll try it again later, maybe with a verbose option,
to see if that does anything.
Well, that seems to be stuck, however ling I leave it. I tried the
mysqlcheck instruction with --verbose on the end, but it said
nothing. it seems to be doing something, but I don't know what,
it's not telling me, it never ends, but it complains 'aborted' if
I stop it. Most puzzling.
I think I'll sleep on it, and try again tomorrow.
How can I tell if it's actually doing anything? I started the same
process this morning, and again it seems to start the mysqlcheck
process without complaint. There is a '>' followed by a flashing
cursor, which sometimes stops flashing, and then starts again. If I
stop it with Cntrl-C, it tells me 'aborted'. But there is no other
sign of progress, it doesn't argue with the --verbose option, but
it doesn't report anything either. I am most puzzled. I'll let it
run for 24 hours, that really should be enough, even for a slow PC.
Again, any help most welcome.
Usually the ">" denotes it is waiting for further input, I would
verify the command entered is correct and complete.
hth
Usually the ">" denotes it is waiting for further input, I would
verify the command entered is correct and complete.
Simon <SimonJ@eu.invalid> wrote:
Usually the ">" denotes it is waiting for further input, I would
verify the command entered is correct and complete.
Davey, can you paste the exact command being entered and its output
here? (you can blank out any passwords that may be visible)
mysqladmin does use > as a prompt to enter commands. In this example somebody typed 'mysqlcheck' at the mysqladmin prompt not at their
command line:
https://dba.stackexchange.com/questions/267788/how-to-check-and-repair-mysql-database-using-mysqlcheck
Simon may be right in that you're staring at a prompt and expecting
it to do something, while it's expecting *you* to do something.
Theo
Simon wrote:
Usually the ">" denotes it is waiting for further input, I would
verify the command entered is correct and complete.
That matches what I am seeing. I just wish it would tell me what it
needs.
Simon <SimonJ@eu.invalid> wrote:IT WORKS!!
Usually the ">" denotes it is waiting for further input, I would
verify the command entered is correct and complete.
Davey, can you paste the exact command being entered and its output
here? (you can blank out any passwords that may be visible)
mysqladmin does use > as a prompt to enter commands. In this example somebody typed 'mysqlcheck' at the mysqladmin prompt not at their
command line:
https://dba.stackexchange.com/questions/267788/how-to-check-and-repair-mysql-database-using-mysqlcheck
Simon may be right in that you're staring at a prompt and expecting
it to do something, while it's expecting *you* to do something.
Theo
After it had finished, I Stopped Zoneminder running, and repeated the process. And everything came back as OK. A final check, I brought up a camera, initiated a Forced Alarm, and it finally worked.
Many, many thanks to those who have helped me.
Hope you've blocked internet access for Ubuntu 8.04LTS, that is a bit
old....
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 300 |
Nodes: | 16 (2 / 14) |
Uptime: | 21:54:28 |
Calls: | 6,707 |
Calls today: | 1 |
Files: | 12,239 |
Messages: | 5,351,987 |