Topics

Railway•13mo ago

How can I create daily backups of my Mysql database?

Hi everyone! I want to create daily backups of my Mysql database, I'm not sure if I should create an app with a cronjob or something like that. Can anyone help me with this? There's no option in the project settings. Thanks. ProjectID f4ffaf00-bf8e-4fc7-8e95-9d64d9995b8d

Solution:

you could easily modify the template linked in this tutorial to do a mysql backup instead https://blog.railway.app/p/automated-postgresql-backups...

Jump to solution

84 Replies

Percy•13mo ago

Project ID: f4ffaf00-bf8e-4fc7-8e95-9d64d9995b8d

Solution

Brody•13mo ago

you could easily modify the template linked in this tutorial to do a mysql backup instead https://blog.railway.app/p/automated-postgresql-backups

danielthames•13mo ago

Hey I want to work on this now! @Brody I saw that the example contains a dockerfile with the postgree config inside is that correct? the postgree db runs inside the docker? Do I need a docker file?

danielthames•13mo ago

this is my repo... independent mysql db I plan to create the project and then add it to this project

Brody•13mo ago

no what you are referring to would just be the postgres client library and the dump utility

danielthames•13mo ago

I have my node cron app ready to get the mysql db and then upload it to cloudinary - this is based in the example with postgree here you can see the screenshot to dump the file

danielthames•13mo ago

Do you see something wrong? Should it work with the database shown above?

Brody•13mo ago

looks like it could work to me, but it's not like I've ever done this type of thing before

danielthames•13mo ago

ok what I'm going to have is something like this

danielthames•13mo ago

I will push the project and see what happens

danielthames•13mo ago

I'm going to use a test project just in case

Brody•13mo ago

sounds good

danielthames•13mo ago

It doesn't work

danielthames•13mo ago

basically the mysql db doesn't exists for my cron job

Brody•13mo ago

are you installing mysqldump into the container?

danielthames•13mo ago

it's not a container Should I work with docker? I need to migrate my db from standalone railway mysql to a docker container with mysql + cronApp ?

Brody•13mo ago

railway uses docker, so you can just install mysqldump the same way that the postgres backup cron job app installs pg_dump

danielthames•13mo ago

there's not a pg_dump; but I got you I'm going to run -> npm i mysqldump

Brody•13mo ago

pg_dump is installed with postgresql-client in the templates dockerfile

danielthames•13mo ago

ok I see that it doesn't work only installing it; but I see what I can do with this package I will make some modifications and try it

Brody•13mo ago

you don't need to change your code lol just install mysqldump in the container whether you do that with a dockerfile or a railway.json file is up to you

danielthames•13mo ago

ok, I'm going to create this exact same file in my cronApp; changing pg_dump to mysqldump

danielthames•13mo ago

https://github.com/danielthames360/cronJob by the way, this is my repo

GitHub

GitHub - danielthames360/cronJob

Contribute to danielthames360/cronJob development by creating an account on GitHub.

Brody•13mo ago

mysqldump doesn't appear to be an alpine package

danielthames•13mo ago

yup!

danielthames•13mo ago

I'm almost there

danielthames•13mo ago

29c518cd-5f54-47a7-841e-9a5f4c8b2c3d project test ID

danielthames•13mo ago

final docker file just change the postgre client to mysql-client

Brody•13mo ago

are you checking if these are actually available alpine packages?

danielthames•13mo ago

it's trying to make the bkp; I'm getting an error now

danielthames•13mo ago

https://tenor.com/view/dug-cone-shame-sad-up-gif-21986026

Tenor

danielthames•13mo ago

Brody•13mo ago

let's not resort to chat gpt lol

danielthames•13mo ago

lol

Brody•13mo ago

add mysql in line 22

danielthames•13mo ago

RUN apk add --update --no-cache mysql mysql-client nodejs npm same error after deploy it https://chrisshennan.com/blog/fixing-authentication-plugin-cachingsha2password-cannot-be-loaded-errors I'm not sure Hey man! we can continue tomorrow if you want; I don't want to waste your Friday time cryingman

cryingman

I'll delete this message...

Brody•13mo ago

nah it's good my Friday night has already come to an end and tbh I don't actually know why the original template uses a dockerfile, everything it does can easily be configured through a railway.json file and built with nixpacks once I'm back on my computer in a bit I can try to slap together a railway.json file for you

danielthames•13mo ago

I appreciate your time! and help If you know anything I can do to make it work would be fantastic. I am not in any hurry. So, I can wait pattienly

Brody•13mo ago

in the mean time remove mysqldump from your package.json

danielthames•13mo ago

Done! I've also moved the dev dependencies to their correct place

Brody•13mo ago

delete your Dockerfile and give this railway.json file a try

{
  "$schema": "https://railway.app/railway.schema.json",
  "build": {
    "builder": "NIXPACKS",
    "nixpacksPlan": {
      "phases": {
        "setup": {
          "nixPkgs": ["...", "mysql80"]
        }
      }
    }
  },
  "deploy": {
    "numReplicas": 1,
    "restartPolicyType": "ON_FAILURE",
    "restartPolicyMaxRetries": 10
  }
}

{
  "$schema": "https://railway.app/railway.schema.json",
  "build": {
    "builder": "NIXPACKS",
    "nixpacksPlan": {
      "phases": {
        "setup": {
          "nixPkgs": ["...", "mysql80"]
        }
      }
    }
  },
  "deploy": {
    "numReplicas": 1,
    "restartPolicyType": "ON_FAILURE",
    "restartPolicyMaxRetries": 10
  }
}

danielthames•13mo ago

weird error

Brody•13mo ago

one moment change your start script to node dist/index.js

danielthames•13mo ago

https://tenor.com/view/ah-shit-here-we-go-again-ah-shit-cj-gta-gta-san-andreas-gif-13933485

Tenor

Brody•13mo ago

the postgre backup template used node 18, try using node 18 set engines.node = 18 in your package.json

danielthames•13mo ago

I think I'm almost there

Brody•13mo ago

lol what solved those es5 errors

danielthames•13mo ago

it was... Firstly, I was working with javascript only. Then, I migrated the project to typescript and I don't needed the type: module on package.json anymore

Brody•13mo ago

removed the module type, makes sense since node 16 probably doesnt support the module type

danielthames•13mo ago

https://tenor.com/view/the-pursuit-of-happiness-will-smith-success-joy-happiness-gif-3517714

Tenor

danielthames•13mo ago

Brody•13mo ago

well is the file in cloudinary valid?

danielthames•13mo ago

danielthames•13mo ago

I'm gonna give it a try in my local db

Brody•13mo ago

yeah was just about to say to do a test restore

danielthames•13mo ago

oh; these are the lines maybe I need to add/update some lines of my mysqldump instruction in order to have a fully backup with schema creation, data and so on.

danielthames•13mo ago

by the way, this was an empty db only for test purpose .

Brody•13mo ago

sounds plausible, ive never used mysqldump

danielthames•13mo ago

lol the first instrucctions says -> --no-create-db --no-create-info --skip-comments mildpanic

mildpanic

danielthames•13mo ago

after

Brody•13mo ago

yeah that sounds like stuff you'd want

danielthames•13mo ago

awesome awesome awesome!!

Brody•13mo ago

you should totally make this into a template, if that's something you'd want to do

danielthames•13mo ago

I will update the code to work with a specific folder or some specific things of my liking (cloudinary stuff too). Tomorrow morning I will test this project with the real production application, and make the cron work based on a configuration. With that I think I'll be all set and the project will be fully configurable. I'll attach some screenshots here

Brody•13mo ago

awesome

danielthames•13mo ago

https://tenor.com/view/michael-scott-dwight-schrute-the-office-raise-the-roof-gif-21488302

Tenor

danielthames•13mo ago

thank you very much Brody! have a good rest

Brody•13mo ago

haha no problem, happy to help!

danielthames•13mo ago

definitely! I'm not sure how to do that but just let me know what I can do tomorrow, I'll clean the code and do what I described above.

Brody•13mo ago

https://railway.app/account/templates New Template add your public repo, and configure all the variables and such, if you need any help with that tomorrow feel free to ask me

danielthames•13mo ago

hey Brody! I have the app ready to create the template https://github.com/danielthames360/mysqlCloudinaryBackups Would you suggest something?

GitHub

GitHub - danielthames360/mysqlCloudinaryBackups: Node.js applicatio...

Node.js application that performs scheduled backups of your MySQL database and uploads them to Cloudinary for secure storage. - GitHub - danielthames360/mysqlCloudinaryBackups: Node.js application ...

danielthames•13mo ago

Should I have to add the variables I use?

Brody•13mo ago

just add all the variable names you have in your .env.example file, with no default value like how this does it https://railway.app/new/template/I4zGrH

danielthames•13mo ago

https://railway.app/template/mT6Hiw?referralCode=rRjTM0

Railway

Deploy mysqlCloudinaryBackups on Railway

Railway is an infrastructure platform where you can provision infrastructure, develop with that infrastructure locally, and then deploy to the cloud.

Brody•13mo ago

danielthames•13mo ago

https://tenor.com/view/kill-myself-seatbelt-gif-13298646

Tenor

Brody•13mo ago

now you just have to write info text for it and publish it

danielthames•13mo ago

where? how?

Brody•13mo ago

ohhh publishing templates is a beta feature so just type /beta here so are you gonna upgrade to the dev plan too? otherwise you won't be able to run the backup 24/7

danielthames•13mo ago

yeap! my client has their credit card in his account we have the production project there I don't need a plan for my personal account yet.

danielthames•13mo ago

Brody•13mo ago

sounds good

danielthames•13mo ago

Ok done! thanks for the patience Brody

Brody•13mo ago

no problem, im happy i could help!

Hang out with other likeminded developers & talk about all things https://railway.app on the Railway Community Server.

24KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

Resource not supported on express NodeJS appPretty much what the title says. When I deploy my project it deploys fine, and one of the API routes I CANT INSTALL SCOOP ON MY SYSTEM TO INSTALL RAILWAYIV watched several vedious on how to install scoop on my syatem. but unfortunately i cannot pass th How can I load opus into my project?I'm having trouble deploying a Django apiDecidí subir mi proyecto Django en railway, busque la documentacion y decía que tengo que : 1) desc Java Maven ProjectI want to deploy my maven project to java with postgres database, but I get the following error:I am trying to host a Django project, with reference to the django template provided by railway...This is my build-logs: ============== Using Nixpacks ============== context: 5b586c81b1822e03 i need help to verify my accounti can't verify. i use my GitHub acc and it just says "Unfortunately, the attached GitHub account doe JWT Best Practice?Hey all - perhaps a dumb Q. I'm using a JWT file (JSON) for an SDK auth. What's the best way to u Need help to use custom domain (hostinger)i have bought domain at hostinger, in railway i have deploy it using railway domain. i have add cus i need help to verify my acci can't verify. i use my GitHub acc and it just says "Unfortunately, the attached GitHub account doe