How to pull and load data from SELECT query

05.06.2019

use wiki2016;

SELECT * INTO OUTFILE 'pages.dat' FROM wiki2016.page WHERE page_id < 10 AND page_namespace = 0;

Pages pages.dat stored in /var/lib/mysql/wiki2016

dump only the db schema without data

$ mysqldump --user=andre --default-character-set=utf8 --no-data --skip-triggers "wiki2016" -p

create a new db

CREATE DATABASE wikitest;

and import the import schema

$ mysql --user=andre wikitest -p < wiki2016.sql

LOAD DATA INFILE '/var/lib/mysql/wiki2016/pages.dat' REPLACE INTO TABLE wikitest.page;

use wikitest;
SELECT * FROM page;

use wikitest;
SELECT * FROM page;

SQL Notes