Upgrade traccar server 4.6 to 5.2

TDIGITALI2 years ago

Hello everyone,
I would like to know if someone has already been able to migrate from version 4.6 to version 5.2?
I generated the backup in the old version and when I want to pass it to the new one with mysqldump it seems that it does not show an error but the information is not loaded
To export the database I am using this command and to import it the following:
Do you know if I'm doing something wrong? or am I missing a step?
mysqldump -u USERBD -pPASS DB > backup.sql
THANKS A LOT!!
```
MySQL dump 10.19 Distrib 10.3.34-MariaDB, for debian-linux-gnu (x86_64)

-- Host: localhost Database: plataforma_db


-- Server version 10.3.34-MariaDB-0ubuntu0.20.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
/
!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
/
!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
/
!40101 SET NAMES utf8mb4 /;
/
!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;
/
!40103 SET TIME_ZONE='+00:00' /;
/
!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
/
!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
/
!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;
/
!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;
/
!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE /;
/
!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
/
!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
/
!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
/
!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
/
!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
/
!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-07-26 2:22:59
```

Anton Tananaev2 years ago

Have you checked logs? Have you checked the updated schema? Is there data in the database? If you want help, please provide all the relevant information you can.

TDIGITALI2 years ago

I stopped the app
Then, restore the database backup

mysql -u User -pPassword BD_Name < Backup.sql

I connect to MySQL and delete the following tables (this solution found it in another topic)

drop table tc_user_order;
drop table tc_group_order;
drop table tc_device_order;
drop table tc_orders;
quit

Restart the app and unfold

I wait for someone to serve you