[root@www]# /usr/local/mysql/bin/mysql -u root -p mydb <mydb.dump
z;[ G`#P,S
g3O
Enter password:
GN_6V*J2X*xgERROR 1049:Unknow database 'mydb'
Linux伊甸园论坛@9u P^})Ud
这是怎么回事？？？下面是一个测试ＭＹＳＱＬ的程序：
&[5Y [-Ei;_7Z
安装MySQL后，建立一个mydb.dump文件，包含入下内容：
Linux伊甸园论坛sp
~ e1W j&N
P'c ?)Z
z*i)L"F:J
CREATE TABLE employees ( id tinyint(4) DEFAULT '0' NOT NULL
d;Y%wDy
Kf(V8K5WAUTO_INCREMENT, first varchar(20), last varchar(20),
H(fB
u5s} nr
address varchar(255), position varchar(50), PRIMARY KEY (id),
8b }4M8xK y
UNIQUE id (id));
4dkV#s/~
A
INSERT INTO employees VALUES (1,'Bob','Smith',
:^
V {? M2i3TV'128 Here St, Cityname','Marketing Manager');
www.linuxeden.comZA"j6S1M
Linux伊甸园论坛9zhMS3Dy8cX,?`[
INSERT INTO employees VALUES (2,'John','Roberts','45 There St,
$n7?#\]zBJcovjMTownville','Telephonist');
www.linuxeden.com fg/a$\JD ~K$V opv-o
Linux伊甸园论坛@|4y8\)fO S4J {F
INSERT INTO employees VALUES (3,'Brad','Johnson','1/34 Nowhere Blvd,
Q*pK7E,s._ VSnowston','Doorman');
(J H#V:j,x!Pr#ELinux伊甸园论坛|7H4{)EZb{0_2W
? \D zx H N然后用这个SQL脚本在MySQL中创建一个数据库mydb，在shell下打入下列命令：
\4^+N(qU lwww.linuxeden.com mysql -u root -pyourpasswd mydb <mydb.dump
"nlu
b/Zkq
Z8S~5su@lLinux伊甸园论坛创建后上述数据库后，创建一个php3脚本文件，如test.php3，其内容如下：
b\t7^7E6g:i
(D,xK;_7b<html>
:^/F!T8z.jA.zoS Q
Q9v;YD-y6r j DC/T<body>
www.linuxeden.com_2P,fr} z-|9_v
V
nK:M*ez<?php
2b(Yr4Zp E0d H,O g;vQ+^}1iD$n](iv
$db = mysql_connect("localhost", "root","12345");
www.linuxeden.com_ g,n,_8FT e
Linux伊甸园论坛 {9M8E(yh d.K*]u
mysql_select_db("mydb",$db);
7a}!BS6aC|(lw
www.linuxeden.com/h9~;yLn)Q e,`
$result = mysql_query("SELECT * FROM employees",$db);
u!`7Cu}C I:h~
`P G/}&J b1v,a;tEwww.linuxeden.comprintf("First Name: %s<br>\n", mysql_result($result,0,"first"));
,W,e ul$Z%hSN
www.linuxeden.comzs4F C
\
W9A}-T
printf("Last Name: %s<br>\n", mysql_result($result,0,"last"));
E bm6s*|!{;B5cq
E@8pv2} \4b5}y
TLinux伊甸园论坛printf("Address: %s<br>\n", mysql_result($result,0,"address"));
;D n&xd*X3f3B @www.linuxeden.com`&QRwo7J2\g
q
printf("
osition: %s<br>\n", mysql_result($result,0,"position"));
\YR~*T oDW
,P \c:} `:Y p [?>
{0p NM:xj
H/u`B9s
h^Linux伊甸园论坛</body>
www.linuxeden.com0nfG,i B R$o
(S i m `-IaEwww.linuxeden.com</html>
www.linuxeden.comX)u8jfXG Jw
iJ.k
a/o
}NL
1h z n+C.@0E&v.ZN;dU!M
3W qKg`WA ^Linux伊甸园论坛其显示的结果应该是：
Q*}:e2O8K/y1`gR
%m v\EA+{Z4Y JpFirst Name: Bob
Z#X f)jWq ^Last Name: Smith
x9S-R^
v\{ f_0N
Address: 128 Here St, Cityname
z4H6f0K p'FW7b(rPosition: Marketing Manager
Linux伊甸园论坛"aI7?
V D
www.linuxeden.com,r8w]R`(~
请问有没有什么问题？？？
'_,s,X*J1g'uc+m C
