TheJasonParker


Member since 01/11/2011

Name: Jason Parker

Location: Nottingham, UK

Father & Nerd that Loves - Music, Football, Darts, The Net & Apple but Hates - Early Mornings, Ignorance & Apple (owns a MacBook Pro & iPhone!)

6 snippets

29 profile views

2 Comment(s) Posted

View their favorites

their Tags


Profile

Achievement

first submission:submitting first snipplet

TheJasonParker's Recent MySQL Snippets



« Prev 1 Next »
Go to the Windows command line by going to Start -> Run and typing in cmd. You need to change directory to the MySQL bin directory. On my version, the directory is c:\wamp\bin\mysql\mysql4.1.22\bin. Therefore, the command to change to this dire...
0 20 posted 8 years ago by TheJasonParker
Ftp your *.sql file to the (remote) machine, login via SSH and then go to the directory where your sql file is and run this code.
0 11 posted 9 years ago by TheJasonParker
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 12 posted 9 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 13 posted 9 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 29 posted 9 years ago by TheJasonParker
« Prev 1 Next »