Export sms_messages

General Help
1

With
fwconsole m
show tables;
select * from sms_messages;

I can see all text messages. How do I export them? I need them for a court in csv format.

2

Always export to /tmp then feel free to move the fille

3

Thank you very much! I used

SELECT *
INTO OUTFILE ‘/tmp/sms.csv’
FIELDS TERMINATED BY ‘,’
ENCLOSED BY ‘"’
ESCAPED BY ‘\’
LINES TERMINATED BY ‘\n’
FROM sms_messages;

I just don’t understand why the file ended up in

/tmp/systemd-private-af5522fe42aa4797b085409c6fe8d693-mariadb.service-c2bGlq/tmp

4

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.