Експорт бази даних
USE base2;
SELECT * FROM Orders INTO OUTFILE '/var/lib/mysql-files/orders.csv';
Зверніть увагу на теку експорту.
MtSQL має право експортувати файл в цю теку.
sudo su
cd /var/lib/mysql-files/
ll
файл має права рута
cp /var/lib/mysql-files/orders.csv /home/spa/Desktop/orders.csv
cd /home/spa/Desktop
ll
rw-r---- 1 root root 127 лис 19 11:47 books.csv
chmod 777 /home/spa/Desktop/orders.csv
Watch video MySQL csv export online without registration, duration hours minute second in high quality. This video was added by user spa it 19 November 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6 once and liked it people.