I noticed something strange today.
In the Admin-pages there is a tool to backup the database. (System -> Tools -> Backup).
I tried it to copy the data from my webhost database to my local database on my laptop.
I used MyPHPAdmin to Import the backup file, and everything went fine.
But when I checked my local website the following problem had occured:
The product attributes were not longer assosiated with the attribute_sets and attribute_groups.
So I used the following query to check the problem:
SELECT t3.attribute_set_name,t4.attribute_group_name ,t2.attribute_code, t2.frontend_label
FROM eav_entity_attribute t1
LEFT JOIN eav_attribute t2 ON t1.attribute_id = t2.attribute_id
LEFT JOIN eav_attribute_set t3 ON t1.attribute_set_id = t3.attribute_set_id
LEFT JOIN eav_attribute_group t4 ON t1.attribute_group_id = t4.attribute_group_id
ORDER BY t3.attribute_set_name,t4.attribute_group_name ,t2.attribute_code, t2.frontend_label
This query gave me 2 different results on the webhost and on my local database.
The magento backup tool didn’t copy all the rows from the eav_entity_attribute table.
After manualy copying the complete ‘eav_entity_attribute’-table from my webhost to my local database, everything worked fine on my laptop.
Does anybody know what this problem might have caused?