How to backup H2 Database and restore to MySQL?

hceccacci7 years ago

There is any tutorial to backup H2 Database and restore to MySQL?

Thanks!

Anton Tananaev7 years ago

No official one. You can probably use some third party JDBC migration tool.

hceccacci7 years ago

I will search for. Thank you Anton.

Superego6 years ago

Hello here.
I'm also stuck with that question. I want to update Traccar, so need to backup all etc.

Is there a tool what can be used? I have H2. But can't run it while traccar is running. How can I stop traccar process? Will H2 help backup database?

Anton Tananaev6 years ago

This is how you stop Traccar on Linux or Mac:

/opt/traccar/bin/stopDaemon.sh

H2 database is stored in a file (in "data" folder). To create a backup just copy file or files somewhere.