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

From	"J.O. Aho" <user@example.net>
Newsgroups	comp.databases.mysql
Subject	Re: From bash script (Debian Bookworm) login and query to MariaDB
Date	2023-11-02 15:57 +0100
Message-ID	<kqhrnhFtbq5U2@mid.individual.net> (permalink)
References	(1 earlier) <uhrmcl$16ilv$2@dont-email.me> <uhvn6g$23nq2$1@dont-email.me> <uhvun1$256tt$1@dont-email.me> <kqhf2pFtbq4U1@mid.individual.net> <ui0ae6$27ame$1@dont-email.me>

Show all headers | View raw

On 02/11/2023 15.07, ^Bart wrote:
>> */5 * * * * (root) (/usr/bin/mysql -umy_username -pmy_password 
>> databasename <
>>   /home/itoffice/query.sql)
> 
> */5 * * * * (itoffice) (/usr/bin/mysql -u username -p password db_name < 
> /home/it_office/query.sql)
> 
> It doesn't work :\ but it doesn't work also if I insert it in a php 
> script; here below is the working *.sql file used from MariaDB CLI:

What error mail is sent from crontab? should be sent to the local 
machines root user unless you have set MAILTO to another email address.

in worst case use less and read the /var/spool/mail/root should be in 
the end of the file.
sure you can use the alpine or mutt to read the mail too.

By the way, do you have characters like '#;" in your password? Those 
tend to cause issues when using this way. I would recommend the usage of 
profile.

-- 
  //Aho

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