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

Export date:Fri Apr 19 18:48:00 2024 / +0000 GMT

___________________________________________________


Title: SELECT INTO OUTFILE droits MySQL MariaDB

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



SELECT customer_id, firstname, surname INTO OUTFILE '/home/exportdata/customers.txt'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY 'n'
  FROM customers;



chown mysql:mysql /home/exportdata/
chmod 777 /home/exportdata/

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


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


Images: 

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




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


Post date: 2019-01-14 16:02:55

Post date GMT: 2019-01-14 16:02:55

Post modified date: 2019-01-17 08:26:10

Post modified date GMT: 2019-01-17 08:26:10



____________________________________________________________________________________________


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