Weird behavior MySQL lists over 57k rows but XAMPP imports only 27k?

[icecold]

Just make a proper full DB backup and import that into your xampp install

https://www.zen-cart.com/tutorials/i...hp?article=103

Can't do that as my cache is over 4.5Gb! Therefore I have to go importing just relevant tables ... Anyways I think the problem was some of these products have an inactive flag ... That's why it's displaying only 27k ...
Thanks for the suggestion, but in my case this solution is totally unworkable ...

[DrByte]

"cache"? If you're referring to a folder on your server, that's NOT the same as your database, so that's completely different than what kobra suggested about a DB backup. It's highly unusual for it to be that big, too, and suggests some significant problems you need to resolve with your site.

If you're referring to a table in your database named db_cache, you can safely truncate that table before doing a backup. And, it's highly unusual for it to be that huge.