Howto check and repair MySQL tables

April 7th, 2011 von sdohn

mysqlcheck -u root -p -c -A # check MySQL tables
mysqlcheck -u root -p -r -A # repair MySQL tables

 

Export MySQL data into csv file

April 6th, 2011 von sdohn

SELECT cal_date,cal_name,cal_description
    INTO OUTFILE '/tmp/export.csv'
    FIELDS
            TERMINATED BY ';'
            OPTIONALLY ENCLOSED BY '"'
    from webcalendar.webcal_entry
where cal_create_by='sdohn' AND cal_date between '20090330' AND '20090331';

Pagination in mysql CLI

April 6th, 2011 von sdohn

Pagination in mysql CLI
Ever wonder how to scroll upwards in mysl resultset ?

What if your terminal doesn’t allow scrollback or the scrollback buffer is somehow set to sreen lines ?

How to use MORE or LESS unix commands in mysql which would allow to scroll using ‘return’ or ’spacebar’

Follow the steps given below:

mysql –page uuser -p  [Invoke mysql using the --page command] 
mysql> pager less          [set the pager to use less] 
mysql> select * from table_name  [run your query]

This also works under the unix ’screen’ terminal emulation