Is it possible to reboot mySQL? It's goten very slow.

From a shell, as root, issue "service mysql restart" (you might need to use mysqld).

I think an alternative way should be from the CP by stopping and starting MySQL - but it's been to long since I used Raq to remember.

::::From a shell, as root, issue "service mysql restart" (you might need to use mysqld).

Is a shell the same thing as Telnet?

Any tips for keeping MySQL from doing that or crashing the server? My server has to be rebooted about once a month (It was atleast once a week before geting a RAM upgrade.)

Yeah, telnet would normally give you a shell. SSH is better though, search for it here.

If MySQL crashes regularly for you due to load perhaps you ought to get some more powerful hardware - and servers are prolly never gonna get cheaper than now. Alternatively make a cron entry that restarts mysql daily or weekly as needed to keep it floatin'

/etc/rc.d/init.d/mysql restart

I tried to back-up MySQL first but got this message.


[root admin]# mysqldump -uroot -p***** ****** > /home/sites/www.******.com/web
/back-ups/9-2-02.sql
mysqldump: Out of memory (Needed 8164 bytes)
mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server