From nobody Fri Jul 14 09:20:59 2023 X-Original-To: freebsd-questions@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4R2Qw157Dnz4mjBB for ; Fri, 14 Jul 2023 09:21:37 +0000 (UTC) (envelope-from odhiambo@gmail.com) Received: from mail-lj1-x22e.google.com (mail-lj1-x22e.google.com [IPv6:2a00:1450:4864:20::22e]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1D4" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4R2Qw13Tmbz47SB for ; Fri, 14 Jul 2023 09:21:37 +0000 (UTC) (envelope-from odhiambo@gmail.com) Authentication-Results: mx1.freebsd.org; none Received: by mail-lj1-x22e.google.com with SMTP id 38308e7fff4ca-2b83969d625so9504131fa.1 for ; Fri, 14 Jul 2023 02:21:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1689326495; x=1691918495; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Wd5ftW0n2NF5THNKqtoeZ5AOHwCg5eLpIZVCXznZOZc=; b=QpSgtB3IRJFkF8ooo+UmesYZ0aZjiOOXL80L5+Ym0S7+evuPOx+wJ7DP5nJwfadDqq CmbQzhMakokHIpWKGXzhlMniAo3HkbUfpSFqbV6nA5Rcxijb30hIhDRyJO1ouhqHrRAy hxPCJTtLYtfEvQqokkHo8roFpf8UzozyZW4vOcNXyAwaapAsFPVvDTwssopYGrYeAq9p bA2AmeRqNskAvAdM3DVjiCxGjRyj+U+fAWKAZKv4QLs8tFkBwB0xCmFPUWW9aUgRChvV DNaFnzDJvBLrKQfX7aLJsh3UkotEj8x/sZ9GHA/VlVsevER7+oajl2L9tNbtAdXkuiJj g67g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689326495; x=1691918495; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Wd5ftW0n2NF5THNKqtoeZ5AOHwCg5eLpIZVCXznZOZc=; b=C2yJ4lZjtXf7fOnofOEprOYAemlur2s3yDPY2O6zGWTy1LZxRRSabGk7hHBu4ghh0L 8TGZVRVdWOuteK1CqGPhdHC2Pr1aWzu7lBA9LQiVn24jp3aBxCE4CQRSsQ5SeuZ8ZIdy cY0QbYH9GalQhj2Ps5PmsNvMBCUD7unCUl4+14OYGOVfLUbLxSomoIA1bg+/OdUuu79s J1FCberOLIqfWiizUczgi+mkmDVDAWtKdSA2BbyvxPWrM6WJYxsbw+2wfi95snYQRpCv 0GZGri12f9EUY1+kjievno2aLjtqd8ScgCeHvX30fIHHzznLDEwr8qZQYEk1tVE2m/h9 fCCw== X-Gm-Message-State: ABy/qLYp695azJJpQiB8sggcENmQu+vMQm5ZMOjTcspoXHRjxkU//fFL nxe8uQ2v4WM7qb6r9AEQ8zuMVNuf4/MdwaF5v7z82nA6Ficgtt73 X-Google-Smtp-Source: APBJJlGvA5oaLUtj3/t6y0Ca+RZaniARkU1VDvnFg40pDwMrO6vLS9Bm58gzm/HRYDHr/nV0JhnS7mL4z+kR29rdKjk= X-Received: by 2002:a05:651c:39d:b0:2b6:b30f:5bf with SMTP id e29-20020a05651c039d00b002b6b30f05bfmr943940ljp.13.1689326494964; Fri, 14 Jul 2023 02:21:34 -0700 (PDT) List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-questions@freebsd.org X-BeenThere: freebsd-questions@freebsd.org MIME-Version: 1.0 References: In-Reply-To: From: Odhiambo Washington Date: Fri, 14 Jul 2023 12:20:59 +0300 Message-ID: Subject: Re: Service command To: Jos Chrispijn Cc: FreeBSD Mailing List Content-Type: multipart/alternative; boundary="000000000000a460d706006ef9f8" X-Rspamd-Queue-Id: 4R2Qw13Tmbz47SB X-Spamd-Bar: ---- X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US] X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-ThisMailContainsUnwantedMimeParts: N --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 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


=
On Fri, Jul 14, 2023 at 10:49=E2=80= =AFAM Jos Chrispijn <bsduser@= cloudzeeland.nl> wrote:
=20 =20 =20
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 th= e script - /usr/local/etc/rc.d/mysql-server - for clues.=C2=A0
It= appears to be non-standard. Did you modify it?

ro= ot@svr:/usr/home/wash # service mysql-server stop
Stopping mysql.
Wai= ting for PIDS: 29087.
root@svr:/usr/home/wash # service mysql-server sta= rt
Starting mysql.

I don't see what yo= u are seeing on my server.

Also, I thought that to backu= p MySQL DBs, you need to have the service running, then do:

MySQL -u= root -pmypassword DBNAME > DBNAME.sql #To backup a single DB
<= br>
OR

mysqldump -uroot -pmypassword --a= ll-databases > mysql_backup.sql=C2=A0

If you ar= e stopping the service and just copy over the directory that contains the D= Bs files, you are doing it wrong!


--
Best regards,=
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223=
"Oh, the cruft.",=C2=A0= egrep -v '^$|^.*#'=C2=A0=C2=AF\_(=E3=83= =84)_/=C2=AF=C2=A0:-)
<= div>[How to ask smart questions:=C2=A0http://www.catb.org/~esr/faqs/sma= rt-questions.html]
--000000000000a460d706006ef9f8--