Home

Contacts

Downloads

RoR

Servers

Notes

Linux

ERR

Contents: • MySQL export to CSV • Reclaiming disk space from MyISAM tables (MySQL) • Postfix, virtual domains and personal spam folders

mysql -u<username> -p<password> <dbname> -B -e "select * from '<tablename>'" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > <filename.csv>

mysql -u<username> -p<password> <dbname> -B -e "select * from '<tablename>'" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > <filename.csv>

Tags

amavis  •  backup  •  bash  •  cloud computing  •  cloud servers  •  cyberpsychology  •  desktop  •  driver  •  error  •  facebook  •  gnome  •  google  •  hardware  •  hosting  •  java  •  linux  •  mephisto  •  microsoft  •  monitoring  •  movie  •  mplayer  •  mysql  •  operating systems  •  postfix  •  postgresql  •  rackspace  •  radeon  •  recipe  •  reference  •  rjs  •  ror  •  ruby  •  security  •  servers  •  social networks  •  transliteration  •  vat  •  vi  •  vim  •  virtual  •  xen  •