Database restore successful accoring to phpmyadmin, but data missing

[themavesite]

I back up my database regularly, but decided to try and install it on my local xampp server.
Because how good is a database backup when you cannot restore it, right?

I backup through cpanel -> backups > sql > download smf database in sql format
The downloaded file then is 46MB zipped and 324MB unzipped

I then proceed to import this database into a clean smf install, this goes successfully according to phpmyadmin



And at first glance the forum looks okay, but then I notice that one board has no last post, although it should contain almost 10 000 topics: (so maybe the import wasn't successful after all?)



Some users also miss their personal text, the example below should actually say "(｀・ω・´)" instead of the question marks. (character set problem?)



Do you guys have any idea what goes wrong?

EDIT: These are settings I use when I import

[Linkjay]

Maybe it's a compatibility thing? Try exporting from phpmyadmin and restoring it on your local server and see if that works.

[themavesite]

Maybe it's a compatibility thing? Try exporting from phpmyadmin and restoring it on your local server and see if that works.

That is exactly what I'm doing right now 

[Kindred]

For the character tjing... your old database and installation was utf8, your local one appears to not be