Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #7672

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

Show all headers | View raw

> */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:

USE db_name;
TRUNCATE items_temp;

LOAD DATA LOCAL INFILE '/home/itoffice/data_bridge/items.txt'
INTO TABLE items_temp
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(id_tc_anartic, cod_art, desc_art, ump, umi, coef_ump_umi, gest_maga, 
cod_iva, cod_cat_cont, desc_cat_cont, cod_class_pat, art_stato,
disabilitato, ean, peso_netto, peso_lordo, um_peso, lunghezza, 
larghezza, altezza, diametro , cod_cat01 , desc_cat01 ,
cod_cat02, desc_cat02, cod_cat03, desc_cat03, cod_cat04, desc_cat04, 
cod_cat05, desc_cat05, cod_cat06, desc_cat06, cod_cat07,
desc_cat07, cod_cat08, desc_cat08, cod_cat09, desc_cat09, cod_cat10, 
desc_cat10, cod_cat11, desc_cat11, cod_cat12, desc_cat12,
cod_cat13, desc_cat13, cod_cat14, desc_cat14, cod_cat15, desc_cat15, 
cod_cat16, desc_cat16, cod_cat17, desc_cat17, cod_cat18,
desc_cat18, cod_cat19, desc_cat19, cod_cat20, desc_cat20,  dt_creazione, 
dt_last_upd);

I tried to insert it in a php file but in this case nothing happen :\

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

// Parametri da inserire per collegarsi al DB
$servername = "localhost";
$username = "username";
$password = "password";
$database = "database_name";
$options = [MYSQLI_OPT_LOCAL_INFILE => true];
$conn = mysqli_connect($servername, $username, $password, $database);
$conn->options(MYSQLI_OPT_LOCAL_INFILE, true);

if (!$conn) {
     die("Connessione al database fallita: " . mysqli_connect_error());
}

// Query SQL
$query = "USE database_name;
TRUNCATE items_temp;

LOAD DATA LOCAL INFILE '/home/itoffice/data_bridge/items.txt'
INTO TABLE items_temp
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(id_tc_anartic, cod_art, desc_art, ump, umi, coef_ump_umi, gest_maga, 
cod_iva, cod_cat_cont, desc_cat_cont, cod_class_pat, art_stato, 
disabilitato, ean, peso_netto, peso_lordo, um_peso, lunghezza, 
larghezza, altezza, diametro, cod_cat01, desc_cat01, cod_cat02, 
desc_cat02, cod_cat03, desc_cat03, cod_cat04, desc_cat04, cod_cat05, 
desc_cat05, cod_cat06, desc_cat06, cod_cat07, desc_cat07, cod_cat08, 
desc_cat08, cod_cat09, desc_cat09, cod_cat10, desc_cat10, cod_cat11, 
desc_cat11, cod_cat12, desc_cat12, cod_cat13, desc_cat13, cod_cat14, 
desc_cat14, cod_cat15, desc_cat15, cod_cat16, desc_cat16, cod_cat17, 
desc_cat17, cod_cat18, desc_cat18, cod_cat19, desc_cat19, cod_cat20, 
desc_cat20, dt_creazione, dt_last_upd)";

if (mysqli_multi_query($conn, $query)) {
     echo "Query eseguita con successo.";
} else {
     echo "Errore nell'esecuzione della query: " . mysqli_error($conn);
}

mysqli_close($conn);
?>

I opened the php.ini file and I have:

; Allow accessing, from PHP's perspective, local files with LOAD DATA 
statements
; https://php.net/mysqli.allow_local_infile
mysqli.allow_local_infile = On

Regards.
^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