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