How to backup H2 Database and restore to MySQL?

hceccacci 8 years ago

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

Thanks!

Anton Tananaev 8 years ago

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

hceccacci 8 years ago

I will search for. Thank you Anton.

Superego 8 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 Tananaev 8 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.