zdravkok

sed -e 's/DEFINER=[^*]*\*/\*/' rds.sql > rds1.sql

zdravkok

DELETE o, v
      FROM eav_attribute a
INNER JOIN eav_attribute_option o ON a.attribute_id = o.attribute_id
INNER JOIN eav_attribute_option_value v ON v.option_id = o.option_id
INNER JOIN eav_entity_type t ON t.entity_type_id = a.entity_type_id
 LEFT JOIN catalog_product_entity_int pi ON o.option_id = pi.value AND o.attribute_id = pi.attribute_id
 LEFT JOIN catalog_product_entity_varchar pv ON o.option_id = pv.value AND o.attribute_id = pv.attribute_id
     WHERE pi.entity_id IS NULL
       AND pv.entity_id IS NULL
       AND t.entity_type_code = "catalog_product"

zdravkok

find media/ -name "*.jpg" -type f -exec echo jpegtran -copy none -optimize -outfile {} {} \;

zdravkok

sudo find . -type f -exec chmod 644 {} \;
sudo find . -type d -exec chmod 755 {} \;
sudo chmod o+w var var/.htaccess app/etc
sudo chmod 550 mage
sudo chmod -R o+w media

zdravkok

RewriteEngine on
RewriteCond %{SERVER_PORT} ^443$
RewriteRule ^robots\.txt$ robots_ssl.txt [L] 

zdravkok

<Directory>
  <IfVersion < 2.3 >
     Order allow,deny
     Allow from all
  </IfVersion>

  <IfVersion >= 2.3>
     Require all granted
  </IfVersion>
</Directory>