SELECT pics.pic_id,pics.pic_pic,pics.pic_th,pics.pic_full,pics.pic_text,pics.pic_date,pics.pic_order,pics.pic_zoom,pics.pic_views,galleries.gal_title,galleries.gal_folder FROM photocart.pics LEFT JOIN photocart.galleries ON pics.pic_gal=galleries.gal_id WHERE TRIM(COALESCE(pics.pic_full,'')) !='' INTO OUTFILE 'c:/temp/photos.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'
How to Setup MySQL Replication with SSL
FYI Recently MySQL binaries and Linux binaries now come with OpenSSL support built in. This is true for MySQL GA releases 5.1 and later. OpenSSL has to be used to create the certificates. MySQL Uses Same Port for secure ssl…