{"id":1518,"date":"2010-08-16T09:29:10","date_gmt":"2010-08-16T03:59:10","guid":{"rendered":"https:\/\/2thenew.xyz\/blog\/2010\/08\/16\/mysql-publish-results-of-a-query-to-a-text-file\/"},"modified":"2010-08-16T09:32:32","modified_gmt":"2010-08-16T04:02:32","slug":"mysql-publish-results-of-a-query-to-a-text-file","status":"publish","type":"post","link":"https:\/\/2thenew.xyz\/blog\/mysql-publish-results-of-a-query-to-a-text-file\/","title":{"rendered":"MySql : Publish results of a query to a text file"},"content":{"rendered":"

A while back I was trying to debug an error in our application logic. For that I had to analyze the results of a query<\/p>\n

This analysis was getting pretty tough to do on the command line. So, I tried to find a way to transfer the results of a query to a text file so that they can be analysed easily.<\/p>\n

With help from google, I got my answer at http:\/\/www.wellho.net\/forum\/The-MySQL-Relational-Database\/MySQL-query-to-a-text-file.html<\/a><\/p>\n

echo \"<YOUR SELECT QUERY>\"| \/usr\/local\/mysql\/bin\/mysql --user=root --password=password dbName > \/path\/to\/your\/textFIle.txt<\/code>\/<\/p>\n

Hope this helps<\/p>\n","protected":false},"excerpt":{"rendered":"

A while back I was trying to debug an error in our application logic. For that I had to analyze the results of a query This analysis was getting pretty tough to do on the command line. So, I tried to find a way to transfer the results of a query to a text file […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":3,"footnotes":""},"categories":[1],"tags":[76],"class_list":["post-1518","post","type-post","status-publish","format-standard","hentry","category-technology","tag-mysql"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t