Skip to content

Instantly share code, notes, and snippets.

@Baneeishaque

Baneeishaque/empty_mysql_server.bat

Last active April 6, 2022 17:09
Show Gist options
  • Save Baneeishaque/4604cfcac3e373b914998f0938bcb7cf to your computer and use it in GitHub Desktop.
Save Baneeishaque/4604cfcac3e373b914998f0938bcb7cf to your computer and use it in GitHub Desktop.
Download ZIP
Clean MySQL Server
Raw
empty_mysql_server.bat
mysql -uroot -p1234 -e "show databases" | grep -v Database | grep -v mysql| grep -v information_schema| grep -v test | grep -v OLD | grep -v performance_schema | grep -v sys | gawk "{print \"drop database \" $1 \";select sleep(0.1);\"}" | mysql -uroot -p1234
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment