When the documentation you write has a step about large database deletes:
"4. If the select query looks correct, change the query to a delete. A moment for prayer or non-secular routine (maybe grab a coffee and turn up your music to find a happy place) is appropriate at this point." #DBAdmin

It may be common knowledge but my mind was blown. :amaze:

We're using CentOS and my DBAD (Database Admin) instructor hinted at the option to make user input variables in some of the new dictionary views we learned this module and using WHERE name = UPPER('&NAME') in the select statement.

I had no idea you could prompt for user input... I was in the middle of making 3 profiles, 9 roles,
16 users, granting them roles and/or privileges as I went, editing a text file in gedit with the new user data and pasting it into the terminal.

It may not actually be faster but it feels faster (I may be biased because I love database). The &UNLIMITED_QUOTA_TABLESPACE variable name is not the best and very long, use &QUOTA_TABLESPACE or something shorter, and the size can be changed to &SIZE_APPEND_M so you can enter 20M but we were using unlimited for the lab.

#CentOS #Oracle #SQL #DBA #OracleSQL #Database #DBAdmin #DBAD #CentOS5 #Oracle12c

Are we truly the useless generation? #technology has become so complex that it is beyond our understanding and is essentially #magic

We have also forgotten how to #survive without it. I couldn't make a plough, cultivate crops or build a shelter, could you?

What use would you be to an emerging civilisation that would tempt them to help you

Hypothetically thrown back in time, pre technology, I would not survive the first winter. #dbAdmin skills would not help me, I doubt I could make fire.

fresh install of debian bullseye on w10 wsl

trying to install monica crm

need mysql

figured installing phpmyadmin was a handy shortcut.

it's not.

please help me resolve this error.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

---------
Hashtags
---------
#mysql #phpmyadmin #bullsey #debian #w10 #windows10 #wsl #windowsSubsystemForLinux #monica #crm #administator #database #dbadmin #help #error #error2002

phpMyAdmin, administrera MySQL- och MariaDB-databaser 🤟

https://oppetmoln.se/20220301/phpmyadmin-administrera-mysql-och-mariadb-databaser

#opensource #foss #oss #php #mysql #mariadb #dbadmin