Can't Stop MySQL

can't stop mysql after i update my php and mysql

[tpatek]

Hey Everybody!

Last night I installed MySQL 4.1 and PHP 4.1 and Zend from MySQL 3.23 and PHP 4.0.

So, I editted /etc/my.cnf and since then, I haven't been able to Stop MySQL. I just get the message [FAILED] MySQL start DOES work though.

So I reverted back to my old my.cnf and it still doesn't work. My old my.cnf looks like this

[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=230
set-variable = max_connect_errors=10000
set-variable = wait_timeout=30
set-variable = interactive_timeout=30
set-variable = thread_cache=30
set-variable = back_log=100
skip-locking
skip-name-resolve

And my new one looks like this

[mysqld]
safe-show-database
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
thread_concurrency=4
max_connections=400
key_buffer=200M
myisam_sort_buffer_size=64M
join_buffer_size=1M
read_buffer_size=1M
sort_buffer_size=1M
table_cache = 1500
thread_cache_size = 128
wait_timeout = 14400
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb
skip-locking
skip-name-resolve

[mysql.server]
user=mysql

[mysqld_safe]
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16Ma

[mysqlhotcopy]
interactive-timeout

Any help would be great, and also, my website doesn't work with the newer my.cnf :( ... So frustrating.

you can look at my mysql stats at videocodesfree dot com/mysql.php, I don't know if those stats will help at all.

Any Help is Greatly Appreciated!

[Frank_Rizzo]

I seem to remember that when changing from 3 to 4 the script may have changed to mysqld i.e. you need to run /etc/init.d/mysqld stop

Run this and see what's running:

ps aux ¦ grep mysql

Another reason could be due to the lock file. You did reboot after the upgrade?

[tpatek]

I have been using mysqld, and I did reboot after the install, but havent been able to stop mysql since.
what option should i put after ps aux ¦ grep mysql?

thanks for the quick response

[Frank_Rizzo]

It looks as if you have a mix up with the scripts. Check your init.d dirs or control panel to see what is set to run at start up.

ps aux ¦ grep mysql

just type in and hit enter. It will show you if any mysql stuff is running.

[tpatek]

here is what happens when i type that in

ERROR: Garbage option.
********* simple selection ********* ********* selection by list *********
-A all processes -C by command name
-N negate selection -G by real group ID (supports names)
-a all w/ tty except session leaders -U by real user ID (supports names)
-d all except session leaders -g by session leader OR by group name
-e all processes -p by process ID
T all processes on this terminal -s processes in the sessions given
a all w/ tty, including other users -t by tty
g all, even group leaders! -u by effective user ID (supports names)
r only running processes U processes for specified users
x processes w/o controlling ttys t by tty
*********** output format ********** *********** long options ***********
-o,o user-defined -f full --Group --User --pid --cols --ppid
-j,j job control s signal --group --user --sid --rows
-O,O preloaded -o v virtual memory --cumulative --format --deselect
-l,l long u user-oriented --sort --tty --forest --version
-F extra full X registers --heading --no-heading --context
********* misc options *********
-V,V show version L list format codes f ASCII art forest
-m,m,-L,-T,H threads S children in sum -y change -l format
-c scheduling class c true command name n numeric WCHAN,UID
-w,w wide output e show environment -H process hierarchy

i think the problem lies in the my.cnf file, my site and mysql are working, its just that i cant stop the mysql and i always have been able to