I ended up doing a fresh install, after installing another install on the same domain but different directory and successfully downloading products after the database restore. But after pulling in the configuration files again it corrupts the file on export.
Here are the steps I did:
1) Rename folder of store installed (/shop to shop1)
2) Install new abantecart through CPANEL softacuolous using the same table prefix as the original install
3) Truncated all tables through phpmyadmin (get rid of sample data)
4) Restored database through phpmydmin
5) Update system/config.php
updated salt and Encryption key
6) Upload following files from other directory:
○ Resources/image
○ storefront/view/default/image
○ image/thumbnails
○ storefront/view/default/stylesheet/style.css
7) Try to export again and it corrupted.