Pario TechnoBlob

  • Home
  • About
  • Archives
Skip to content

Pario TechnoBlob

A chronological documentation test project, nothing serious, really!

  • Home
  • About
  • Archives

mySQL dump i batch mode

Posted on 7. May 20072. October 2008 by Hans-Henry Jakobsen
# mysql dbname -B -N -e "SELECT serial FROM serials" >/path/to/outfile

-B or –batch: prints rows tab-separated and turns off the borders
-N or –skip-column-names: leaves out the header row

Share this:

  • Facebook
  • X
Posted in: Linux, ScriptingTagged: Database, MySQL

Post navigation

Previous: Export mysql data to a tab-separated file
Next: Import csv data to mysql
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Search

Apache apt-get awk backup basename bash CentOS convert csv Database dd Debian esxi5 Etch EXIF Fedora find Gentoo grep howto html imagemagick iptables iso jhead JPG mount MySQL Nikon nmap perl PHP Postfix RedHat rename rhel5 sed sftp SMTP sort ssh Ubuntu VMware Wordpress Zimbra

  • Backup
  • Linux
  • Misc
  • Network
  • Photo etc
  • Scripting
  • Security
  • Virtualization
  • Web
  • Windows

Categories

  • Backup
  • Linux
  • Misc
  • Network
  • Photo etc
  • Scripting
  • Security
  • Virtualization
  • Web
  • Windows

Tags

Apache apt-get awk backup basename bash CentOS convert csv Database dd Debian esxi5 Etch EXIF Fedora find Gentoo grep howto html imagemagick iptables iso jhead JPG mount MySQL Nikon nmap perl PHP Postfix RedHat rename rhel5 sed sftp SMTP sort ssh Ubuntu VMware Wordpress Zimbra
Resume X WordPress Theme by Wp Theme Space