Posted inLinux
Drop all tables in a MySQL database
mysqldump -u[USERNAME] -p[PASSWORD] --add-drop-table --no-data [DATABASE] | grep ^DROP | mysql -u[USERNAME] -p[PASSWORD] [DATABASE] [USERNAME], [PASSWORD] & [DATABASE] are…
Experiments in IT infrastructure, monitoring and automation, with practical notes on Linux, networking and observability