[Bioperl-pipeline] Help! Stuck with setting up (mysql this time)

Peter Kos kos@rite.or.jp" <kos@rite.or.jp
Wed, 28 Aug 2002 21:29:11 +0900


 

begin 600 sql2.txt
M2&D@86QL+ T*#0I3;W)R>2P@:70@<VAO=6QD(&=O('!E<FAA<',@=&\@82!M
M>7-Q;"!L:7-T+"!B=70@22!A;2!A9G)A:60L('1H870@#0IO=&AE<B!P<F]B
M;&5M<R!W:6QL(&9O;&QO=R!T:&ES(&]N92P@<V\@22!A<VL@>6]U(&%B;W5T
M('1H:7,@;VYE('1O;RX-"@T*/B!A;F0@=&AE;B!I="=S(&5A<VEE<B!F;W(@
M=7,@=&\@:&5L<"!Y;W4-"CX@=&\@<V5T=7 @82!P:7!E;&EN92!I;B!T:&%T
M(&1I<F5C=&EO;C\-"CX@#0H^($QO;VMI;F<@9F]R=V%R9"!T;R!D:7-C=7-S
M(&ET(&9U<G1H97(L#0H-"DD@86T@9&5A9"X@22!H879E('-T=6-K(&EN('1H
M92!M:61D;&4@;V8@:6YS=&%L;&EN9R -"G1H92!N96-E<W-A<GD@8V]M<&]N
M96YT<R!F;W(@=&AE(&)I;W!E<FPM<&EP96QI;F4-"@T*22!W;W)K(&]N(&$@
M4W5N("A3=6Y";&%D92D@*%5L=')A<W!A<F,I+"!3;VQA<FES. T*#0I)(&AA
M=F4@4&5R;"!A;F0@0FEO<&5R;"X@*$D@;6%Y('-U<F5L>2!N965D('-O;64@
M;6]R90T*<W1U9F8@9F]R('1H92!P:7!E;&EN92P@8G5T('1H870@:7,@9F]R
M(&QA=&5R+BD-"@T*22!H879E(&EN<W1A;&QE9"!$0DDN(%1E<W1S(&%R92!/
M2RP@:6YS=&%L;&5D(&9I;F4N#0H-"DD@9&]W;FQO861E9"!T:&4@8FEN87)Y
M(&1I<W1R:6)U=&EO;B!O9B!M>7-Q;"P@86YD(&QA=&5R+ T*87,@22!D:60@
M;F]T(&AA=F4@86YY(&)E='1E<B!I9&5A+"!M>7-Q;"UM87@@=&]O+@T*0F]T
M:"!W97)E('9E<GD@96%S>2!T;R!I;G-T86QL+B!"=70@;F]N92!O9B!T:&5M
M('=O<FLN#0I/<B!T:&5Y(&1O+"!J=7-T(&YO="!F;W(@;64N#0H-"DD@<F%N
M('1H92 N+V-O;F9I9W5R92!S8W)I<'0L('=H:6-H('1H96X@<V%I9"!T:&%T
M(&ET(&1O97,@;F]T(&YE960@#0IC;VYF:6=U<F%T:6]N+"!A;F0@86QS;R!S
M86ED(&AO=R!T;R!S=&%R="!T:&4@<V5R=F5R+B!)(&9O;&QO=V5D('1H870L
M( T*3TLL('1H92!S97)V97(@<W1A<G1E9"!A;F0@:6UM961I871E;'D@<VAU
M="!D;W=N('=I=&AO=70@8V]M<&QA:6YI;F<N#0HH;65S<V%G92!I;F-L=61E
M9"!B96QO=R!A<R!415A4,2D-"@T*6RA">2!T:&4@=V%Y+"!I9B!)(')U;B N
M+W-A9F5?;7ES<6QD(&9R;VT@=&AE(&UY<W%L+V)I;B!D:7(L(')A=&AE<B!T
M:&%N#0HN+V)I;B]S869E7VUY<W%L9"!F<F]M('1H92!M>7-Q;"!D:7(L(&ET
M(&-O;7!L86EN<R!T:&%T.@T*#0HB5&AE(&9I;&4@+W5S<B]L;V-A;"]M>7-Q
M;"]L:6)E>&5C+VUY<W%L9"!D;V5S;B=T(&5X:7-T(&]R(&ES(&YO="!E>&5C
M=71A8FQE#0I0;&5A<V4@9&\@82!C9"!T;R!T:&4@;7ES<6P@:6YS=&%L;&%T
M:6]N(&1I<F5C=&]R>2!A;F0@<F5S=&%R= T*=&AI<R!S8W)I<'0@9G)O;2!T
M:&5R92!A<R!F;VQL;W=S.@T*+B]B:6XO<V%F95]M>7-Q;&0N(@T*=VAI8V@@
M;6%K97,@<V5N<V4@87,@=&AE<F4@:7,@;F]T:&EN9R!L:6ME("XN+B]L:6)E
M>&5C(&1I<F5C=&]R>2P@#0IA;F0@22!D;R!N;W0@:VYO=R!H;W<@22!C;W5L
M9"!H879E(&]N92P@=VAY(&%N9"!W:&%T('1O(&AA=F4@:6X@=&AE<F4N*5T-
M"@T*#0IM>7-Q;"UT97-T+7)U;B!W;W)K960@;FEC96QY+B!)="!S:VEP<&5D
M(&=E;6EN:2P@:7-O;&%T:6]N(&%N9"!R86ED('1E<W1S+" -"F)U="!O=&AE
M<G=I<V4@:70@=V%S('!E<F9E8W0Z#0H@#0HB16YD:6YG(%1E<W1S#0I3:'5T
M=&EN9RUD;W=N($UY4U%,(&1A96UO;@T*#0I-87-T97(@<VAU=&1O=VX@9FEN
M:7-H960-"E-L879E('-H=71D;W=N(&9I;FES:&5D#0I!;&P@,3,Y('1E<W1S
M('=E<F4@<W5C8V5S<V9U;"XB#0H@#0H-"E1H92!R96%S;VX@=VAY($D@86T@
M<&%N:6-K:6YG(&ES('1H870@22!C86X@;F]T(&ME97 @=&AE(&1A96UO;B!A
M;&EV92X-"DD@<W1R;VYG;'D@<W5S<&5C="!T:&%T('1H92!D97-I9VYE<G,@
M;V8@=&AE(&UY<W%L(&UA>2!K;F]W('-O;65T:&EN9R -"F%B;W5T(&UY<W%L
M+"!T:&%T($D@9&]N)W0N( T*22!H;W!E+"!Y;W4@=&]O+@T*#0I&;W(@<G5N
M;FEN9R!R=6XM86QL+71E<W1S(&EN('-Q;"UB96YC:"P@22!N965D($1"1"P@
M8G5T(&9O<B!T:&4@#0HG;6%K92!T97-T)PT*;V8@1$)$($D@;F5E9"!T:&4@
M<V5R=F5R(')U;FYI;F<L(&)U="!A9V%I;B!A8V-O<F1I;F<@=&\@=&AE('1E
M>'0@8F5L;W<L( T*:70@:G5S="!S=&%R=',@86YD(&5N9',@9F]R(&UE+@T*
M#0I!;'1H;W5G:"!T:&4@)V-O;F9I9W5R92<@<V%Y<R!T:&%T($D@9&\@;F]T
M(&YE960@=&\@8V]N9FEG=7)E(&%N>71H:6YG+ T*22!T<FEE9"!T;R!D;R!T
M:&%T(&EN(&QA8VL@;V8@86YY(&)E='1E<B!I9&5A+B!!;F0@;6]R96]V97(@
M<VEN8V4@=&AR;W5G:&]U=" -"FAO=7)S(&]F(&%G;VYY(&]N92!O9B!T:&4@
M;6%N=6%L<R!S=6=G97-T960@=&\@=')Y('1H92 -"G!O<G0@*&YU;6)E<B!W
M:&%T979E<BD@=FEA('1E;&YE="P@86YD('1H870@9&ED(&YO="!W;W)K(&5I
M=&AE<BP@86YD($D@86T-"F-O;7!L971E;'D@86YD(&9U;&QY('5N87=A<F4@
M:&]W('1O(&AA;F1L92!T:&4@<&]R=',N#0H-"B=B96YC:"UI;FET+G!L)R!I
M;B!T:&4@<W%L+6)E;F-H(&1I<F5C=&]R>2 B0V%N)W0@;&]C871E("]S97)V
M97(M8V9G(&EN($!)3D,B#0IW:&EC:"!R96%L;'D@;6%D92!M92!M860L(&%S
M('1H92!C;W)R97-P;VYD:6YG(&QI;F4@:7,-"@T*<F5Q=6ER92 B)'!W9"]S
M97)V97(M8V9G(B!\?"!D:64@(D-A;B=T(')E860@0V]N9FEG=7)A=&EO;B!F
M:6QE.B D(5QN(CL@#0H-"BT@=VAE<F4@*&%L=&AO=6=H(')E<75I<F4I(&ET
M('-H;W5L9"!H879E(&QO;VME9"!T;R!T:&4@8W5R<F5N="!D:7(L( T*=VAE
M<F4@=&AA="!D86UN(&9I;&4@:7,@<VUI;&EN9R!A="!M92P@#0HM(&UO<F5O
M=F5R('1H92!E<G)O<B!M97-S86=E(&EN('1H:7,@;&EN92!I<R!D:69F97)E
M;G0@9G)O;2!W:&%T($D@9V5T( T**'!E<FAA<',@<V]M92!B=6EL="UI;B!0
M97)L(&UE<W-A9V4L(')A=&AE<B!T:&%N('1H92 G9&EE)RUT97AT+" -"BT@
M86YD(&UO<F5O=F5R($D@<')E<&5N9&5D('1H92!C=7)R96YT(&1I<F5C=&]R
M>2!T;R! 24Y#(&%S(&9O;&QO=W,L(&%N9"!S=&EL; T*:&%D('1H92!E<G)O
M<B!M97-S86=E(&%S(&9O;&QO=W,N("A415A4,BD-"DD@9W5E<W,@=&AA="!P
M97)H87!S("(D<'=D(B!I<R!E;7!T>2P@<V\@:70@;&]O:W,@870@=&AE(')O
M;W0@9&ER+B -"E=E;&PL('=H871E=F5R+@T*#0H-"E-/+"!)3B!"4DE%1BP-
M"B!C;W5L9"!A;GEO;F4@=&5L;"!M92!W:&%T(&]N(&5A<G1H('1O(&1O(&EN
M(&]R9&5R('1O(&ME97 @=&AE('-A9F5?;7ES<6QD(&%L:79E/PT*#0I4:&4@
M=&5X="!F<F]M("XO8V]N9FEG=7)E(&ES(&-O;7!L971E;'D@<VAA;65L97-S
M+B!)="!K:6YD;'D@=&5L;',@;64@:&]W('1O#0IS=&%R="!T:&4@37E344P@
M9&%E;6]N+"!A;F0@:&]W('1O('1E<W0@:70@8F5I;F<@=7 @86YD(&9U;F-T
M:6]N:6YG(&YI8V5L>2P@#0IB=70@;F]T:&EN9R!A8F]U="!W:'D@:70@:6UM
M961I871E;'D@96YD<RX-"E-I;6EL87)L>2!A;&P@=&AE(&EN<W1A;&QA=&EO
M;B!I;G-T<G5C=&EO;G,@86YD(&]T:&5R(&UA;G5A;',@=&AA="!))W9E('-E
M96X-"G1R;W5B;&5S:&]O="!S97)I;W5S(&ES<W5E<R!O9B N<V\@86YD("YH
M(&9I;&5S(&)U="!T:&ES('!R;V)L96T@:7,@;F5V97(@;65N=&EO;F5D+@T*
M#0I9;W5R(&MI;F0@:&5L<"!W;W5L9"!T:&5R969O<F4@8F4@:&EG:&QY(&%P
M<')E8VEA=&5D+@T*0VAE97)S#0I0971E<@T*#0H-"CQ415A4,2 J*BHJ*BHJ
M*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*CX-"@T**BHJ("]U<W(O;&]C86PO;7ES
M<6PZ(#(T-2 J*BH@(" @(" @(" @#0H^8V0@+B [("XO8FEN+W-A9F5?;7ES
M<6QD("8-"ELQ72 R.#0V. T*/E-T87)T:6YG(&UY<W%L9"!D865M;VX@=VET
M:"!D871A8F%S97,@9G)O;2 O=7-R+VQO8V%L+VUY<W%L+V1A=&$-"C R,#@R
M." Q-3HT,3HU," @;7ES<6QD(&5N9&5D#0H-"CPO5$585#$@*BHJ*BHJ*BHJ
M*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*CX-"@T*#0H\5$585#(@*BHJ*BHJ*BHJ*BHJ
M*BHJ*BHJ*BHJ*BHJ*BHJ*BH^#0H-"BHJ*B O=7-R+VQO8V%L+VUY<W%L+W-Q
M;"UB96YC:#H@,C@P("HJ*B @#0H^<&5R;" M22 O=7-R+VQO8V%L+VUY<W%L
M+W-Q;"UB96YC:"!B96YC:"UI;FET+G!L#0I#86XG="!L;V-A=&4@+W-E<G9E
M<BUC9F<@:6X@0$E.0R H0$E.0R!C;VYT86EN<SH@+W5S<B]L;V-A;"]M>7-Q
M;"]S<6PM8F5N8V@@#0HO=7-R+W!E<FPU+S4N,# U,#,O5&LX,# N,#(S+V)L
M:6(O;&EB+R O=7-R+W!E<FPU+S4N,# U,#,O<W5N-"US;VQA<FES( T*+W5S
M<B]P97)L-2\U+C P-3 S("]U<W(O<&5R;#4O<VET95]P97)L+S4N,# U+W-U
M;C0M<V]L87)I<R -"B]U<W(O<&5R;#4O<VET95]P97)L+S4N,# U("XI(&%T
M(&)E;F-H+6EN:70N<&P@;&EN92 S-RX-"B @(" @(" -"BHJ*B O=7-R+VQO
M8V%L+VUY<W%L+W-Q;"UB96YC:#H@,C@Q("HJ*@T*/FQS#0I#:&%N9V5,;V<@
M(" @(" @(" @(" @(%)E<W5L=',M=VEN,S(@(" @(" @(" @8W)A<V@M;64@
M(" @(" @(" @(" @("!S97)V97(M8V9G(" @(" @(" @(" @('1E<W0M8W)E
M871E#0I#;VUM96YT<R @(" @(" @(" @(" @(%1/1$\@(" @(" @(" @(" @
M(" @(" @9W)A<&@M8V]M<&%R92UR97-U;'1S("!T97-T+4%425,@(" @(" @
M(" @(" @('1E<W0M:6YS97)T#0I$871A(" @(" @(" @(" @(" @(" @(&)E
M;F-H+6EN:70N<&P@(" @(" @(" @;&EM:71S(" @(" @(" @(" @(" @("!T
M97-T+6%L=&5R+71A8FQE(" @(" @('1E<W0M<V5L96-T#0I214%$344@(" @
M(" @(" @(" @(" @(&-O;7!A<F4M<F5S=6QT<R @(" @(" @;W5T<'5T(" @
M(" @(" @(" @(" @("!T97-T+6)I9RUT86)L97,@(" @(" @('1E<W0M=VES
M8V]N<VEN#0I297-U;'1S(" @(" @(" @(" @(" @(&-O<'DM9&(@(" @(" @
M(" @(" @(" @<G5N+6%L;"UT97-T<R @(" @(" @("!T97-T+6-O;FYE8W0-
M"B @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -
M"@T*(R,C3$E.13,W.@T*<F5Q=6ER92 B)'!W9"]S97)V97(M8V9G(B!\?"!D
M:64@(D-A;B=T(')E860@0V]N9FEG=7)A=&EO;B!F:6QE.B D(5QN(CL-"@T*
M/"]415A4,B J*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ/@T*#0H-"BXN
M+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN
M+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BX-"E!E=&5R($(N($MO<RP@
I4&@N1"X-"BA2251%*0T*12UM86EL.B!K;W- <FET92YO<BYJ< T*#0IO
`
end