gustavobgama

SELECT TABLE_SCHEMA, TABLE_NAME FROM information_schema.TABLES WHERE ENGINE LIKE 'myisam';

gustavobgama

du -hs /path/to/folder

gustavobgama

watch -n1 'mysql --user=user --password=password database --execute="SHOW PROCESSLIST"'

gustavobgama

mysql --user=user --password=password -e 'CREATE DATABASE IF NOT EXISTS db_name DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;'

gustavobgama

RESET QUERY CACHE;

gustavobgama

# Reference: http://webcheatsheet.com/sql/mysql_backup_restore.php

# import without compression
mysql --host=host --user=user --password=password database < path_to_file.sql

# import with compression
gunzip < path_to_file.sql.gz | mysql --host=host --user=user --password=password database

# export wihtout compression
mysqldump --host=host --user=user --password=password database table --where="condition" > path_to_file.sql

gustavobgama

SELECT `AUTO_INCREMENT`
  FROM `information_schema`.`TABLES`
 WHERE `TABLE_SCHEMA` = SCHEMA()
   AND `TABLE_NAME` = 'tbl_name';

gustavobgama

tac file | grep -m 1 term

gustavobgama

# compact
tar -zcvf file.tar.gz source-folder

# extract
tar -zxvf file.tar.gz

gustavobgama

SELECT table_name,table_schema FROM INFORMATION_SCHEMA.COLUMNS
    WHERE column_name='column_name';