Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #7680

Re: From bash script (Debian Bookworm) login and query to MariaDB

Path csiph.com!news.mixmin.net!eternal-september.org!feeder2.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From ^Bart <gabriele1NOSPAM@hotmail.com>
Newsgroups comp.databases.mysql
Subject Re: From bash script (Debian Bookworm) login and query to MariaDB
Date Sun, 5 Nov 2023 11:23:51 +0100
Organization A noiseless patient Spider
Lines 36
Message-ID <ui7qe2$3uuvf$1@dont-email.me> (permalink)
References <uhr78k$13p7r$1@dont-email.me> <uhrmcl$16ilv$2@dont-email.me> <uhvn6g$23nq2$1@dont-email.me> <uhvun1$256tt$1@dont-email.me> <ui0he6$29ikj$1@jstuckle.eternal-september.org> <ui30rp$2qj1q$1@dont-email.me> <ui3834$2rqcr$1@dont-email.me> <ui505g$39s7l$1@dont-email.me> <kqmg25Ftbq5U3@mid.individual.net>
MIME-Version 1.0
Content-Type text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding 7bit
Injection-Date Sun, 5 Nov 2023 10:22:58 -0000 (UTC)
Injection-Info dont-email.me; posting-host="e17554625035dc807cc321cf476557a1"; logging-data="4160495"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/Bsh3FEeLylgWxQynQ13Uaunv9zDmcnNw="
User-Agent Mozilla Thunderbird
Cancel-Lock sha1:6SyDDhHZxLCbIJJQIAXNSPNy7Rw=
Content-Language en-US
In-Reply-To <kqmg25Ftbq5U3@mid.individual.net>
Xref csiph.com comp.databases.mysql:7680

Show key headers only | View raw

> Did you look at the mail from crontab? by default it goes to the 
> localhost root user (you can change that with setting the MAILTO 
> variable), if something wen t wrong while running the mysql command it 
> will be in that mail (if no output, no mail).
> 
> You could check your /var/log/mysql/mysql.{err,log} too
> 
> I hope the "-u MY_USER" was a typo, otherwise loose the space after '-u'.

I found this solutions:

*/5 * * * * /home/itoffice/job01.sh

This is job01.sh

#!/bin/bash
#sostituisce tutte le virgole presenti nel file con dei punti
sed -i -e 's/,/./gip' /home/itoffice/data_bridge/articoli.txt

/usr/bin/mysql -umy_username -pmy_password < /home/itoffice/articoli.sql

#copia del file importato nella directory di backup
mv -v /home/itoffice/data_bridge/articoli.txt 
"/home/itoffice/data_bridge_bck/articoli_$(date +"%d-%m-%Y_%H-%M".txt)"

I found these information to fix php load data:

https://itecnote.com/tecnote/php-load-data-local-infile-forbidden-after-php-mariadb-update/
https://itecnote.com/tecnote/php-load-data-local-infile-forbidden-after-php-mariadb-update/

But now I need to do other things in my company so... I know it's a 
dirty way to use a *.sh file but I dont't have free time to fix it maybe 
next weeks... ;)

Have a nice day!
^Bart

Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-10-31 16:42 +0100
  Re: From bash script (Debian Bookworm) login and query to MariaDB The Natural Philosopher <tnp@invalid.invalid> - 2023-10-31 20:00 +0000
    Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-02 09:39 +0100
      Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-02 11:46 +0100
        Re: From bash script (Debian Bookworm) login and query to MariaDB "J.O. Aho" <user@example.net> - 2023-11-02 12:22 +0100
          Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-02 15:07 +0100
            Re: From bash script (Debian Bookworm) login and query to MariaDB "J.O. Aho" <user@example.net> - 2023-11-02 15:57 +0100
        Re: From bash script (Debian Bookworm) login and query to MariaDB Jerry Stuckle <stuckle.jerry@gmail.com> - 2023-11-02 12:06 -0400
          Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-03 15:42 +0100
            Re: From bash script (Debian Bookworm) login and query to MariaDB The Natural Philosopher <tnp@invalid.invalid> - 2023-11-03 16:45 +0000
              Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <none@none.it> - 2023-11-04 09:42 +0100
                Re: From bash script (Debian Bookworm) login and query to MariaDB "J.O. Aho" <user@example.net> - 2023-11-04 10:09 +0100
                Re: From bash script (Debian Bookworm) login and query to MariaDB Jerry Stuckle <stuckle.jerry@gmail.com> - 2023-11-04 12:56 -0400
                Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-05 11:23 +0100
                Re: From bash script (Debian Bookworm) login and query to MariaDB "J.O. Aho" <user@example.net> - 2023-11-05 12:56 +0100
  Re: From bash script (Debian Bookworm) login and query to MariaDB Marco Moock <mm+usenet-es@dorfdsl.de> - 2023-10-31 21:01 +0100
    Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-02 09:40 +0100
  Re: From bash script (Debian Bookworm) login and query to MariaDB Jerry Stuckle <stuckle.jerry@gmail.com> - 2023-10-31 19:06 -0400
    Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-02 09:50 +0100
      Re: From bash script (Debian Bookworm) login and query to MariaDB "J.O. Aho" <user@example.net> - 2023-11-02 12:03 +0100
  Re: From bash script (Debian Bookworm) login and query to MariaDB "J.O. Aho" <user@example.net> - 2023-11-01 08:04 +0100
    Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-02 10:09 +0100

csiph-web