Skip to content

Instantly share code, notes, and snippets.

@tinchodev

tinchodev/import_export_mysql_pipe_view.txt

Created December 11, 2017 15:03
Show Gist options
  • Save tinchodev/8de34177b3cfdaa11aa98363d3a4d4d8 to your computer and use it in GitHub Desktop.
Save tinchodev/8de34177b3cfdaa11aa98363d3a4d4d8 to your computer and use it in GitHub Desktop.
Download ZIP
Import Export Mysql Pipe View
Raw
import_export_mysql_pipe_view.txt
# Export
mysqldump -uxxx -pxxx data_base > data_base.sql
# Import
mysql -uxxx -pxxx data_base < data_base.sql
# Import Pipe View
pv data_base.sql | mysql -uxxx -pxxxx data_base
# Import Source
mysql -uxxx -pxxx
drop database data_base;
create database data_base;
use data_base;
SOURCE data_base.sql;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment