RSS

Archive | System Administration RSS feed for this section

mysqldump to CSV file

17. February 2005

2 Comments

Dead simple this one, but not initially obvious. How do you use mysqldump to generate a CSV file of data? mysqldump –u [username] –fields-terminated-by=, –tab=[DIR TO SAVE TO] –tables [DB NAME] [TABLENAME] > [TABLENAME].txt This’ll place into the specified directory two files: one a SQL file containing the table definition and the data as a [...]

Continue reading...

~/.vimrc

16. October 2004

0 Comments

I was playing around a on virgin DSVR (vs300) account for a few hours during the week, just getting php and mysql ready for use. vi was being really annoying, giving me the dreaded A B C D routine when the arrow keys were pressed in insert mode. vim in compatible mode, I could’nt find a [...]

Continue reading...
Next Entries »