mysql innodb myisam

mwpclark7 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 Tananaev7 years ago

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

mwpclark7 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