Migrate to Railway | Railway | Page 1

noble rain Sep 3, 2025, 3:41 PM

#

Hello , i have a worpress project which i used to host on Namecheap , but now i wanna migrate to railway , i did downlod the backup files and i have a Wp_dump.sql file , icreated a new Project using a template for worpress+MariaDb, i also installed and connected railway to my computer terminal , i've been trying for a while to connect to that database and dump the file but i just keep hitting connection errors , i've even opened a public Domain , and yet i can't connect to the database ! please any helpers !! ,

dire girder Sep 3, 2025, 4:47 PM

#

noble rain Hello , i have a worpress project which i used to host on Namecheap , but now i ...

Hey there Kennsey!
So to clarify, the main issue currently is connecting to the database right?

noble rain Sep 3, 2025, 4:50 PM

#

hi , yes i've been into that issue , but i just deleted everything and i'm trying once again with Mysql , just to explain , my objectif is to migrate to railway to host my projects ,and stop using namecheap , but there's a wordpress project (who isn't mine) that i want to also host in railway , this way i only have one host, so my objectif is to take that worpress project and dump its database and its content into railway to host it

untold badge Sep 3, 2025, 4:51 PM

#

Hey, did you import the dump into the db?

noble rain Sep 3, 2025, 4:52 PM

#

on namecheap , they used easyWP , i just downloaded a backup of the project and ended up with 2 compressed files , files(which are the wordpress files ) and database (which is a wp_sump.sql)

dire girder Sep 3, 2025, 4:52 PM

#

noble rain hi , yes i've been into that issue , but i just deleted everything and i'm tryin...

Okay that clears it up wonderful!
What's your current method of hosting the Wordpress site? Are you using an official image or just setting the code up?

noble rain Sep 3, 2025, 4:53 PM

#

untold badge Hey, did you import the dump into the db?

help me do that , so to do the things clean , should i start by creating a wordpress+MariaDb template or Wordpress+Mysql template

dire girder Sep 3, 2025, 4:53 PM

#

noble rain help me do that , so to do the things clean , should i start by creating a wordp...

What was your existing database? MySQL or MariaDB?

untold badge Sep 3, 2025, 4:53 PM

#

noble rain help me do that , so to do the things clean , should i start by creating a wordp...

Install the mariadb/MySQL client on your computer and run this

mysql -h db.example.com -P 3306 -u <user> -p 'my password here' mydb < dump.sql

#

Replace the dummy text

noble rain Sep 3, 2025, 4:54 PM

#

dire girder Okay that clears it up wonderful! What's your current method of hosting the Wor...

it should be just setting the code up in namecheap's server , since i cannot acces em files without using easyWP

noble rain Sep 3, 2025, 4:55 PM

#

untold badge Install the mariadb/MySQL client on your computer and run this mysql -h db.exa...

i did try that but it ends up with timeout , maybe cause the wp_sump.sql file is 3.4GB

dire girder Sep 3, 2025, 4:55 PM

#

Oh my

noble rain Sep 3, 2025, 4:55 PM

#

but sure let's try that again

dire girder Sep 3, 2025, 4:55 PM

#

Around how long into the upload does it timeout?

untold badge Sep 3, 2025, 4:55 PM

#

Oh uhh

noble rain Sep 3, 2025, 4:56 PM

#

yeah and the files compressed are almost 28GB it's so fkin annoying , i fkin hate NoCode devs

dire girder Sep 3, 2025, 4:56 PM

#

Yeah wild...

dire girder Sep 3, 2025, 4:56 PM

#

dire girder Around how long into the upload does it timeout?

_ _

noble rain Sep 3, 2025, 4:56 PM

#

is there a voice channel where i can share my screen ??

dire girder Sep 3, 2025, 4:57 PM

#

Not quite sure there is here. Can you just try sharing screenshots?

noble rain Sep 3, 2025, 4:57 PM

#

dire girder _ _

i don't know exactly like almost 2 min

dire girder Sep 3, 2025, 4:57 PM

#

So it does start uploading it just times out

#

Can I see the actual error you get? As long as it doesnt have any sensitive information in it 😁

noble rain Sep 3, 2025, 4:58 PM

#

#

i'll go with this

noble rain Sep 3, 2025, 4:58 PM

