Hiep Nguyen hiepnt93

Update attribute via install/upgrade script

In example below I upgraded is_visible_on_front and used_in_product_listing from false to true for two attributes namely flavor and unit_count. These attributes are product attributes and refer to Mage_Catalog_Model_Product::ENTITY or catalog_product. For update attribute params we are need the: entity id of attribute, id of attribute, field name what we wont to change, new field value and sort order. Function what we will use is updateAttribute from class Mage_Eav_Model_Entity_Setup.

Install/upgrade script in my case this is the `mysql4-upgrade-1.1.4-1.1.5.php`

    /* @var $installer Mage_Catalog_Model_Resource_Setup */

Backup MySQL to Amazon S3

This is a simple way to backup your MySQL tables to Amazon S3 for a nightly backup - this is all to be done on your server :-)

Sister Document - Restore MySQL from Amazon S3 - read that next

1 - Install s3cmd

this is for Centos 5.6, see http://s3tools.org/repositories for other systems like ubuntu etc

MySQL

Getting started:

	#!/bin/sh
	echo Install all AppStore Apps at first!
	# no solution to automate AppStore installs
	read -p "Press any key to continue... " -n1 -s
	echo '\n'

	echo Install and Set San Francisco as System Font
	ruby -e "$(curl -fsSL https://raw.github.com/wellsriley/YosemiteSanFranciscoFont/master/install)"
	echo Install Homebrew, Postgres, wget and cask
	ruby -e "$(curl -fsSL https://raw.github.com/Homebrew/homebrew/go/install)"

	pipeline {
	agent { node { label 'swarm-ci' } }

	environment {
	TEST_PREFIX = "test-IMAGE"
	TEST_IMAGE = "${env.TEST_PREFIX}:${env.BUILD_NUMBER}"
	TEST_CONTAINER = "${env.TEST_PREFIX}-${env.BUILD_NUMBER}"
	REGISTRY_ADDRESS = "my.registry.address.com"

	SLACK_CHANNEL = "#deployment-notifications"

	--
	-- Magento CE database clean-up extended
	--
	-- This is an extended clean-up which will clean search, import/export, reports, etc.
	--
	-- @author Constantin Bejenaru <boby@frozenminds.com>
	-- @copyright Copyright (c) Constantin Bejenaru (http://frozenminds.com/)
	-- @license http://www.opensource.org/licenses/mit-license.html MIT License
	--

	-- Remove the history from
	rm -rf .git

	-- recreate the repos from the current content only
	git init
	git add .
	git commit -m "Initial commit"

	-- push to the github remote repos ensuring you overwrite history
	git remote add origin git@github.com:<YOUR ACCOUNT>/<YOUR REPOS>.git

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE