R
Railway

✋|help

mysqldump?

Ggazhay4/5/2023
Is there a way to use railway cli to execute a mysql dump? I tried railway run with the appropriate variables from the ui but I can't see the correct data. Without specifying a database, it dumps system tables, if I try to specify database "railway" (as the ui suggests) I get "table not found" errors.
PPercy4/5/2023
Project ID: b97a420c-bc3e-4bd6-89e8-a06b1e2176bd
PPercy4/5/2023
You might find these helpful: - Services | Railway Docs
⚠️ experimental feature
Ggazhay4/5/2023
b97a420c-bc3e-4bd6-89e8-a06b1e2176bd
BBrody4/5/2023
screenshot of commands run so I can understand what you've tried
Ggazhay4/6/2023
railway run mysqldump mysql -hcontainers-us-west-67.railway.app -uroot -p<redacted> --port 5721 --protocol=TCP railway
railway run mysqldump mysql -hcontainers-us-west-67.railway.app -uroot -p<redacted> --port 5721 --protocol=TCP railway
BBrody4/6/2023
flags are being merged with their values, thats just a formatting error right?
Ggazhay6/21/2023
Shouldn't matter, (other than password flag)
railway run mysqldump mysql -h containers-us-west-67.railway.app -u root -p --port 5721 --protocol=TCP railway
railway run mysqldump mysql -h containers-us-west-67.railway.app -u root -p --port 5721 --protocol=TCP railway
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
mysqldump: Couldn't find table: "railway"
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
mysqldump: Couldn't find table: "railway"
railway run mysqldump mysql -h containers-us-west-67.railway.app -u root -p --port 5721 --protocol=TCP --databases railway
railway run mysqldump mysql -h containers-us-west-67.railway.app -u root -p --port 5721 --protocol=TCP --databases railway
also just dumps everything from database 'mysql' as below
mysqldump: [Warning] Using a password on the command line interface can be insecure.
-- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64)
--
-- Host: containers-us-west-67.railway.app Database: mysql
mysqldump: [Warning] Using a password on the command line interface can be insecure.
-- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64)
--
-- Host: containers-us-west-67.railway.app Database: mysql
Just FYI I ended up writing an export script instead. May need to revisit this as I cannot get a full db backup through sequelize now and kinda need mysqldump to work.
BBrody6/21/2023
?

Looking for more? Join the community!

Want results from more Discord servers?
Add your server
Recommended Posts
Limit on post requests at one timeIs there a limit on post requests at one time? I try to upload more then 1 image at a time on CloudiEmpty vercel env varRailway's pushing an empty env var, `DATABASE_URL`, to vercel. The variable is set up in railway as CLI: railway logs shows logs from old deploymentI've linked the railway CLI to my project. When I execute `railway logs`, I get logs from an old deStrapi app deployHello guys, i did a website for someone with React and Strapi+GraphQL. Now i have to make it live buDeployment removal failsCall to `https://backboard.railway.app/graphql/internal?q=deploymentRemove` fails, it never returns Container Start Failure! "docker": executable file not found in $PATH: unknownTried to add Docker? but got error Here full log: ```fix Sticky cache enabled ======================Prod + Dev (PR) EnvironmentsHi there, I would like to understand how to achieve the following workflow. Production Env: OnlyIs SQL supposed to use this much memory?Hey I am using a mysql db and the memory usage is 500mb? I barely have this in my db.. Is it supposeLimit resources in developer planI created 2 services (postgres and api) when I was testing in the Trial Plan. Now I upgraded my accHow do I delete JUST the service, not my database?rust build faillingseems cant connect to crate.io and rust.lang.orgHelp running flask appThis is my first time using flask so bear with me... here is my app.py code ``` import mysql.connecrailway run 🚨 Not authorized! but can't login``` ❯ yarn dx yarn run v1.22.19 $ railway run --service=app --environment=dev-$(whoami) run-p dx:* -Get an error when uploading a large file through my app: rror: abortedat connResetException```Error: aborted at connResetException (node:internal/errors:711:14) at abortIncoming (node:_http_sHow to connect to another instance without link a public domainI Want to connect with the app "browserless" but I don't want to expose this app for internet. I onlhttpOnly cookies not being set in production using koaHi, I'm trying to set httponly cookies in my koajs app but to no avail I have a custom domain in raSetting up MinIO serviceI set up a docker-orchestrated MinIO service locally. Given there is no service template available fMultiple services on a single domainHi! I have 3 services: API (Backend), Landing that uses this API (Frontend) and a Documentation for Deploy from GitHub Repo exits without reasonThis is for a Flask app, but I could see how it could get confused. What/why?Postgresql paused after month limit restoreHi, it´s supposed that datatabases should be restored after month limit, but my databases are still