This page was exported from GTUTO [ https://www.gtuto.com ]

Export date:Fri Apr 26 0:14:51 2024 / +0000 GMT

___________________________________________________


Title: MARIADB LOAD DATA ERREUR apparmor ou CONNECT

---------------------------------------------------



edit /etc/apparmor.d/usr.sbin.mysqld
Ajouter les répertoires contenant les csv pour LOAD
/usr/sbin/mysqld {
    [...]
        /home/www/douane/export/ftp_tempo/ r,
        /home/www/douane/export/ftp_tempo/* rw
	/home/mysql_log r,
	/home/mysql_log/** rwk
    [...]
}

/etc/init.d/apparmor reload


Autre pb selon serveur

/etc/systemd/system/mysqld.service -> ProtectHome=false
systemctl daemon-reload
/etc/init.d/mysql stop
/etc/init.d/mysql start

On peut alors faire
CREATE DATABASE DBF_TABLES CHARACTER SET CP850;
USE DBF_TABLES; 
CREATE TABLE stock engine=CONNECT table_type=DBF READONLY=0 file_name='/home/lecteurh/dbf/fichiers/stock.dbf';
Pour certaines version -> erreur 174
CREATE TABLE stock engine=CONNECT table_type=DBF READONLY=0 
 option_list='Accept=1' file_name='/home/lecteurh/dbf/fichiers/stock.dbf';

création d'au moins un index:
ALTER TABLE `stock` ADD PRIMARY KEY (`id_stock`);
-> fichier stock.dbx créé <- vérifier car pas de message d'erreur si pb de droits






---------------------------------------------------


Images: 

---------------------------------------------------




---------------------------------------------------


Post date: 2019-10-21 16:52:51

Post date GMT: 2019-10-21 16:52:51

Post modified date: 2020-02-19 21:57:17

Post modified date GMT: 2020-02-19 21:57:17



____________________________________________________________________________________________


Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com