roscius

sudo /Library/StartupItems/VirtualBox/VirtualBox restart

roscius

#!/bin/bash

export LANGUAGE=en_US.UTF-8
export LANG=en_US.UTF-8
export LC_ALL=en_US.UTF-8
locale-gen en_US.UTF-8
dpkg-reconfigure locales

sudo apt-get update
sudo apt-get dist-upgrade -y

roscius

$store = Mage::getSingleton('core/store')->load($this->getStoreId());
$quote = Mage::getModel('sales/quote')->setStore($store)->load($item->getData('quote_id'));

roscius

grep -n 'Table structure' dump.sql

19:-- Table structure for table `t1`
40:-- Table structure for table `t2`
61:-- Table structure for table `t3`


sed -n '40,61 p' dump.sql > t2.sql

roscius

mysqldump -u**** -p**** --order-by-primary db | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | mysql db --host=mydb.com -u**** -p****

roscius

# Create the Server Key
openssl genrsa -des3 -passout pass:x -out server.pass.key 2048
openssl rsa -passin pass:x -in server.pass.key -out server.key
rm server.pass.key

# Create the CSR
openssl req -new -key server.key -out server.csr

# Sign the certificate
openssl x509 -req -days 365 -in server.csr -signkey server.key -out server.crt

roscius

sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java7-installer

roscius

sed -E 's/DEFINER=`[^`]+`@`[^`]+`/DEFINER=CURRENT_USER/g' non_portable_dump.sql > portable_dump.sql

roscius

SELECT * INTO OUTFILE '/tmp/result.csv'
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM attributes WHERE 1

roscius

rsync -a --delete empty_dir/    yourdirectory/