I have Magento 220.127.116.11 installed and I also installed a test Magento installation in a subdomain. Basically, the theme I have installed on my current Magento installation was designed for an older version of Magento. I installed a new responsive theme designed for 1.9.x installed on the test Magento installation. Note that both Magento installations are 18.104.22.168.
I need to copy all products along with images and attributes from the current Magento installation to the test installation. I would like to be able to copy the customers as well, but it's not completely necessary. How can I do this? Any and all details would be appreciated. I've tried various ways with the Export/Import Data Profiles and keep getting errors (image not present, etc.)
My goal is to copy all products, images, attributes and possibly customers to the test site. Then, remove the original installation and move the test site to take it's place. My old theme on the original installation is very integrated into the files and almost impossible to remove. I needed to start fresh.
EDIT: I'm at my wits end on this. I cleared all logs in the database and exported it again. I uploaded it via FTP and against tried to import it to the new database via SSH and I get this exact error:
ERROR 1062 (23000) at line 22349: Duplicate entry '3-13-70-0' for key '479DA1DD8CED295B97C96AEF816CA4EE'