ok, i managed to get my cwp back together..
i will share with you what i can (and remember correctly):
i did this: (i made it into a script though) but you can do it line-by-line i guess.
Fix for MySQL “Unable to lock ibdata1” error
/etc/init.d/mysql stop
mv /var/lib/mysql/ibdata1 /var/lib/mysql/ibdata1.bak &
mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak &
mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak &
cp -a /var/lib/mysql/ibdata1.bak /var/lib/mysql/ibdata1 &
cp -a /var/lib/mysql/ib_logfile0.bak /var/lib/mysql/ib_logfile0 &
cp -a /var/lib/mysql/ib_logfile1.bak /var/lib/mysql/ib_logfile1 &
/etc/init.d/mysql restart
more or less, its just "refreshing" the files, obviously.
weird thing is, i had done this very similar before, just not all at once.
but, its working now..
i also used this PRIOR to running the above commands:
resetting the mysql*root password: this one worked.
some reason, again?, some variants of these don't work. it seemed.
but this has:
https://support.rackspace.com/how-to/mysql-resetting-a-lost-mysql-root-password/----------
Notes:
after running the above script/commands
it didnt seem to work straight away..
over the days time i would check it, and it wouldnt (on CWP Panel) restart.
i sat down now, and killed all mysql processes (killall mysql, and killall msqld)
some reason at times i would kill -9 process ID, etc, but it would still say
I had another process running mysqld, and *that* (i think) has been the problem all along.
maybe its reporting a false process/positive? i dont know, i had rebooted, started/stopped/disabled, the whole routine.
maybe a weird 'glitch' in killing/unloading the MYSQL process.. anyways, the above method has worked, for me at least.
Really hope it helps someone else too.
I'm keeping this in my "NOTES" on CWP for future reference.. LOL
What a pain.
Cheers.
X
Topic: MySQL Server wont start.. (Read 26464 times)