#

dire girder So it does start uploading it just times out

nah i can't connect to the database either , i was trying to upload stuff part by parts

#

lemme show

dire girder Sep 3, 2025, 4:58 PM

#

Oh so it fails to even start? Interesting

noble rain Sep 3, 2025, 5:00 PM

#

#

now, is there a way to conect to the database from shell ??

untold badge Sep 3, 2025, 5:00 PM

#

noble rain now, is there a way to conect to the database from shell ??

Mysql client

untold badge Sep 3, 2025, 5:01 PM

#

untold badge Install the mariadb/MySQL client on your computer and run this mysql -h db.exa...

.

dire girder Sep 3, 2025, 5:01 PM

#

noble rain now, is there a way to conect to the database from shell ??

You can!

#

With Railway connect https://docs.railway.com/reference/cli-api#connect

CLI Reference | Railway Docs

Learn about the Railway CLI commands.

noble rain Sep 3, 2025, 5:02 PM

#

looks like host is empty

dire girder Sep 3, 2025, 5:02 PM

#

Have you done an initial deployment of that service?

dire girder Sep 3, 2025, 5:03 PM

#

dire girder With Railway connect https://docs.railway.com/reference/cli-api#connect

noble rain Sep 3, 2025, 5:03 PM

#

No , should i ? cause i want to dump the database anyways

dire girder Sep 3, 2025, 5:03 PM

#

You should start up the database at least once to "create" it

#

then once the service is running you should be able to railway connect to it and execute shell commands.

noble rain Sep 3, 2025, 5:04 PM

#

untold badge Sep 3, 2025, 5:05 PM

#

Click deploy on railway

dire girder Sep 3, 2025, 5:05 PM

#

Have you done an initial deployment via the web?

noble rain Sep 3, 2025, 5:05 PM

#

dire girder Sep 3, 2025, 5:06 PM

#

Hmmm, railway might have not refreshed yet? Maybe close and reopen it...

#

it should show that off as it does have a volume

noble rain Sep 3, 2025, 5:07 PM

#

dire girder Hmmm, railway might have not refreshed yet? Maybe close and reopen it...

nop

untold badge Sep 3, 2025, 5:07 PM

#

noble rain

Shouldn’t it have crashed if the env variables were wrong?

noble rain Sep 3, 2025, 5:07 PM

#

i've even tried to expose the database

dire girder Sep 3, 2025, 5:07 PM

#

Can you link the template you are using? interested in trying myself

noble rain Sep 3, 2025, 5:08 PM

#

just go to template and search for wordpress , it's the most used one

#

wordpress+MariaDb

dire girder Sep 3, 2025, 5:08 PM

#

checking 👍

noble rain Sep 3, 2025, 5:10 PM

#

should've created my own stuff instead of importing the templates ?

dire girder Sep 3, 2025, 5:10 PM

#

Well, i dont think that theres that much of an issue using the template

#

noble rain Sep 3, 2025, 5:10 PM

#

like having the stuff setup locally then try to upload them to railway ??

dire girder Sep 3, 2025, 5:10 PM

#

So, I deployed and connected to the mariadb service

#

and thats very interesting

#

Let me try one more thing, I have a theory

noble rain Sep 3, 2025, 5:11 PM

#

wordpress works flawlessly tho

dire girder Sep 3, 2025, 5:11 PM

#

That theory is, do you have the mysql client installed on your machine?

noble rain Sep 3, 2025, 5:12 PM

#

i feel like i'll be exporting stuff one by one !

noble rain Sep 3, 2025, 5:12 PM

#

dire girder That theory is, do you have the mysql client installed on your machine?

i do

untold badge Sep 3, 2025, 5:12 PM

#

untold badge Install the mariadb/MySQL client on your computer and run this mysql -h db.exa...

Do this then

noble rain Sep 3, 2025, 5:13 PM

#

but wut is the -h ?

dire girder Sep 3, 2025, 5:13 PM

#

So Railway CLI looks like it doesnt recognize this MariaDB instance. Let's try via public endpoint

untold badge Sep 3, 2025, 5:13 PM

#

noble rain but wut is the -h ?

The host

noble rain Sep 3, 2025, 5:13 PM

#

