Date: Fri, 14 Jul 2023 12:20:59 +0300 From: Odhiambo Washington <odhiambo@gmail.com> To: Jos Chrispijn <bsduser@cloudzeeland.nl> Cc: FreeBSD Mailing List <freebsd-questions@freebsd.org> Subject: Re: Service command Message-ID: <CAAdA2WMzHvzL5TTr7t2=H6sLGvYePLEgPese0TPgNm5vp8fwow@mail.gmail.com> In-Reply-To: <d76a3657-523f-038e-cb7b-3d4b923bcaa6@cloudzeeland.nl> References: <d76a3657-523f-038e-cb7b-3d4b923bcaa6@cloudzeeland.nl>
next in thread | previous in thread | raw e-mail | index | archive | help
--000000000000a460d706006ef9f8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, Jul 14, 2023 at 10:49=E2=80=AFAM Jos Chrispijn <bsduser@cloudzeelan= d.nl> wrote: > Before backing up my MySQL database, I stop the service with the 'service > mysql-server' stop command > > --- > > Stopping mysql. > cronjobs: No such file or directory. > Waiting for PIDS: 38188. > server stopped > > --- > > This works fine, but every time it is displaying a line, saying ' > cronjobs: No such file or directory' > I do have a directory cronjobs from which the command is given (under sh)= . > Also directly as a command under (csh) I get the same display. > > Can you tell what is the cause of this? > > Best regards, > Jos > Look at the script - /usr/local/etc/rc.d/mysql-server - for clues. It appears to be non-standard. Did you modify it? root@svr:/usr/home/wash # service mysql-server stop Stopping mysql. Waiting for PIDS: 29087. root@svr:/usr/home/wash # service mysql-server start Starting mysql. I don't see what you are seeing on my server. Also, I thought that to backup MySQL DBs, you need to have the service running, then do: MySQL -uroot -pmypassword DBNAME > DBNAME.sql #To backup a single DB OR mysqldump -uroot -pmypassword --all-databases > mysql_backup.sql If you are stopping the service and just copy over the directory that contains the DBs files, you are doing it wrong! --=20 Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' =C2=AF\_(=E3=83=84)_/=C2=AF :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html] --000000000000a460d706006ef9f8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">= <div dir=3D"ltr" class=3D"gmail_attr">On Fri, Jul 14, 2023 at 10:49=E2=80= =AFAM Jos Chrispijn <<a href=3D"mailto:bsduser@cloudzeeland.nl">bsduser@= cloudzeeland.nl</a>> wrote:<br></div><blockquote class=3D"gmail_quote" s= tyle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pad= ding-left:1ex"> =20 =20 =20 <div bgcolor=3D"#FFFFFF"> <font size=3D"4" face=3D"Courier New">Before backing up my MySQL database, I stop the service with the 'service mysql-server' = stop command<br> <br> ---<br> </font> <p><font size=3D"4" face=3D"Courier New">Stopping mysql.<br> cronjobs: No such file or directory.<br> Waiting for PIDS: 38188.<br> server stopped</font></p> <p><font size=3D"4" face=3D"Courier New">---<br> </font></p> <p><font size=3D"4" face=3D"Courier New">This works fine, but every time it is displaying a line, saying ' cronjobs: No such file or directory'<br> I do have a directory cronjobs from which the command is given (under sh). Also directly as a command under (csh) I get the same display.<br> </font></p> <p><font size=3D"4" face=3D"Courier New">Can you tell what is the cause of this?</font><font size=3D"4" face=3D"Cour= ier New"></font> </p> <p><font size=3D"4" face=3D"Courier New">Best regards,<br> Jos<br></font></p></div></blockquote><div><br></div><div>Look at th= e script - /usr/local/etc/rc.d/mysql-server - for clues.=C2=A0</div><div>It= appears to be non-standard. Did you modify it?</div><div><br></div><div>ro= ot@svr:/usr/home/wash # service mysql-server stop<br>Stopping mysql.<br>Wai= ting for PIDS: 29087.<br>root@svr:/usr/home/wash # service mysql-server sta= rt<br>Starting mysql.<br></div></div><div><br></div>I don't see what yo= u are seeing on my server.<div><br></div><div>Also, I thought that to backu= p MySQL DBs, you need to have the service running, then do:<br><br>MySQL -u= root -pmypassword DBNAME > DBNAME.sql #To backup a single DB</div><div><= br></div><div>OR</div><div><br></div><div>mysqldump -uroot -pmypassword --a= ll-databases > mysql_backup.sql=C2=A0</div><div><br></div><div>If you ar= e stopping the service and just copy over the directory that contains the D= Bs files, you are doing it wrong!</div><div><br clear=3D"all"><div><br></di= v><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" cla= ss=3D"gmail_signature"><div dir=3D"ltr"><div dir=3D"ltr"><div>Best regards,= <br>Odhiambo WASHINGTON,<br>Nairobi,KE<br>+254 7 3200 0004/+254 7 2274 3223= <br>"<span style=3D"font-size:12.8px">Oh, the cruft.</span><span style= =3D"font-size:12.8px">",=C2=A0</span><span style=3D"font-size:12.8px">= egrep -v '^$|^.*#'=C2=A0</span><span style=3D"background-color:rgb(= 34,34,34);color:rgb(238,238,238);font-family:"Lucida Console",Con= solas,"Courier New",monospace;font-size:13.6px">=C2=AF\_(=E3=83= =84)_/=C2=AF</span><span style=3D"font-size:12.8px">=C2=A0:-)</span></div><= div><span style=3D"font-size:12.8px">[How to ask smart questions:=C2=A0</sp= an><span style=3D"font-size:12.8px"><a href=3D"http://www.catb.org/~esr/faq= s/smart-questions.html" target=3D"_blank">http://www.catb.org/~esr/faqs/sma= rt-questions.html</a>]</span></div></div></div></div></div></div> --000000000000a460d706006ef9f8--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAAdA2WMzHvzL5TTr7t2=H6sLGvYePLEgPese0TPgNm5vp8fwow>