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
Using follow command to export user info to local file.
mysql -u USER -pPASSWORD -e "select * from database.user_info" > /tmp/user_info.txt