Mysql migration crashed
Hello,I use the automated plugin option to migrate my myql server, however I get an error in the logs when I perform the step "Migrate data".
Project Id: f45cbc3f-9b17-4f9e-bd19-1bcb04bc9e7b
9 Replies
Project ID:
f45cbc3f-9b17-4f9e-bd19-1bcb04bc9e7bThread has been flagged to Railway team by @Brody.
Thanks for the flag Brody.
Looking into this @MiguelHL
GitHub
mysql-plugin-migration/migrate.sh at 38068cb24b848390a06ec331aa8450...
Contribute to railwayapp-templates/mysql-plugin-migration development by creating an account on GitHub.
"Set the OVERWRITE_DATABASE environment variable to overwrite the new database."
It seems the new DB is not empty
I think what you need to do is
set: OVERWRITE_DATABASE in this service: https://railway.app/project/f45cbc3f-9b17-4f9e-bd19-1bcb04bc9e7b/service/cfaa4e21-0a36-4f53-8abd-3deac1f58a60
Railway
404 - Page not found
Railway is an infrastructure platform where you can provision infrastructure, develop with that infrastructure locally, and then deploy to the cloud.
to anything but an empty string
and restart the migration
unless you have put production data in to the new database for some reason
in that case, you have opened a can of worms and I don't know how to close it without a lot more information about the data
Add the environment variable OVERWRITE_DATABASE and restart the migration but still with the same error, I attach an image with all the logs that returns the instance
I was checking, I think the problem is with the dependencies of the tables when migrating, if I am not mistaken the migration is done alphabetically and not in order of the dependencies of the tables
From the logs you are not getting to that step at all: section "Dumping database from PLUGIN_URL"
also mysqldump should be able to handle that condition
I am not sure what is going on here
I will look into it more within the next 24 hours