Just some different unix commands/paths that I always forgets. Will be updated.

Mysql config location MAC
/usr/local/opt/mysql/my.cnf

Start/stop/restart Mysql MAC
sudo /usr/local/mysql/support-files/mysql.server start|stop|restart

Start/stop/restart Mysql Linux
/etc/init.d/mysqld start|stop|restart

Dump Mysql database to file
mysqldump -u mysql_user -p DATABASE_NAME > backup.sql

Import Mysql database from file
mysql -u mysql_user -p DATABASE < backup.sql

Copy file from local to remote(SSH)
scp /path/to/local/file [email protected]:/path/to/remote/file

Copy file from local to remote(SSH) with PEM-file(Amazon ec2...)
scp -i /path/to/pem/file.pem [email protected]:/path/to/file/remote /path/to/local/destination

Copy file from remote to local(SSH)
scp [email protected]:/path/to/remote/file /path/to/local/file

Change collation on Mysql table to UTF8
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8;

Allow remote connections/user to MYSQL
my.conf bind-address = 0.0.0.0

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass'; CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';

GRANT ALL ON *.* TO 'myuser'@'localhost'; GRANT ALL ON *.* TO 'myuser'@'%';

Ssh to EC2 instance with pem file
ssh -i c:\path\to\pem.pem [email protected]

WINDOWS - .NET

Build specific solution and publish to a specific folder with a specific configuration
msbuild mysolution.sln /p:OutputPath=c:\mydir /p:ConfigurationName=DeployToTest