Migrate Umami to Railway | Railway | Page 1

knotty wagon Jan 14, 2024, 4:15 AM

#

I need some help to migrate umami from pikapods to railway @muted minnow

slow fogBOT Jan 14, 2024, 4:15 AM

#

Project ID: N/A

knotty wagon Jan 14, 2024, 4:15 AM

#

slow fog

N/A

muted minnow Jan 14, 2024, 4:17 AM

#

👋

#

you have access to adminer on pikapods, so export the database from there, and then we will go from there

knotty wagon Jan 14, 2024, 4:19 AM

#

I don't know where that dump function is

#

If this function exist it should be easier

muted minnow Jan 14, 2024, 4:19 AM

#

within umami's ui?

knotty wagon Jan 14, 2024, 4:19 AM

#

No idea

#

That's all I was told

muted minnow Jan 14, 2024, 4:19 AM

#

dig around in it

#

i cant find anything, i think they meant database dump/restore

knotty wagon Jan 14, 2024, 4:29 AM

#

https://github.com/umami-software/umami/discussions/2159

GitHub

Data Export and Import · umami-software umami · Discussion #2159

Data Export and Import At present, my umami is running on a server through docker. I want to migrate it to vercel + supabase, but I have not found the function of data import and export. If there i...

muted minnow Jan 14, 2024, 4:29 AM

#

yeah where gonna have to do a database export and import

knotty wagon Jan 14, 2024, 4:31 AM

#

Ok

muted minnow Jan 14, 2024, 4:32 AM

#

so export the database from adminer

knotty wagon Jan 14, 2024, 4:32 AM

#

This is it

#

Use/drop+create/create?

muted minnow Jan 14, 2024, 4:33 AM

#

yeah why not

#

its an export, its not like you can break stuff, if you do you just deploy a new umami template

knotty wagon Jan 14, 2024, 4:35 AM

#

I used the create option

#

In the file it says it's a dump

muted minnow Jan 14, 2024, 4:36 AM

#

this is what i used

2024-01-13_23_35_17-Export__railway_-_monorail.proxy.rlwy.net_40798_-_Adminer.png

knotty wagon Jan 14, 2024, 4:37 AM

#

muted minnow this is what i used

Ok, done

muted minnow Jan 14, 2024, 4:37 AM

#

you got your gzip file in hand?

knotty wagon Jan 14, 2024, 4:37 AM

#

yep

muted minnow Jan 14, 2024, 4:37 AM

#

okay deploy that umami template i linked you, or do you want me to send it again?

knotty wagon Jan 14, 2024, 4:38 AM

#

is it not just one?

muted minnow Jan 14, 2024, 4:39 AM

#

i have not published this https://railway.app/template/ZiHXd_
you need to deploy it from this think

knotty wagon Jan 14, 2024, 4:40 AM

#

Ok

muted minnow Jan 14, 2024, 4:40 AM

#

the one in your screenshot deploys with postgres, we dont want that

knotty wagon Jan 14, 2024, 4:40 AM

#

It asks me to config things

muted minnow Jan 14, 2024, 4:40 AM

#

yeah just click config and save

knotty wagon Jan 14, 2024, 4:41 AM

#

REady

muted minnow Jan 14, 2024, 4:42 AM

#

okay let me get caught up, im doing this all myself too

knotty wagon Jan 14, 2024, 4:44 AM

#

Ok, I guess let's continue on Monday, I think my brain is dead for today and tomorrow I don't want to use the computer.

muted minnow Jan 14, 2024, 4:44 AM

#

fair enough

knotty wagon Jan 14, 2024, 4:46 AM

#

Talk on Monday

muted minnow Jan 14, 2024, 4:46 AM

#

sounds good

knotty wagon Jan 15, 2024, 2:53 PM

#

Hola

#

Back to business

knotty wagon Jan 15, 2024, 3:38 PM

#

How was your weekend?

muted minnow Jan 15, 2024, 4:45 PM

#

just woke up, still only on phone for now, but where did we leave off?
you had your database dump gzip file from adminer and now you have a new umami deploy on railway right?

knotty wagon Jan 15, 2024, 5:51 PM

#

Yes, I think I will do another dump just before I'm ready to import to make sure I have all the data

#

But yeah, I'm ready for the next step 🙂

muted minnow Jan 15, 2024, 5:51 PM

#

yeah that makes sense, good idea

#

in preparation for this I have created a Adminer template for railway, go ahead and deploy that into your current project

#

and now I'd like to not be on a phone for the next steps, I should be on my computer in under 20 minutes, talk soon

knotty wagon Jan 15, 2024, 6:06 PM

#

ok

#

Let me know

muted minnow Jan 15, 2024, 6:07 PM

#

we back

knotty wagon Jan 15, 2024, 6:18 PM

#

Cool I'm here

muted minnow Jan 15, 2024, 6:25 PM

#

we want to remove umami's active deployment

knotty wagon Jan 15, 2024, 6:42 PM

#

Sorry I went to lunch break

muted minnow Jan 15, 2024, 6:42 PM

#

no worries

#

perfect, open adminer and login to the mysql database

Server -> mysql.railway.internal:3306
Username -> MYSQLUSER
Password -> MYSQLPASSWORD
Database -> MYSQLDATABASE

#

you would need to use the values of those environment variables

knotty wagon Jan 15, 2024, 6:47 PM

#

and where are those?

muted minnow Jan 15, 2024, 6:47 PM

#

in the variables tab on the mysql service

knotty wagon Jan 15, 2024, 6:48 PM

#

ah yeah

#

