mysql innodb myisam

mwpclark 8 years ago

Hello, I have successfully migrated traccar to mysql and am now able to pull position data to include in reports.

I switched default table type to innodb to create the tables, and have now switched back in my.cnf to [default-storage-engine = myisam]

If I do not have to re-create the database/tables, I assume that there should be no issue. Correct?

Thanks for a GREAT program! Mike

Anton Tananaev 8 years ago

As long as the existing tables are innodb and you have foreign keys it should be fine.

mwpclark 8 years ago

Thank you, should be OK, mariadb defaults to foreign keys.

We have 2 systems for crew tracking. One allows them to punch in arrival and departure times. This is subject to human error. Being able to compare vehicle location gives a comparison.

Thanks again