Welcome To Snipplr
Everyone's Recent MySQL Snippets Tagged magento
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
« Prev 1 Next »
Wrap these two sets of commands around your sql backup if it hasn't come from a backup from the Magento admin interface (Magento adds this).
This stops foreign key checks and then restarts them.
The /*!40101 ---- */ code around the SET command...
0
598
posted 13 years ago by TheJasonParker
After the MySQL above has run – you’ll need to let Magento take the reigns back a little to update the category indexes, this is quite straightforward, but a little time consuming.
Login to your admin and go to System > Cache Management, the s...
0
527
posted 13 years ago by TheJasonParker
You'll first need to find the attribute_id value for 'status' for your Magento installation and replace 273 in this example.
The easiest way to tell is if you go into:
Admin > Catalog > Attributes > Manage Attributes
Then in the “Attribute...
0
799
posted 13 years ago by TheJasonParker
« Prev 1 Next »