Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
titleDrop SO databases
collapsetrue
root@release-rancher:~/oom/kubernetes/so#~# kubectl -n onap exec -it dev-mariadb-galera-mariadb-galera-0 sh
sh-4.2$-- mysql -uroot -psecretpassword catalogdb

MariaDB [catalogdb]> -e "show databases;"
+--------------------+
| Database           |
+--------------------+
| camundabpmn        |
| catalogdb          |
| information_schema |
| my-database | | mysql |
|     |
| mysql              |
| performance_schema |
| requestdb          |
| sdnctl             |
+--------------------+
8 rows in set (0.00 sec)

MariaDB [catalogdb]> root@release-rancher:~# kubectl -n onap exec -it dev-mariadb-galera-mariadb-galera-0 -- mysql -uroot -psecretpassword -e "drop database camundabpmn;
Query OK, 46 rows affected (2.04 sec)

MariaDB [catalogdb]> "
root@release-rancher:~# kubectl -n onap exec -it dev-mariadb-galera-mariadb-galera-0 -- mysql -uroot -psecretpassword -e "drop database catalogdb;
Query OK, 66 rows affected (0.78 sec)

MariaDB [(none)]> drop database requestdb;
Query OK, 14 rows affected (0.28 sec)
"
root@release-rancher:~# kubectl -n onap exec -it dev-mariadb-galera-mariadb-galera-0 -- mysql -uroot -psecretpassword -e "drop database requestdb"
root@staging-rancher:~# kubectl -n onap exec -it dev-mariadb-galera-mariadb-galera-0 -- mysql -uroot -psecretpassword -e "show databases"
+--------------------+
| Database           |
+--------------------+
| information_schema |
| my-database        |
| mysql              |
| performance_schema |
| sdnctl             |
+--------------------+

...