oh should i use the wordpress one ?

#

violet dust Sep 3, 2025, 5:14 PM

#

dire girder and thats very interesting

MariaDB doesn't seems to have a shell by default on $PATH so that's why railway connect fails as according to the docs (?)

dire girder Sep 3, 2025, 5:14 PM

#

use the

dire girder Sep 3, 2025, 5:14 PM

#

violet dust _MariaDB doesn't seems to have a shell by default on $PATH so that's why `railwa...

Well, mariaDB is also mysql compat

noble rain Sep 3, 2025, 5:14 PM

#

dire girder use the

lemme try that

dire girder Sep 3, 2025, 5:14 PM

#

I might actually be wrong on this. If maria and mysql are cross compat it might be interesting to try a template with mysql instead of mariadb

noble rain Sep 3, 2025, 5:15 PM

#

there's a private host tho

dire girder Sep 3, 2025, 5:16 PM

#

are you on windows or mac?

noble rain Sep 3, 2025, 5:16 PM

#

linux

dire girder Sep 3, 2025, 5:17 PM

#

unix cli cool

noble rain Sep 3, 2025, 5:17 PM

#

parrot OS

dire girder Sep 3, 2025, 5:18 PM

#

Trying a couple of configuration things real quick. Might be on to something

untold badge Sep 3, 2025, 5:18 PM

#

noble rain parrot OS

apt install mariadb-client

#

Or whatever your package manager is

#

Then run the command I sent but replace the dummy text

noble rain Sep 3, 2025, 5:20 PM

#

dire girder Sep 3, 2025, 5:21 PM

#

That has your password in it, would suggest changing that for future ref 😁

#

I'm testing out the wordpress + mysql template

noble rain Sep 3, 2025, 5:21 PM

#

dire girder That has your password in it, would suggest changing that for future ref 😁

idc ket's just make it work and i'll be building another project

untold badge Sep 3, 2025, 5:21 PM

#

noble rain

Use the public endpoint

dire girder Sep 3, 2025, 5:22 PM

#

if you dont have this set on your mariadb thing you should

noble rain Sep 3, 2025, 5:22 PM

#

so i'll setup a public endpoint once again right ?

dire girder Sep 3, 2025, 5:23 PM

#

noble rain so i'll setup a public endpoint once again right ?

I think... Unsure how similar the settings for maria/mysql are compared to postgres (which i mainly use)

#

This mysql template is looking promising

noble rain Sep 3, 2025, 5:23 PM

#

untold badge Sep 3, 2025, 5:24 PM

#

Also uhh, maybe change the password

dire girder Sep 3, 2025, 5:24 PM

#

Its a dummy project rn he'll change it later

untold badge Sep 3, 2025, 5:24 PM

#

Ah alr

dire girder Sep 3, 2025, 5:24 PM

#

Alright so!

#

mysql client works on this mysql template

noble rain Sep 3, 2025, 5:24 PM

#

yeah i did

dire girder Sep 3, 2025, 5:24 PM

#

#

Was able to connect on this

noble rain Sep 3, 2025, 5:24 PM

#

dire girder mysql client works on this mysql template

if you have a template working just give me it at this point

untold badge Sep 3, 2025, 5:25 PM

#

noble rain if you have a template working just give me it at this point

It’s just what you’re using prob

dire girder Sep 3, 2025, 5:25 PM

#

https://railway.com/new/template/yG1Jw8

dire girder Sep 3, 2025, 5:25 PM

#

dire girder https://railway.com/new/template/yG1Jw8

This is the template that I used.

#

Looks like it has 100% success across 237 active projects

noble rain Sep 3, 2025, 5:26 PM

#

.

dire girder Sep 3, 2025, 5:26 PM

#

Railway CLI also works over this

noble rain Sep 3, 2025, 5:26 PM

#

looks like i ecceded the limit does the deleted projects also counts ?

untold badge Sep 3, 2025, 5:26 PM

#

noble rain looks like i ecceded the limit does the deleted projects also counts ?

Delete the old one

dire girder Sep 3, 2025, 5:26 PM

#

noble rain looks like i ecceded the limit does the deleted projects also counts ?

Nope! Just delete the old one or choose to add it to an existing project

#

noble rain Sep 3, 2025, 5:27 PM

#

looks like i cant

dire girder Sep 3, 2025, 5:28 PM

#

So you are unable to delete the existing project on the free plan?

noble rain Sep 3, 2025, 5:28 PM

#

i'm just gonna cancel deletion of this one

#

oh maybe delete permently

dire girder Sep 3, 2025, 5:29 PM

#

I think they are scheduled deletions. 30 days of grace when you click that in case of misclick

noble rain Sep 3, 2025, 5:29 PM

#

allright it worked

untold badge Sep 3, 2025, 5:29 PM

#

noble rain oh maybe delete permently

Yeah

noble rain Sep 3, 2025, 5:30 PM

#

alright let's try with this

dire girder Sep 3, 2025, 5:30 PM

#

So you can grab the connection URI from the MySQL variables

#

untold badge Sep 3, 2025, 5:30 PM

#

dire girder So you can grab the connection URI from the MySQL variables

That’s prob an internal one

dire girder Sep 3, 2025, 5:30 PM

#

And connect with the native mysql client.
Or just railway link > choose project > choose env > select service

dire girder Sep 3, 2025, 5:30 PM

#

untold badge That’s prob an internal one

it is not

untold badge Sep 3, 2025, 5:30 PM

#

Ah

dire girder Sep 3, 2025, 5:31 PM

#

Then once you select the right project run railway connect and you should have access to the mysql console.

noble rain Sep 3, 2025, 5:31 PM

#

#

nice

#

now to dump

dire girder Sep 3, 2025, 5:31 PM

#

There you go! Now dumping should work. Let me know how that looks

untold badge Sep 3, 2025, 5:34 PM

#

untold badge Install the mariadb/MySQL client on your computer and run this mysql -h db.exa...

^^

dire girder Sep 3, 2025, 5:34 PM

#

No need. railway connect does one for you

dire girder Sep 3, 2025, 5:34 PM

#

noble rain nice

Kennsey is currently in mysql shell as you can see here.

untold badge Sep 3, 2025, 5:34 PM

#

Doesn’t he want to import the dump?

dire girder Sep 3, 2025, 5:34 PM

#

You can do so via that iirc

untold badge Sep 3, 2025, 5:34 PM

#

Pretty sure you can’t, that’s just a “terminal”, may be wrong

noble rain Sep 3, 2025, 5:35 PM

#

untold badge Pretty sure you can’t, that’s just a “terminal”, may be wrong

yes

#

i'm trying the railway run

#

do you have a better suggestion >?

untold badge Sep 3, 2025, 5:35 PM

#

Mariadb client

dire girder Sep 3, 2025, 5:35 PM

#

we're now using mysql 😁

untold badge Sep 3, 2025, 5:36 PM

#

Or MySQL client

#

They are cross compatible

dire girder Sep 3, 2025, 5:37 PM

#

mysql --protocol=TCP --connect-timeout=30 --ssl-mode=PREFERRED -h HOSTURL -P PORT -u root --password=PASSWORD railway < ./path

should work

#

Obviously replacing HOSTURL PORT and PASSWORD alongside ./path

#

dumps are very annoying to backup and work with

#

It'll probably warn "its not best to use pasword in cli!" but thats alright

noble rain Sep 3, 2025, 5:39 PM

#

i'm running this one and it's takin sometime

dire girder Sep 3, 2025, 5:40 PM

#

Yeah I'd give it a good minute. Will take a bit

noble rain Sep 3, 2025, 5:40 PM

#

maybe it worked but the dump is heavy that's why

dire girder Sep 3, 2025, 5:41 PM

#

noble rain maybe it worked but the dump is heavy that's why

Your command will finish running when its done.

noble rain Sep 3, 2025, 5:41 PM

#

hopefully it doean't timeout

dire girder Sep 3, 2025, 5:41 PM

#

It shouldnt time out I don't think

noble rain Sep 3, 2025, 5:41 PM

#

i

#

i'll try urs

dire girder Sep 3, 2025, 5:41 PM

#

Oh?

#

yeah thats running over railway run Hmmmmm

untold badge Sep 3, 2025, 5:42 PM

#

noble rain

id recommend using mysql cli, not railway run

dire girder Sep 3, 2025, 5:42 PM

#

Thats what hes doing now 😁

noble rain Sep 3, 2025, 5:43 PM

#

mysql --protocol=TCP --connect-timeout=30 --ssl-mode=PREFERRED -h HOSTURL -P PORT -u root --password=PASSWORD railway < ./path

untold badge Sep 3, 2025, 5:43 PM

#

noble rain i'm running this one and it's takin sometime

"railway run"

noble rain Sep 3, 2025, 5:43 PM

#

for this cmd should i setup a TCP ?

dire girder Sep 3, 2025, 5:43 PM

#

It should be enabled already. If you look at settings > network

noble rain Sep 3, 2025, 5:44 PM

#

dire girder Sep 3, 2025, 5:44 PM

#

so for me on the mySQL instance

#

On this not the docker image

noble rain Sep 3, 2025, 5:44 PM

#

oh My bad i was on the docker image

dire girder Sep 3, 2025, 5:44 PM

#

all good!

noble rain Sep 3, 2025, 5:47 PM

#

wut would u do on --ssl-mode=PREFERRED ?

dire girder Sep 3, 2025, 5:48 PM

#

iirc thats just the plain mode 😂

untold badge Sep 3, 2025, 5:48 PM

#

noble rain wut would u do on --ssl-mode=PREFERRED ?

its optional

dire girder Sep 3, 2025, 5:48 PM

#

According to google: "enables encryption if available."

noble rain Sep 3, 2025, 5:48 PM

#

went with this

dire girder Sep 3, 2025, 5:49 PM

#

Let me know how it goes

dire girder Sep 3, 2025, 5:53 PM

#

noble rain went with this

Hows it looking?

noble rain Sep 3, 2025, 5:53 PM

#

still running

#

#

hmm looks like working

#

it's still running tho

dire girder Sep 3, 2025, 5:54 PM

#

Great its uploading then!

noble rain Sep 3, 2025, 5:55 PM

#

about the other wordpress files how do you think i can import them ?

#

add me friend btw ❤️

dire girder Sep 3, 2025, 5:56 PM

#

Well. I am unfortunately not as familiar with wordpress as I'd like to be. I can give it a peek and see what others have done

noble rain Sep 3, 2025, 5:58 PM

#

dire girder Well. I am unfortunately not as familiar with wordpress as I'd like to be. I can...

most of people just use plugins

#

but if just the database is sumped that's a huge progress for me

#

i owe u guys big time

dire girder Sep 3, 2025, 5:58 PM

#

Yeah I sadly just dont know wordpress well enough to say "this is your answer for wordpress!"

#

But for databases I live in those

noble rain Sep 3, 2025, 5:59 PM

#

idk what's wrong with that MariDB connections , is it too secure or wut ?

noble rain Sep 3, 2025, 5:59 PM

#

dire girder Yeah I sadly just dont know wordpress well enough to say "this is your answer fo...

DW i hate wordpress 2 x)

dire girder Sep 3, 2025, 5:59 PM

#

noble rain idk what's wrong with that MariDB connections , is it too secure or wut ?

It might have just been a different service that railway didnt recognize as a standard "database"

#

compared to mongo/pg/mysql

#

which is funky but oh well!

#

Is it still uploading the sql dump?

noble rain Sep 3, 2025, 6:02 PM

#

yes xD

#

should've added a checkpoint dot

dire girder Sep 3, 2025, 6:03 PM

#

Okay cool! Well, is that all for this thread haha?

noble rain Sep 3, 2025, 6:03 PM

#

well we fixed my database connection for sure ,by using a different database x)

#

so yeah that's why i openned this thread

dire girder Sep 3, 2025, 6:04 PM

#

Yeah thats still funky why the shell wasn't connecting on mariadb hmm. Something to remember

noble rain Sep 3, 2025, 6:05 PM

#

question

dire girder Sep 3, 2025, 6:05 PM

#

Answer picassoface

noble rain Sep 3, 2025, 6:05 PM

#

will i hit the max volume ?

dire girder Sep 3, 2025, 6:06 PM

#

If you said your SQL dump was ~3g and your volume only has 500mb yes you will.

noble rain Sep 3, 2025, 6:06 PM

#

the dump file is 3g

#

but wait i should see that colume progress right ?

#

volume *

dire girder Sep 3, 2025, 6:07 PM

#

Volume progress?

#

Theres a pretty good chance you reach the max with a dump that large unless I'm missing something.

noble rain Sep 3, 2025, 6:08 PM

#

this should do the trick ?

dire girder Sep 3, 2025, 6:08 PM

#

It sure should! Thats the plan I currently have.
If you really need more data (then what the pro plan provides) you can create another thread and we can talk to the team about expanding volume size.

noble rain Sep 3, 2025, 6:09 PM

#

wtf even is this website having a freaking 3gb database ! i fkin hate wordpress

dire girder Sep 3, 2025, 6:10 PM

#

-# You and me both 😂

noble rain Sep 3, 2025, 6:10 PM

#

this is so not normal

#

the volume Usage doesn't progress tho i'm worried

#

if the dump file fails i'll have to clean the database and try again ?

dire girder Sep 3, 2025, 6:11 PM

#

I believe so yes. I'm not sure if sql dumps resume or not.

#

Or if they clear progress if fail

noble rain Sep 3, 2025, 6:13 PM

#

FReak !

#

i upgraded the size and it aboarted

dire girder Sep 3, 2025, 6:13 PM

#

Checks out that it would do that 😁

noble rain Sep 3, 2025, 6:14 PM

#

hmm should i just run the command again , or do i have to clean the database

#

cause it's still full

dire girder Sep 3, 2025, 6:14 PM

#

I'd clean and run again to be safe

noble rain Sep 3, 2025, 6:14 PM

#

wait

dire girder Sep 3, 2025, 6:14 PM

#

waiting

noble rain Sep 3, 2025, 6:14 PM

#

maybe it failed for another reason

#

#

was it just a coincidnce ?

dire girder Sep 3, 2025, 6:15 PM

#

I'd just delete and restart yeah.

noble rain Sep 3, 2025, 6:15 PM

#

naaah i don't think so , it's probably the resizing

#

wait i can't drop db

untold badge Sep 3, 2025, 6:16 PM

#

change the dump

#

so its the correct db name and such

noble rain Sep 3, 2025, 6:17 PM

#

yeah i just droped railways database and recreated it x)

#

i give 5gb to the database , now if i don't reach the 5GB and for instance it's just 900MB i can downsize it right ?

dire girder Sep 3, 2025, 6:19 PM

#

You can but I'd suggest giving it some padding in case it somehow goes over.
When you allocate 5g it doesnt remove a flat 5g from your available storage. If your actual data only takes 900mb it only costs 900mb worth

#

does that make sense?

noble rain Sep 3, 2025, 6:19 PM

#

Oh!

#

that's better then

#

i've got a proplan now
@Pro Plan - This role is for any member of a Team building their awesome product on Railway. Company? We help you with migrations from cloud platforms of varying sorts.
i should be able to get a support who will help me through all the migartion right ?

dire girder Sep 3, 2025, 6:21 PM

#

I'm actually not too sure on that. This is a community bounty which means its open for the community to help

noble rain Sep 3, 2025, 6:21 PM

#

i guess there's progress here

#

already reaching 1GB unbelievable

#

wait i did select 5GB but it's written 32 GB

#

but as u said it doesn't matter how much i allocated , what matter is how much i'm using

dire girder Sep 3, 2025, 6:24 PM

#

Yep! Usage based not allocation based

noble rain Sep 3, 2025, 6:31 PM

#

hoepfully the database dump would be enough for the whole website

#

because 3GB it gotta be populating the tables

#

ain't no way it's just the structure

#

4GB x)

#

@dire girder Do u mind adding me a friend , i really appreciate ur help ! ❤️

dire girder Sep 3, 2025, 6:35 PM

#

Hey! My DMs are open but I've slowly stopped adding a bunch of people unless I need to. Nothing personal at all 😁

noble rain Sep 3, 2025, 6:35 PM

#

wohoo looks like it's finished 0.0

dire girder Sep 3, 2025, 6:37 PM

#

Yay!

#

Am I good to close out this thread?

noble rain Sep 3, 2025, 6:38 PM

#

fine then

dire girder Sep 3, 2025, 6:38 PM

#

Happy to have helped picassoface

#Migrate to Railway