Skip to content
tech.tutulutu.ee
Simple Blog about Tech – written for myself. Use with caution.
  • Home
  • Links
Uncategorized

Unpack and import mysql database from *.sql.gz file on command line

Posted July 27, 2016
gunzip < myfile.sql.gz | mysql -u root -p mydb

Thanks to: http://serverfault.com/questions/137965/how-do-i-load-a-sql-gz-file-to-my-database-importing

Post navigation

Older post
Show sql database size
Newer post
my wordpress workflow

Recent Posts

  • Tar and crypt ssh folder, then untar
  • Docker – update image and build again
  • observe ssh login attempts
  • show current traffic on certain network adapter
  • Scan network

Categories

  • Angularjs
  • apache
  • Atom
  • aws
  • bootstrap
  • command-line
  • crypt
  • css
  • docker
  • firefox
  • Git
  • gmail
  • https
  • Java
  • jQuery
  • LAN
  • laravel
  • linux
  • music
  • MySQL
  • network
  • nginx
  • nodejs
  • npm
  • php
  • phpunit
  • printers
  • Python
  • Sailsjs
  • sql
  • ssh
  • SSL and HTTPS
  • thunderbird
  • Uncategorized
  • vim
  • web
  • woocommerce
  • wordpress

Tags

add user angularjs apache atom aws bootstrap browser command line cron crypt css cups dns docker dpkg find file firefox gedit git htaccess html htpasswd https java laravel linux lvm moodle mysql network nginx npm php phpunit ppa printers rsync s3cmd scp ssh thunderbird ubuntu visudo woocommerce wordpress
© 2026 tech.tutulutu.ee
Powered by WordPress | Theme: Graphy by Themegraphy