sebastianneubert/mysql.md

## mysql.md

      
    Raw
  

              mysql.md
            
          
    MySQL Tricks

MySQL Dumps

Create Dumps

mysql -h $appenv_database_host -u $appenv_database_user -p$appenv_database_pass -e "SELECT * FROM mysql.slow_log" > mysql_slow.log

Import Dumps

mysql -u<user> <db> -h <host> -p < dump.sql

// or

cd <dump_dir>
mysql -u<user> -p 
mysql> use <dbname>
mysql> source <dump.sql>