Snipplr

(MySQL) Delete & Recreate a table quickly with mySQL - TheJasonParker

Thu, 21 Jul 2011 21:41:41 UTC

(MySQL) Drop a table if it exists with mySQL - TheJasonParker

Thu, 21 Jul 2011 20:50:34 UTC

(MySQL) Restore MySQL database in WampServer - TheJasonParker

Tue, 19 Apr 2011 21:58:12 UTC

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 directory is: cd wamp\bin\mysql\mysql4.1.22\bin Put the MySQL dump (SQL file) into the above directory Create the new database in phpmyAdmin (or on the command line) The actual restore command is slightly different to normal (see below). Note that is says mysql.exe rather than the normal mysql. When it asks you for a password, just hit enter. There is no password associated with the database that you created (unless you prefer to have one. But as it is local, there is no need).

(MySQL) Excuting sql files from Linux shell - TheJasonParker

Tue, 25 Jan 2011 23:34:46 UTC

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.

(MySQL) Restoring a backup in Magento - TheJasonParker

Fri, 21 Jan 2011 02:33:43 UTC

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 commands asks "If this version of mySQL is 4.1.1 or newer then run the SET command else do nothing." Older versions will not understand the statement. This allows for easier compatibility with other versions of mySQL.

(MySQL) Cleanly delete all categories - TheJasonParker

Wed, 12 Jan 2011 23:59:02 UTC

(MySQL) Disable products by category - TheJasonParker

Wed, 12 Jan 2011 21:57:26 UTC

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 select Rebuild Catalog Index

(MySQL) Disable products by sku - TheJasonParker

Wed, 12 Jan 2011 21:52:52 UTC

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 Codeâ€ box, enter â€œstatusâ€ then press â€œSearchâ€. Click the attribute result â€œstatusâ€ â€“ then look at the digits at the very end of the URL â€¦ catalog_product_attribute/edit/attribute_id/XXX/ In the code below (to be run via command line MySQL or phpMyAdmin), just replace %SKU% with your SKU identifier and use % as a wildcard or _ as a single character wildcard. This will obviously apply to any other attribute, so just change the code as necessary. enabled = 1 disabled = 2 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. Remove this line to disable all... AND cpe.sku LIKE '%SKU%' Login to your admin and go to System > Cache Management, the select Rebuild Catalog Index