I'm in

muted minnow Jan 15, 2024, 6:48 PM

#

click import

#

import, top left

knotty wagon Jan 15, 2024, 6:49 PM

#

yes

muted minnow Jan 15, 2024, 6:49 PM

#

then choose your gzip dump, and click execute

#

okay now you can go back to the railway database (in adminer) and send a screenshot

#

how many websites did you have in umami on pikapods

knotty wagon Jan 15, 2024, 6:53 PM

#

muted minnow how many websites did you have in umami on pikapods

1

muted minnow Jan 15, 2024, 6:54 PM

#

yours says zero, but click it anyway

#

might have done the export from pikapods wrong, show me the settings you used to do that export please

#

what is the size of your gziped file?

knotty wagon Jan 15, 2024, 7:02 PM

#

Just downloaded again and see I ripped the filename off of .sql

muted minnow Jan 15, 2024, 7:04 PM

#

try to import that into the railway database again

knotty wagon Jan 15, 2024, 7:04 PM

#

Don't we need to clean the database off of the first import first?

muted minnow Jan 15, 2024, 7:04 PM

#

shouldn't need to

knotty wagon Jan 15, 2024, 7:04 PM

#

ok

#

Negative

muted minnow Jan 15, 2024, 7:06 PM

#

show me the same thing in adminer for pikapods

#

would you be interested in sending me that gzip file? (in dms)

knotty wagon Jan 15, 2024, 7:08 PM

#

Done

muted minnow Jan 15, 2024, 7:08 PM

#

looking

#

okay, i think i see whats happening, within railway's adminer
select p16699 from the DB dropdown in the top left

#

then once selected on that database, do this

#

then you can select the railway database again then check if the data is all there

knotty wagon Jan 15, 2024, 7:15 PM

#

That was it

muted minnow Jan 15, 2024, 7:16 PM

#

sweet, log out of adminer, then go and redeploy umami

knotty wagon Jan 15, 2024, 7:16 PM

#

Shouldn't we deleted the Database: p16699 ?

muted minnow Jan 15, 2024, 7:17 PM

#

sure you can drop the tables in there

knotty wagon Jan 15, 2024, 7:18 PM

#

Done

muted minnow Jan 15, 2024, 7:18 PM

#

log into umami

#

same username and password you used on the pikapods umami app

knotty wagon Jan 15, 2024, 7:19 PM

#

I'm in Sir

muted minnow Jan 15, 2024, 7:20 PM

#

everything look good?

knotty wagon Jan 15, 2024, 7:20 PM

#

Yep

#

Is it the same tracking code or do I have to change it?

muted minnow Jan 15, 2024, 7:20 PM

#

awsome

#

tracking code should be the same, and i assume you plan on bringing over your custom domain too, so you really shouldnt need to change any site code if my understanding is correct (i could be wrong)

knotty wagon Jan 15, 2024, 7:22 PM

#

Ok

#

Only difference I see is where the js code sits

#

#

now it sits on railway

#

So I just rapleced the tracking code

muted minnow Jan 15, 2024, 7:23 PM

#

the tracking code changed?

knotty wagon Jan 15, 2024, 7:23 PM

#

just this: src="https://umami-production-9cc6.up.railway.app/script.js"

#

data-website-id="08d74cce-a55f-410d-a294-15433f5a1f93" is the same

muted minnow Jan 15, 2024, 7:24 PM

#

you arent going to use a custom domain for that?

knotty wagon Jan 15, 2024, 7:24 PM

#

Yes

muted minnow Jan 15, 2024, 7:25 PM

#

alright then you can just change it back when you do that

knotty wagon Jan 15, 2024, 7:25 PM

#

ok

#

Thank you!

#

Will be back in about an hour

muted minnow Jan 15, 2024, 7:25 PM

#

can i mark this as solved?

knotty wagon Jan 15, 2024, 9:10 PM

#

Yes

#

I'm not getting hits

muted minnow Jan 15, 2024, 9:15 PM

#

are there any console errors when you visit a site that reports to umami?

knotty wagon Jan 15, 2024, 9:16 PM

#

Not sure what you mean

muted minnow Jan 15, 2024, 9:17 PM

#

well when you visit your website that you have reporting to umami, are you seeing any console errors?

knotty wagon Jan 15, 2024, 9:17 PM

#

where would I see that?

muted minnow Jan 15, 2024, 9:17 PM

#

in the browsers console logs (dev tools)

knotty wagon Jan 15, 2024, 9:18 PM

#

https://barnabynagy.com/

Barnaby Nagy

Barnaby Nagy is an Artist, Singer-Songwriter, Public Speaker, Author, Mentor, Hustler, Survivor - Barnabas Nagy

muted minnow Jan 15, 2024, 9:20 PM

#

i am seeing data being sent to umami

knotty wagon Jan 15, 2024, 9:20 PM

#

Me too

muted minnow Jan 15, 2024, 9:20 PM

#

maybe the website id did change?

knotty wagon Jan 15, 2024, 9:20 PM

#

It recorded your visit

#

Perhaps there was just no one visiting haha

muted minnow Jan 15, 2024, 9:20 PM

#

well problem solved

#

all good with umami now?

knotty wagon Jan 15, 2024, 9:29 PM

#

Yes sir

#

All good

#

Thank you!!!

knotty wagon Jan 15, 2024, 9:30 PM

#

muted minnow all good with umami now?

https://tenor.com/view/thanks-barney-ross-sylvester-stallone-the-expendables-2-thank-you-gif-13187459845747433717

Tenor

#Migrate Umami to Railway