Skip to content

coders.pro

all your code are belong to us

Categories

  • Apache
  • Bash
  • Configuration
  • DirectAdmin
  • Exim
  • Front-end
  • Installatron
  • MySQL
  • Nginx
  • PHP-FPM
  • Programming
  • Proxmox
  • Server
  • Uncategorized
  • WordPress

Recent Posts

  • Converting an openvz to lxc container
  • Directadmin: Cannot find the script
  • Got error ‘Primary script unknown’ after update PHP-FPM + Apache 2.4
  • WP cli search-replace
  • Days of the week array

Tag: zcat

Import sql.gz into MySQL database

Simple zcat into mysql command:

zcat file.gz | mysql -u $user -p$passwd

DirectAdmin variation:

source /usr/local/directadmin/conf/mysql.conf && zcat file.gz | mysql -u $user -p$passwd
Posted on October 8, 2015October 15, 2015Author Maarten KeizerCategories Bash, MySQLTags bash, gz, mysql, sql import, zcatLeave a comment on Import sql.gz into MySQL database
Proudly powered by WordPress