DEV Community

tj_27
tj_27

Posted on

Export Data from MySQL

Okay, because I need to remember how would I export data from MySQL, I need to leave it here.

# export
mysql --defaults-file=/data/db/mysql3366/my.cnf -S /data/db/mysql3366/mysql3366.sock -u [user] -p < select.sql | sed 's/\t/", "/g;s/^/"/;s/$"/;s/\n//g' > ./output_file.csv

# translate
sed -i '1s/^/\xEF\xBB\xBF' ./output_file.csv
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

_akira19 profile image

Creating a Toy Solidity compiler and running it in a Toy EVM

Akira -

slobodan4nista profile image

Journal Transcriber: Write journal by dictating it

Slobi -

abhinowww profile image

Pre-trained AI Models Explained: Implementation Guide with BERT, GPT & Stable Diffusion

Abhinav Anand -

elielskillwell profile image

Dev Challenge: App to make you better at public speaking.

ElielSkillwell -