MySQL export data by sql 2021-06-03 06:00
You can export data by using mysqldump command. Click here for more detail.
Another way to export data is using mysql command with -e parameter.
Using follow command to export user info to local file.
mysql -u USER -pPASSWORD -e "select * from database.user_info" > /tmp/user_info.txt
EOF