Spring boot mysql run db dump code on startup

Question

I want to run the db dump code in the txt file while Spring boot application start. How can i do this? otherwise i must copy-past and run db dump code to the mysql cli with manually.

LunaLissa · Accepted Answer · 2021-06-08 06:09:17Z

1

if you want to LOAD data to database, i prefer to use Liquibase

you can load your data from .csv / .yml / .json / .sql you can run it either before JPA Create Table or after create table.

So if you have a Team you all can have same data and table

if you want to DUMP your database, use liquibase too,

but why you want to dump your data if you have stable data master and it will automatically created everytime you run your app ?

answered Jun 8, 2021 at 6:09

LunaLissa

433 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

gurkan Over a year ago

Thank you for your answer. I will search the Liquibase. As for your question; it's my school project and I want to deliver my project to the teacher as plug and play.

Collectives™ on Stack Overflow

Spring boot mysql run db dump code on startup

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related