When exporting mysql db to different server and have datetime or timestamp fields then it is very important what the time zone is the other server is.

Check mysql for time zone. For phpmyadmin go to variables and there check time zone variable and then go to the server where you need to import db and check time zone on the linux server itself.

You need to make sure both time zones are the same.

https://linuxize.com/post/how-to-set-or-change-timezone-on-ubuntu-20-04

Or just add --skip-tz-utc to mysqldump. But this is ok for one db but most likely with backup/restore and tar it’s going to be problem. So just use time zone on linux server and restart mysql/mariadb.

https://stackoverflow.com/questions/14886427/mysql-data-export-changes-times