creating mysql db for nextjs app with prisma

1moeinHOBBY

a year ago

Hey guys,
I have a nextjs app that has been using planetscale for its database. The database is practically empty, and I'm trying to recreate it as a mysql db on railway. Can you give me a few pointers on how to do that? Your quickstart tutorial hasn't been much help and note that I'm not a developer by training; just learning on my own.
I was thinking about the process this way:

  1. Create an empty mysql database on railway, get the DATABASE_URL and add it to my project's .env file.

  2. Run my 'npx prisma db push' command and a seeding script that is included in my settings to recreate the initial data and the tables.

  3. Sit down and sip my coffee…
    So far, I've only done step 3! <:salute:1137099685417451530>
    When I try to create a New Project and search for 'mysql' I get several options and I'm confused.
    I'd appreciate any suggestions on how to do step 1. That's my bottleneck right now.

0 Replies

creating mysql db for nextjs app with prisma - Railway Help Station