mysql import - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

mysql import

mysql import# Database - 数据库

G*G2007-08-28 07:08

1 楼

I have 28 sql files and 28 txt files with the same name as sql files.
They are seeminly exported using mysqldump.
My question is how to import them into mysql.
thank you very much.
My files look like the following.
term.sql
term.txt

l*92007-08-28 07:08

2 楼

under mysql:
source /path/to/term.sql

【在 G***G 的大作中提到】

: I have 28 sql files and 28 txt files with the same name as sql files.
: They are seeminly exported using mysqldump.
: My question is how to import them into mysql.
: thank you very much.
: My files look like the following.
: term.sql
: term.txt

I*e2007-08-28 07:08

3 楼

If you search for "google mysql package", you can find a python package that
can do parallel load of all the files. Still, make sure that your machine
has the enough capacity.