Unhandled Runtime Error Error: Invalid prisma invocation: The table does not exist in the current database.

error nextjs prisma

pushing structure with 

npx prisma migrate dev

or

npx prisma db push

produces error:


Prisma schema loaded from prisma\schema.prisma
Datasource "db": MySQL database

Error: Prisma schema validation - (get-config wasm)
Error code: P1012
error: Environment variable not found: DATABASE_URL.
--> schema.prisma:7
|
6 | provider = "mysql"
7 | url = env("DATABASE_URL")
|

Validation Error Count: 1
[Context: getConfig]

for whatever reason had to rename

.env.local --> .env

else "npx prisma db push" or "npx prisma migrate dev" couldnt find DATABASE_URL