MYSQL big data import
- 2020-05-06 11:44:53
- OfStack
thanks for the code!
Write it down here, because you'll need it later; Function of information inquiry!
Step 1: mysql -h localhost -uroot
Step 2: show databases;
Step 3: use changchunmap;
Step 4: show tables;
Step 5: load infile "d:/ c.txt " replace changchunmap fields terminated ' ';
No;
load data local infile "d:/migration/mysql/babel_topic.txt" replace into table babel_topic_test fields terminated by ' '
load data local infile "d:/migration/mysql/babel_user.txt" replace into table babel_user_test fields terminated by '\t'
During the import process, the length of some tables is changed because some field data is NULL and can be null. In order to import correctly, please ensure that the following field is modified:
Babel_topic: tpc_uname VARCHAR(192) can be NULL
Babel_user: usr_password VARCHAR(64) can be NULL
usr_nick VARCHAR(192) can be NULL
load data local infile "d:/c.txt" replace into table changchunmap fields terminated by ' '