Skip to content

Instantly share code, notes, and snippets.

@zabih-alipour

zabih-alipour/gist:9c0db907448ee34f774b207b08bc40e1

Created October 16, 2020 12:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zabih-alipour/9c0db907448ee34f774b207b08bc40e1 to your computer and use it in GitHub Desktop.
Save zabih-alipour/9c0db907448ee34f774b207b08bc40e1 to your computer and use it in GitHub Desktop.
Download ZIP
export Mysql current settings
Raw
gistfile1.txt
All settingd:
mysql -uroot -p -A -e"SHOW VARIABLES;" > ~/MySQLCurrentSettings.txt
Global SEttings:
mysql -uroot -p -A -e"SHOW GLOBAL VARIABLES;" > ~/MySQLCurrentSettings.txt
Session Settings:
mysql -uroot -p -A -e"SHOW SESSION VARIABLES;" > ~/MySQLCurrentSettings.txt
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment