Upgrade/migrate Traccar to new server 4.12 -> 5.5

Superego2 years ago

Hi,
Traccar is very reliable project. But now need a helping advice.

Recently needed to migrate from old server. So followed documentation (https://www.traccar.org/upgrading-traccar/) - backup MySQL, config .xml, installed new version of Traccar. Checked that server runs and is accessible from internet.

But then started to import backed up database. And failed. Of course played with php.ini limitations on .sql imports. But stuck even worse - database not restored, Traccar server is up, but don't listen to any ports:

root@vps:/# ps -aux | grep traccar
root     1056461 79.7  6.7 2484068 133136 ?      Ssl  07:42   0:07 /opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml
root     1056810  0.0  0.1   7004  2108 pts/1    S+   07:42   0:00 grep --color=auto traccar
root@vps:/# sudo netstat -tulpn
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      760/mysqld
tcp        0      0 127.0.0.53:53           0.0.0.0:*               LISTEN      616/systemd-resolve
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      729/sshd: /usr/sbin
tcp        0      0 127.0.0.1:33060         0.0.0.0:*               LISTEN      760/mysqld
tcp6       0      0 :::22                   :::*                    LISTEN      729/sshd: /usr/sbin
tcp6       0      0 :::80                   :::*                    LISTEN      750/apache2
udp        0      0 127.0.0.53:53           0.0.0.0:*                           616/systemd-resolve
udp        0      0 xx.xx.xx.xx:68          0.0.0.0:*                           614/systemd-network

Is there a manual to read correct SQL database migration?

Thanks in advance

Superego2 years ago

Update: if I drop all tables, restart Traccar, it restores DB and is running. But still DB is altered from 4.12 and it's impossible to fluently fill DB from backup.

Track-trace2 years ago

I do not see traccar running on any port. What about the traccar server log ?

Superego2 years ago

Now I got it working - dropped all tables, restarted Traccar process and it restored database to default. But now I struggle with old data restore.

Anton Tananaev2 years ago

You have to restore the database first and then start Traccar, not the other way around. If it doesn't work, check logs for details.

Superego2 years ago

Thanks for replies. Helped only restore table by table. So now all is up. Thanks for product.