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
[-- Attachment #1 --] On Fri, Jul 14, 2023 at 10:49 AM Jos Chrispijn <bsduser@cloudzeeland.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! -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html] [-- Attachment #2 --] <div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jul 14, 2023 at 10:49 AM Jos Chrispijn <<a href="mailto:bsduser@cloudzeeland.nl">bsduser@cloudzeeland.nl</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> <div bgcolor="#FFFFFF"> <font size="4" face="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="4" face="Courier New">Stopping mysql.<br> cronjobs: No such file or directory.<br> Waiting for PIDS: 38188.<br> server stopped</font></p> <p><font size="4" face="Courier New">---<br> </font></p> <p><font size="4" face="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="4" face="Courier New">Can you tell what is the cause of this?</font><font size="4" face="Courier New"></font> </p> <p><font size="4" face="Courier New">Best regards,<br> Jos<br></font></p></div></blockquote><div><br></div><div>Look at the script - /usr/local/etc/rc.d/mysql-server - for clues. </div><div>It appears to be non-standard. Did you modify it?</div><div><br></div><div>root@svr:/usr/home/wash # service mysql-server stop<br>Stopping mysql.<br>Waiting for PIDS: 29087.<br>root@svr:/usr/home/wash # service mysql-server start<br>Starting mysql.<br></div></div><div><br></div>I don't see what you are seeing on my server.<div><br></div><div>Also, I thought that to backup MySQL DBs, you need to have the service running, then do:<br><br>MySQL -uroot -pmypassword DBNAME > DBNAME.sql #To backup a single DB</div><div><br></div><div>OR</div><div><br></div><div>mysqldump -uroot -pmypassword --all-databases > mysql_backup.sql </div><div><br></div><div>If you are stopping the service and just copy over the directory that contains the DBs files, you are doing it wrong!</div><div><br clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div dir="ltr"><div>Best regards,<br>Odhiambo WASHINGTON,<br>Nairobi,KE<br>+254 7 3200 0004/+254 7 2274 3223<br>"<span style="font-size:12.8px">Oh, the cruft.</span><span style="font-size:12.8px">", </span><span style="font-size:12.8px">egrep -v '^$|^.*#' </span><span style="background-color:rgb(34,34,34);color:rgb(238,238,238);font-family:"Lucida Console",Consolas,"Courier New",monospace;font-size:13.6px">¯\_(ツ)_/¯</span><span style="font-size:12.8px"> :-)</span></div><div><span style="font-size:12.8px">[How to ask smart questions: </span><span style="font-size:12.8px"><a href="http://www.catb.org/~esr/faqs/smart-questions.html" target="_blank">http://www.catb.org/~esr/faqs/smart-questions.html</a>]</span></div></div></div></div></div></div>;
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAAdA2WMzHvzL5TTr7t2=H6sLGvYePLEgPese0TPgNm5vp8fwow>