mysql 导入大数据文件

版权声明:本文为博主原创文章,遵循 CC 4.0 by-sa 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/eiffel_0311/article/details/88694458

1. 切割文件, 把文件按照每200W行拆分一个文件

split -l2000000 -d all.csv part_ --verbose

2. 逐个文件导入

load data infile '/var/lib/mysql-files/mg/part_00' ignore into TABLE yourTable fields TERMINATED by ',' ENCLOSED BY '"';

展开阅读全文

mysql 导入DMP文件

08-24

C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin>mysql -h localhost -urnot phone < D:\phone.DMP;rnmysql Ver 14.14 Distrib 5.5.15, for Win32 (x86)rnCopyright (c) 2000, 2010, Oracle and/or its affiliates. All rights resernrnOracle is a registered trademark of Oracle Corporation and/or itsrnaffiliates. Other names may be trademarks of their respectivernowners.rnrnUsage: mysql [OPTIONS] [database]rn -?, --help Display this help and exit.rn -I, --help Synonym for -?rn --auto-rehash Enable automatic rehashing. One doesn't need to urn 'rehash' to get table and field completion, but srn and reconnecting may take a longer time. Disablern --disable-auto-rehash.rn (Defaults to on; use --skip-auto-rehash to disablrn -A, --no-auto-rehashrn No automatic rehashing. One has to use 'rehash' trn table and field completion. This gives a quickerrn mysql and disables rehashing on reconnect.rn --auto-vertical-outputrn Automatically switch to vertical output mode if trn result is wider than the terminal width.rn -B, --batch Don't use history file. Disable interactive behavrn (Enables --silent.)rn --character-sets-dir=namern Directory for character set files.rn --column-type-info Display column type information.rn -c, --comments Preserve comments. Send comments to the server. Trn default is --skip-comments (discard comments), enrn with --comments.rn -C, --compress Use compression in server/client protocol.rn rn rn rnrnDefault options are read from the following files in the given order:rnC:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf C:\Program FilernySQL\MySQL Server 5.5\my.ini C:\Program Files (x86)\MySQL\MySQL ServerrnfrnThe following groups are read: mysql clientrnThe following options may be given as the first argument:rn--print-defaults Print the program argument list and exit.rn--no-defaults Don't read default options from any option filern--defaults-file=# Only read default options from the given file #rn--defaults-extra-file=# Read this file after the global files are read.rnrnVariables (--variable-name=value)rnand boolean options FALSE|TRUE Value (after reading options)rn--------------------------------- -------------------------------------rnauto-rehash TRUErnauto-vertical-output FALSErncharacter-sets-dir (No default value)rncolumn-type-info FALSErncomments FALSErncompress FALSErndebug-check FALSErndebug-info FALSErndatabase (No default value)rndefault-character-set latin1rndelimiter ;rnvertical FALSErnforce FALSErnnamed-commands FALSErnignore-spaces FALSErninit-command (No default value)rnlocal-infile FALSErnno-beep FALSErnhost localhostrnhtml FALSErnxml FALSErnline-numbers TRUErnunbuffered FALSErncolumn-names TRUErnsigint-ignore FALSErnport 3306rnprompt mysql>rnrnrnC:\Program Files (x86)\MySQL\MySQL Server 5.5\bin>rnrn这是成功还是没成功? 论坛

没有更多推荐了,返回首页