tag:blogger.com,1999:blog-15101094.post4468626766006951858..comments2023-10-10T20:09:26.444+08:00Comments on Developer's Note: ERROR 1 (HY000) at line 1: Can't create/write to fileThiam Teck (1983 - ?)http://www.blogger.com/profile/02119410084311832137noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-15101094.post-18942216809981958712012-06-23T01:59:38.199+08:002012-06-23T01:59:38.199+08:00Thanks a lot. I also had the same wrong assumption...Thanks a lot. I also had the same wrong assumption and your solution just solved it for me :)Hebanoreply@blogger.comtag:blogger.com,1999:blog-15101094.post-82692687640320259522012-06-23T01:58:00.816+08:002012-06-23T01:58:00.816+08:00Thanksss! I was assuming the same as well and your...Thanksss! I was assuming the same as well and your solution solved my problem :)Hebanoreply@blogger.comtag:blogger.com,1999:blog-15101094.post-21211967073228458942010-11-27T22:20:02.011+08:002010-11-27T22:20:02.011+08:00Hi Vishal, may I know what error you get by execut...Hi Vishal, may I know what error you get by executing this?Thiam Teck (1983 - ?)https://www.blogger.com/profile/02119410084311832137noreply@blogger.comtag:blogger.com,1999:blog-15101094.post-46199194460551862542010-09-16T15:34:46.180+08:002010-09-16T15:34:46.180+08:00Hi,
Your solution seems to be diff and usefull but...Hi,<br />Your solution seems to be diff and usefull but I am trying query like below<br /><br />mysql -u username -pPassword -e "select * from sentbox_3 where publishtimestamp >= '2010-01-05 00:00:00' and publishtimestamp < '2010-08-20 23:59:59' FIELDS TERMINATED BY ',' ENCLOSED BY '/"' LINES TERMINATED BY '\n'" mydatabse > /var/www/backup/somefile.csv<br /><br />Is this valid way or not?<br />Will this resulting csv file will be importable into other databse?<br />and also this command is not working why?<br />:)Anonymoushttps://www.blogger.com/profile/05771953934053867214noreply@blogger.com