Home

Contacts

Downloads

RoR

Linux

Notes

ERR

Servers

Contents: • LOAD DATA INFILE vs bulk inserts • 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  •  apache  •  api  •  backup  •  balancer  •  bash  •  binary distros  •  centos  •  cloud computing  •  cloud servers  •  cyberpsychology  •  debian  •  desktop  •  driver  •  error  •  facebook  •  gentoo  •  gnome  •  google  •  hardware  •  hosting  •  java  •  lfs  •  linux  •  lsb  •  lvm  •  mephisto  •  microsoft  •  monitoring  •  movie  •  mplayer  •  mysql  •  nginx  •  operating systems  •  passenger  •  postfix  •  postgresql  •  proxy  •  rackspace  •  radeon  •  recipe  •  reference  •  rjs  •  ror  •  ruby  •  security  •  servers  •  shell  •  social networks  •  ubuntu  •  unixtime  •  vat  •  vi  •  vim  •  virtual  •  web services  •  xen  •