Re: [SLE] I HAD IT WORKING! MySQL under SuSE 9.0 Woes
From: Mark Seven Smith (pampaluz_at_cox.net)
To: <email@example.com> Date: Tue, 13 Apr 2004 21:55:53 -0700
On Tuesday 13 April 2004 21:04, Anders Johansson typed:
> On Wednesday 14 April 2004 05.55, Mark Seven Smith wrote:
> > So far, it will NOT run. Yet, I was able to do this, just the other day,
> > and it DID RUN. Yet I haven't changed anything that I can remember...
> You ran mysqld directly as root, but with incorrect parameters. This failed
> to start mysql but it did succeed in changing the ownership of some
> important files.
> chown -R mysql.daemon /var/lib/mysql
> followed by "rcmysql start" and see if that helps
AAAAGH! *MAN*, I was hoping that would work...it sounded so *logical*!
Here's the result:
linux:/home/markvii # chown -R mysql.daemon /var/lib/mysql
linux:/home/markvii # rcmysql start
Starting service MySQL
Here's what my directory looks like now: (I showed what it looked like with
this command before, in the previous Email):
linux:/home/markvii # ls -lia /var/lib/mysql
234907 drwxr-xr-x 4 mysql daemon 488 2004-04-13 21:41 .
23 drwxr-xr-x 41 root root 1072 2004-04-13 04:31 ..
246711 -rw-rw---- 1 mysql daemon 25088 2004-03-28 18:13
246708 -rw-rw---- 1 mysql daemon 10485760 2004-04-10 09:26 ibdata1
246709 -rw-rw---- 1 mysql daemon 5242880 2004-04-10 09:26
246710 -rw-rw---- 1 mysql daemon 5242880 2004-03-28 18:13
98547 -rw-rw---- 1 mysql daemon 3200 2004-04-13 21:41
238969 drwx------ 2 mysql daemon 528 2004-03-28 18:13 mysql
262556 -rw-rw---- 1 mysql daemon 1347 2004-04-13 21:41 mysqld.log
262521 -rw-rw---- 1 mysql daemon 194 2004-04-08 03:27
262568 -rw-rw---- 1 mysql daemon 188 2004-04-08 12:14
251154 -rw-rw---- 1 mysql daemon 477 2004-04-11 01:37
247414 -rw-rw---- 1 mysql daemon 358 2004-04-12 11:33
247391 -rw-rw---- 1 mysql daemon 491 2004-04-13 01:19
238970 drwx------ 2 mysql daemon 48 2004-03-28 18:13 test
Everything's now the same owner and group. But it doesn't help. There must
be something simple being overlooked; but I go through everything I can find;
the SUSE manuals for MySQL, everything, but I cannot figure it out. There is
a page about troubleshooting; but it doesn't have anything very much to do
with things at this point--everything it suggests has been tried.
This is so *FRUSTRATING*!!!
Any ideas on what to do next? Pay SuSE for help? Wait for the SuSE 9.2 (or
whatever) to come out? Just abandon all the work I've done, and re-install
the entire system (I don't have a way to really back things up...) Or
perhaps just toss the notebook computer into the swamp (if San Diego has a
swamp) and become a TV vegetable? ;-) Where should I go next? I'd like to
take some courses in Computer Science so that I can understand what's "going
on underneath the hood" so to speak (as if the computer is a car), but I
can't get out and about; my health is too poor.
If I understood the kernel better, it seems to me that I would be able to
fathom why such problems come up. Who would know enough about Linux to be
able to say what's going on with my weird problems? I am probably going to
un-install all the MySQL and php and Apache stuff and wipe the /var/lib/mysql
directory out one more time; but then, if this happens again, I don't know
what I will do. I just hate the idea of having to be stuck using vi to
catalog all my books...I won't be able to do the things that I am trying to
accomplish by using a relational, SQL-type database. Maybe PostgreSQL? But
that'll be even worse, trying to start learning all over again...<sigh!>
-- Check the headers for your unsubscription address For additional commands send e-mail to firstname.lastname@example.org Also check the archives at http://lists.suse.com Please read the FAQs: email@example.com