Tag Archives: Database

Magento – Error Database Import

Today we had the import of a Magento database to a new database, the error message SQL command: – – Constraints der Tabelle 'catalog_eav_attribute’ – ALTER TABLE ‘catalog_eav_attribute’ ADD CONSTRAINT ‘FK_CATALOG_EAV_ATTRIBUTE_ID’ FOREIGN KEY ( ‘attribute_id’ ) REFERENCES ‘eav_attribute’ ( ‘attribute_id’ ) ON DELETE … Continue reading

Posted in General problems Magento | Tagged , , , , , , , , , , , | Leave a comment

Magento – Location for Inline Translations

Very briefly, since the question was just: When are produced in the Magento-line translations, these core_translate stored directly in the database in the table. Here can then be adjusted (or probably (!) also deleted, it then … Continue reading

Posted in General | Tagged , , , , , , , , | Leave a comment

Magento – CMS data is lost but database backup

We have just created a new template is placed on our multi-store, which has a great installer…a very ambitious Installer. This has all the unasked “Home” CMS pages and overwrite the entire content was lost. Unfortunately, neither the manual nor anywhere else … Continue reading

Posted in General | Tagged , , , , , , , , , | Leave a comment

PHP MyAdmin – SQL command, Replace data in the database

It comes every now and again before, that a domain transfer, image_link a change or similar. in many places such as change in the transaction must email. This situation we had just, that the logo, which is sent to the transaction email to … Continue reading

Posted in General | Tagged , , , , , , , , , , , | Leave a comment

Magento – Database import / Store Relocation

Should move a shop or a backup of the database are recorded in a shop, This is not to solve intuitively. How to backup / Dumps from the system gets, I had described in the preceding article. Should move a shop, … Continue reading

Posted in General problems Magento | Tagged , , , , , , , , , , , , | 3 Comments

Magento – Export Database / Create Dump

If you want to make a database copy, order to secure and then bring in a copy shop, This can be done quickly with PHPMyAdmin. For this purpose the concerned DB and select the tab “Export” click. Now it is usually … Continue reading

Posted in General | Tagged , , , , , , , , | Leave a comment

Magento – “The attribute code ‘weight’ is reserved by system. Please try another attribute code.” Attribute anpassen, if it is not on the backend

There are one or the other attribute, which can be changed not so easy on the backend, how it would perhaps like to. An example is the attribute weight / Weight. This throws out the above error message, when … Continue reading

Posted in General problems Magento, Magento Design | Tagged , , , , , , , , , , , , , , , , | 8 Comments

Magento – Importing old SQL database

If an old database will be transferred to a new Magento System (what does not always and not without its problems), can be attempted the following way: It is created in phpMyAdmin, a DB backup of the corresponding DB. >BEFORE< the same in the … Continue reading

Posted in General problems Magento | Tagged , , , , , , , | Leave a comment