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
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.
I do not see traccar running on any port. What about the traccar server log ?
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.
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.
Thanks for replies. Helped only restore table by table. So now all is up. Thanks for product.
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:
Is there a manual to read correct SQL database migration?
Thanks in advance