harveyqing

* Export a whole database:
Syntax:
    
    mysqldump -u username -p [pwd] DBname > /path/to/backup
    
* Export a table in a specified database:
Syntax:

    mysqldump -u username -p [pwd] DBname table_name > /path/to/backup
    

harveyqing

Syntax:

    mysql> SHOW FULL COLUMNS FROM DBname.table_name
    
Head description:
    Field ：field name
    Type：field type
    Collation：char set (above mysql 5.0）
    Null ：can be `NULL` of not
    Key：index（PRI,unique,index)

harveyqing

import re

tp = re.compile(r'^(\d{4})-([1-9]|0[1-9]|1[0-2])-([1-9]|[1-2]\d|3[0-1]) (\d|0\d|1[0-2]|1\d|2[0-3]):(\d|[0-5]\d):(\d|[0-5]\d)$')

# can match string timestamps like below
# t1 = '3003-1-1 9:03:59

harveyqing

set debug option:

error_log path/to/err/log debug;

P.S. Should config the ``--with-debug`` option during configure phase.

harveyqing

e.g.

events {
    debug_connection 10.224.66.14;
    debug_connection 10.224.57.0/24;
}

P.S. --with-debug option should be on during configure phase