(solved) MySQL 5.0.44-r1 just stopped working.

[StifflerStealth]

The lost time I had compiled MySQL was: Thu Sep 6 05:34:58 2007 and all this time it was working fine. Then today I noticed that I could not login to MySQL to add a table, so I restarted MySQL, but I get this error:

[tranquilcool]

try;

1) check permissions on /var/lib/mysql
shoud be mysql:mysql

2) check /var/run/mysqld to see if
any mysqld.pid is hanging around. remove it if it is.

3) do;
/etc/init.d/mysql zap

then try

4) /etc/init.d/mysql start

hope it helps!
_________________
this is a strange strange world.

[StifflerStealth]

No go. My problem is a little more complex than a left over pid file. I tried starting it manually with:
~ # mysqld_safe --datadir /var/lib/mysql --verbose --user=mysql
nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
071112 08:38:25 mysqld ended

But, as you can tell that did not work either. Is there any way I can back up my databases without actually having mysql running? Like convert them all to sql files and then uninstall mysql, remove everything as if I never had it installed, then recreate the users I had and import the databases? What all would I need to manually remove?

[StifflerStealth]

I reinstalled it I think. I need to test if it works now. I fif a find / -name *mysql* and removed anything that looked like to belonged to mysql.

EDIT: It finally starts after re-running the install db script thing.

I saved all my databases to a different directory. Can I just copy them over to the database directory and MySQL will use them?

EDIT 2: I moved the folders over to the database directory. I can see the databases in Webmin, but when I try to access them, I get:
SQL show index from `ART` failed : Can't find file: './artgallery/ART.frm' (errno: 13)

How do I make my copied over databases usable again?

[tranquilcool]

don't know how i can help.
you did so many wrong things at the same time.

for backups and restore with mysql, it's safe to use
mysqldump or mysqlhotcopy for MyISAM tables.

check man mysqldump. i say this so you know for another time or maybe mysqldump
can still help.
_________________
this is a strange strange world.

[StifflerStealth]

Well, in order to use mysqldump, you need to have mysql started. I already tried to use mysql dump.

And I got it working. I had to chown the directories that copied over to mysql:mysql and then the databases started to work again. I just had to add my users back in and set their permissions, but all is go now. I think what happened was that the mysql database got corrupted. So, after removing mysql, deleting all associated remaining files, then reinstalling it, running the install db program to get a new clean mysql directory, and then copying over my other DBs it works now.

[tranquilcool]

am happy you had the problems solved.

that's why i love linux.
_________________
this is a strange strange world.