GTUTO
https://www.gtuto.com/select-into-outfile-droits-mysqm-mariadb/
Export date: Sat Apr 20 9:06:59 2024 / +0000 GMT

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
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 date: Sat Apr 20 9:06:59 2024 / +0000 GMT
This page was exported from GTUTO [ https://www.gtuto.com ]
Export of Post and Page has been powered by [ Universal Post Manager ] plugin from www.ProfProjects.com