mysql 导入DMP文件
C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin>mysql -h localhost -u
ot phone < D:\phone.DMP;
mysql Ver 14.14 Distrib 5.5.15, for Win32 (x86)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights rese
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Usage: mysql [OPTIONS] [database]
-?, --help Display this help and exit.
-I, --help Synonym for -?
--auto-rehash Enable automatic rehashing. One doesn't need to u
'rehash' to get table and field completion, but s
and reconnecting may take a longer time. Disable
--disable-auto-rehash.
(Defaults to on; use --skip-auto-rehash to disabl
-A, --no-auto-rehash
No automatic rehashing. One has to use 'rehash' t
table and field completion. This gives a quicker
mysql and disables rehashing on reconnect.
--auto-vertical-output
Automatically switch to vertical output mode if t
result is wider than the terminal width.
-B, --batch Don't use history file. Disable interactive behav
(Enables --silent.)
--character-sets-dir=name
Directory for character set files.
--column-type-info Display column type information.
-c, --comments Preserve comments. Send comments to the server. T
default is --skip-comments (discard comments), en
with --comments.
-C, --compress Use compression in server/client protocol.
Default options are read from the following files in the given order:
C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf C:\Program File
ySQL\MySQL Server 5.5\my.ini C:\Program Files (x86)\MySQL\MySQL Server
f
The following groups are read: mysql client
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit.
--no-defaults Don't read default options from any option file
--defaults-file=# Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read.
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -------------------------------------
auto-rehash TRUE
auto-vertical-output FALSE
character-sets-dir (No default value)
column-type-info FALSE
comments FALSE
compress FALSE
debug-check FALSE
debug-info FALSE
database (No default value)
default-character-set latin1
delimiter ;
vertical FALSE
force FALSE
named-commands FALSE
ignore-spaces FALSE
init-command (No default value)
local-infile FALSE
no-beep FALSE
host localhost
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 3306
prompt mysql>
C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin>
这是成功还是没成功?