Importing database to new server doesn't upload all rows


I want to move invoice ninja to a new server. When I try to dump the database and import it successful but I when I check the “activities” table there are only 23 rows instead of 1850.

I’m not sure where it went wrong.

I’ve tried the following things:
Use command line mysqldump (gives me when importing “Cannot add or update a child row: a foreign key constraint fails” error.

Use phpmyadmin and turned off “Enable foreign key checks” (uploads successfully but missing rows in 4 table)

I’ve also tried this forum post but with no luck:

Invoice Ninja version: v4.5.14
I’ve been using Invoice Ninja since 2017

Thanks in advanced