MySql

[marco_186]

Dear all
i setup mysql on Ux_hp 11
but when i reboot the machine i ve to start it manual
how i can make it start when the machine rebooted
many thanks

[Michael Schulte zur Sur]

Hi,

does the machine stop at the console prompt or does it not get to multi user state?

greetings,

Michael

[Simon Hargrave]

Haven't used mysql on HPUX myself however according to the website

http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Binary_notes-HP-UX.html

on hpux the install should have created init.d and rc2.d entries for you. However it mentions /etc/init.d not /sbin/init.d so I don't know if that's a typo or a problem with the install.

I'd check for the following files: -

/sbin/init.d/mysql
/etc/init.d/mysql
/sbin/rc*.d/*mysql
/etc/rc.config.d/mysql

To see what exists.

[Muthukumar_5]

You have to setup the startup script for mysql. HP-UX it will be in /sbin/init.d/mysql and linked to all run levels in /etc/rc[0-4].d/. If you get mysql from IExpress depot, it will be included.

hth.

[Munkhbayar.B]

you have to setup startup and shotdown script manually if you got software from mysql site.

Mysql start/stop script will be included in /usr/local/mysql if you installed by default.
copy this file to start/stop script repository:
cp /usr/local/mysql/mysql.server /sbin/init.d/mysql

Then link them to start:
ln -s /sbin/init.d/mysql /sbin/rc3.d/S890mysql

link it to stop:
ln -s /sbin/init.d/mysql /sbin/rc1.d/K100mysql

now check by rebooting.

[Frank de Vries]

The automated is done by the rc* routine

You can configure a variable in
/etc/rc.config.d/mysql
MYSQLSTART=0 (no auto start)
MYSQLSTART=1 (do auto start)

Mysql start/stop script will be included in /usr/local/mysql if you installed by default.
copy this file to start/stop script repository:
cp /usr/local/mysql/mysql.server /sbin/init.d/mysql

Then link them to start:
ln -s
/sbin/init.d/mysql /sbin/rc3.d/Sxxxmysql
(The xxx denotes a sequence number , the order in which it starts)

link it to stop:
ln -s
/sbin/init.d/mysql /sbin/rc2.d/Kxxxmysql
(I would start it at runlevel 2 or 3°
Runlevel 1 is reserved for hardware like
networkcard etc..

now check first by running the script
/sbin/init.d/mysql start
/sbin/init.d/mysql stop
and then by rebooting