carltondickson

SELECT CONCAT(
    'SELECT "', 
    table_name, 
    '" AS table_name, COUNT(*) AS exact_row_count FROM ', 
    table_schema,
    '.',
    table_name, 
    ' UNION '
) 
FROM INFORMATION_SCHEMA.TABLES 

carltondickson

cd ~/Downloads

# IE8 - Windows XP
wget -i https://az412801.vo.msecnd.net/vhd/VMBuild_20131127/VirtualBox/IE8_WinXP/Linux/IE8.WinXP.For.LinuxVirtualBox.txt

# IE8 - Windows 7
wget -i https://az412801.vo.msecnd.net/vhd/VMBuild_20131127/VirtualBox/IE8_Win7/Linux/IE8.Win7.For.LinuxVirtualBox.txt

# Give execute permissions
chmod +x ./IE8*.sfx

carltondickson

git stash show -p stash@{0}

carltondickson

# Defaults, log in to command line and run these...clients like SQLYog may have already SET NAME utf8 so results would not necessarily show the defaults

SHOW VARIABLES LIKE "collation_database";
+--------------------+-------------------+
| Variable_name      | Value             |
+--------------------+-------------------+
| collation_database | latin1_swedish_ci |
+--------------------+-------------------+

SHOW VARIABLES LIKE "%character%";

carltondickson

# Exporting entire database:
mysqldump -u user -p database --opt | gzip > database.sql.gz

# Export table
mysqldump -uroot --opt --databases DB_NAME --tables TABLE_NAME | gzip > /tmp/TABLE_NAME.export.sql.gz

# Importing:
gunzip < database.sql.gz | mysql -u user -p database

# Credit http://failshell.io/mysql/using-gzip-and-gunzip-with-mysql-to-importexport-backups/

carltondickson

# Following needs the file permission, double check you look on the DB server to find the outfile!
SELECT .. INTO OUTFILE '/home/foo/myfile.csv'

# If no file permission try command line instead
mysql -e "SELECT * FROM foo ORDER BY bar" > '/path/to/file'

carltondickson

# Auto-complete works if you have ssh keys set up to the server

scp user@homeip:/path/to/file /local/path/

# Credit http://superuser.com/questions/337776/how-do-i-scp-from-remote-machine-to-local-machine-when-i-am-outside-of-my-home-n

carltondickson

# Show running queries
SHOW FULL PROCESSLIST;

# Show who is connected
SHOW STATUS LIKE '%onn%';

# Search stored procedures for a string
SELECT * FROM information_schema.`ROUTINES` r WHERE r.`ROUTINE_DEFINITION` LIKE '%string%';

carltondickson

Create new run configuration with following "Command Line > Interpreter Options" or add the options after "php" on the command line

/usr/bin/php -d xdebug.profiler_output_dir="/tmp/profiler" -d xdebug.profiler_enable_trigger=1 -d xdebug.profiler_enable=1

Ref: http://confluence.jetbrains.com/display/PhpStorm/Profiling%20PHP%20applications%20with%20PhpStorm%20and%20Xdebug

carltondickson

# From http://askubuntu.com/questions/82684/lowering-compiz-memory-usage#answer-82698
# Kill compiz completely, including all child processes, freeing it's memory:
killall -9 compiz & 
# Run unity and give you back a free terminal.
unity & disown