How to auto start my sql server upon reboot?

john_d13 · 01-17-2006, 09:02 AM

yeye its a nub question but ive tried rc.d local and all but it doesent work.

anyone know?

chess · 01-17-2006, 09:12 AM

In Slackware, all the boot init scripts are in /etc/rc.d so just go in there and chmod +x the rc.mysqld script and mysql will start on boot. To start it immediately, just do "/etc/rc.d/rc.mysqld start"

dipenchaudhary · 01-17-2006, 10:01 AM

solution 1:
maybe u can try this command on console
chkconfig mysqld on

solution 2:
or u will have to go init way
go n see if mysqld script is present in
/etc/rc.d/init.d/
if its present which shud be ... then u have to check ur init level in most cases it shud be default to 5 if ur using Xserver .. still check it
by typing

vi /etc/inittab

here u locate this line

id:5:initdefault:

see wot this number is ... and then search for rcX.d directory where X is that number
make a link there to this script in init.d by typing

cd /etc/rc.d/rcX.d
ln -s /etc/rc.d/init.d/mysqld S67mysql

here capital S will make init script to know .. that it has to start this at boot .. and 67 shud work .. i think u can take any number .. it just tells relative position of its start at boot time

solution 3:
u can add this line to rc.local
if ur distro is red hat based then it shud be in /etc/rc.d/rc.local
the line to be added is:

service mysqld start

if nothing works .. post back ... and yehh relative positioning of files may be diff in ur distro ... sont know never used any other linux distro

phil.d.g · 01-17-2006, 10:41 AM

dipenchaudhary, Slackware doesn't use the init system you are talking about, what you have said is meaningless on Slackware, I'm afraid. Post 2 outlines the correct procedure.

dipenchaudhary · 01-17-2006, 11:24 AM

hmmm good then ignore everything ...

john_d13 · 01-17-2006, 01:46 PM

lol u guys r funny wow 4 replies in 2 hours thats great!

I think I tried taht second post but ill double check then try again and let u know.

cant i just add "/etc/rc.d/rc.mysqld start" to rc.local ?

isint this the file I can just add command lines and they execute on boot?

phil.d.g · 01-17-2006, 02:11 PM

Quote:

Originally Posted by john_d13

lol u guys r funny wow 4 replies in 2 hours thats great!

I think I tried taht second post but ill double check then try again and let u know.

cant i just add "/etc/rc.d/rc.mysqld start" to rc.local?

MySQL is started from /etc/rc.d/rc.M, specifically this little block of code

Code:

# Start the MySQL database:
if [ -x /etc/rc.d/rc.mysqld ]; then
  . /etc/rc.d/rc.mysqld start
fi

So adding "/etc/rc.d/rc.mysqld start" to /etc/rc.d/rc.local means the system will try to start mysql twice.

Quote:

Originally Posted by john_d13

isint this the file I can just add command lines and they execute on boot?

This is the file to start additional programs, but not in this case because mysql has its own rc script