Received-SPF: pass (google.com: domain of sentto-8332265-27619-1197429223-toni.rahayu=gmail.com@returns.groups.yahoo.com designates 66.163.168.133 as permitted sender) client-ip=66.163.168.133;
DomainKey-Status: good
Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=lima; d=yahoogroups.com;
	b=POSnIaybwb9fw4BwCCK4WeEVgUXs8SO/Bqez52nnw5NDpMVvDJGlUkSm+Eb53g7zYLtg0CnmlcezM0BF6dZjukkmDxt0x/03vZxGChZ31/b2CatF753Y6jKf6VJo+7dB;
Organization: yahoo.co.id
Message-ID: <0959133.20071212112233@yahoo.co.id>
To: Rizky Prihanto <Programmer-VB@yahoogroups.com>
In-Reply-To: <4030db180712102041h69c1916cg6f4b46d0fada6544@mail.gmail.com>
References: <C72573AE.001195F6.00@omeweb.omedata.com>
 <4030db180712102041h69c1916cg6f4b46d0fada6544@mail.gmail.com>
From: yudhamanik ycid <m4nk_gus@yahoo.co.id>
Sender: Programmer-VB@yahoogroups.com
MIME-Version: 1.0
Mailing-List: list Programmer-VB@yahoogroups.com; contact Programmer-VB-owner@yahoogroups.com
Precedence: bulk
Date: Wed, 12 Dec 2007 11:22:33 -0800
Subject: Re[2]: [Programmer-VB] Shell for execute mysqldump
Reply-To: Programmer-VB@yahoogroups.com
Content-Type: multipart/alternative;
 boundary="RSoDzPPtsif6Gduy-1MvQtoCUxo7SOd8IvqWxKA"

--RSoDzPPtsif6Gduy-1MvQtoCUxo7SOd8IvqWxKA
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

wah, ini dia yg ditunggu...

tapi kok hasil file Test.sql nya 0 byte ya.... ???

(saya jalanin langsung dari command prompt)


RP> dim=A0sQueryString as string
RP> =A0
RP> sQueryString=A0=3D "C:\Program Files\MYSQL\MySQL Server 5.0\bin\mysql=
dump.exe "   _
RP> =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 "-=
-user=3DMyUser -R --triggers
RP> --add-drop-table --verbose "   _
RP> =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
"MyDatabase > D:\backup\Test.sql"
RP> =A0
RP> =A0 Kill "backup.bat"
RP> =A0 Open "backup.bat" For Binary As #1
RP> =A0=A0 Put #1, 1, sQueryString
RP> =A0 Close #1

RP> =A0 d =3D shell("backup.bat", vbNormalFocus)
RP> =A0
RP> DONE!



--RSoDzPPtsif6Gduy-1MvQtoCUxo7SOd8IvqWxKA
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/htm=
l4/strict.dtd">
<html>
<head>
</head>




<body style=3D"background-color: #ffffff;">

<!--~-|**|PrettyHtmlStartT|**|-~-->
<div id=3D"ygrp-mlmsg" style=3D"width:655px; position:relative;">
  <div id=3D"ygrp-msg" style=3D"width: 490px; padding: 0 15px 0 0; float:le=
ft;  z-index:1;">
<!--~-|**|PrettyHtmlEndT|**|-~-->

    <div id=3D"ygrp-text">
            <p>wah, ini dia yg ditunggu...<br>
<br>
tapi kok hasil file Test.sql nya 0 byte ya.... ???<br>
<br>
(saya jalanin langsung dari command prompt)<br>
<br>
RP&gt; dim=A0sQueryString as string<br>
RP&gt; =A0<br>
RP&gt; sQueryString=A0<wbr>=3D &quot;C:\Program Files\MYSQL\<wbr>MySQL Serv=
er 5.0\bin\mysqldump.<wbr>exe &quot;   _<br>
RP&gt; =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 &=
quot;--user=3DMyUser -R --triggers<br>
RP&gt; --add-drop-table --verbose &quot;   _<br>
RP&gt; =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0&quot;MyDatabase &gt; D:\backup\Test.<wbr>sql&quot;<br>
RP&gt; =A0<br>
RP&gt; =A0 Kill &quot;backup.bat&quot;<br>
RP&gt; =A0 Open &quot;backup.bat&quot; For Binary As #1<br>
RP&gt; =A0=A0 Put #1, 1, sQueryString<br>
RP&gt; =A0 Close #1<br>
<br>
RP&gt; =A0 d =3D shell(&quot;backup.<wbr>bat&quot;, vbNormalFocus)<br>
RP&gt; =A0<br>
RP&gt; DONE!<br>
<br>
</p>
    </div>=20=20

    <!--~-|**|PrettyHtmlStart|**|-~-->
    <span width=3D"1" style=3D"color: white;">__._,_.___</span>
    <!-- Start the section with Message In topic -->
    <div id=3D"ygrp-actbar">
              <span class=3D"left">
          <a href=3D"http://groups.yahoo.com/group/Programmer-VB/message/27=
607;_ylc=3DX3oDMTM2YTJtbTFuBF9TAzk3MzU5NzE0BGdycElkAzgzMzIyNjUEZ3Jwc3BJZAMx=
NzA1MTE1MzY0BG1zZ0lkAzI3NjE5BHNlYwNmdHIEc2xrA3Z0cGMEc3RpbWUDMTE5NzQyOTIyNAR=
0cGNJZAMyNzYwNw--">
            Messages in this topic          </a> (<span class=3D"bld">3</sp=
an>)
        </span>
        <a href=3D"http://groups.yahoo.com/group/Programmer-VB/post;_ylc=3D=
X3oDMTJxOHNnNjJxBF9TAzk3MzU5NzE0BGdycElkAzgzMzIyNjUEZ3Jwc3BJZAMxNzA1MTE1MzY=
0BG1zZ0lkAzI3NjE5BHNlYwNmdHIEc2xrA3JwbHkEc3RpbWUDMTE5NzQyOTIyNA--?act=3Drep=
ly&messageNum=3D27619">
          <span class=3D"bld">
            Reply          </span> (via web post)
        </a>  |=20
        <a href=3D"http://groups.yahoo.com/group/Programmer-VB/post;_ylc=3D=
X3oDMTJlaXUxY3B1BF9TAzk3MzU5NzE0BGdycElkAzgzMzIyNjUEZ3Jwc3BJZAMxNzA1MTE1MzY=
0BHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTE5NzQyOTIyNA--" class=3D"bld">
          Start a new topic        </a>
          </div>=20
    <!-------     Start Nav Bar  ------>
    <!-- |**|begin egp html banner|**| -->
    <div id=3D"ygrp-vitnav">
                <a href=3D"http://groups.yahoo.com/group/Programmer-VB/mess=
ages;_ylc=3DX3oDMTJldDB0bHE2BF9TAzk3MzU5NzE0BGdycElkAzgzMzIyNjUEZ3Jwc3BJZAM=
xNzA1MTE1MzY0BHNlYwNmdHIEc2xrA21zZ3MEc3RpbWUDMTE5NzQyOTIyNA--">Messages</a>=
=20=20
            |    <a href=3D"http://groups.yahoo.com/group/Programmer-VB/fil=
es;_ylc=3DX3oDMTJmOTNiMmpiBF9TAzk3MzU5NzE0BGdycElkAzgzMzIyNjUEZ3Jwc3BJZAMxN=
zA1MTE1MzY0BHNlYwNmdHIEc2xrA2ZpbGVzBHN0aW1lAzExOTc0MjkyMjQ-">Files</a>=20=20
            |    <a href=3D"http://groups.yahoo.com/group/Programmer-VB/pho=
tos;_ylc=3DX3oDMTJldGFkdnQwBF9TAzk3MzU5NzE0BGdycElkAzgzMzIyNjUEZ3Jwc3BJZAMx=
NzA1MTE1MzY0BHNlYwNmdHIEc2xrA3Bob3QEc3RpbWUDMTE5NzQyOTIyNA--">Photos</a> =
=20
=20=20=20=20=20=20=20=20
=20=20=20=20=20=20=20=20
=20=20=20=20=20=20=20=20
=20=20=20=20=20=20=20=20
=20=20=20=20=20=20=20=20
    </div>=20=20
    <!-- |**|end egp html banner|**| -->

                        <div id=3D"ygrp-grft">
=20=20=20=20=20=20=20=20=20=20
<!-- |**|begin egp html banner|**| -->

          Wahana Programmer Groups Links<BR>
<BR>
&lt;*&gt; Untuk mengunjungi sponsor milis ini, klik link berikut:<BR>
&nbsp;&nbsp;&nbsp; <a href=3D"http://wahanaprogrammer.net">http://wahanapro=
grammer.net</a><BR>
<BR>
&lt;*&gt; Untuk menghubungi owner milis ini, kirim email ke:<BR>
&nbsp;&nbsp;&nbsp; wahana.programmer@yahoo.co.id<BR>
<BR>
&lt;*&gt; Konsultasi pemrogramman bisa chat disini:<BR>
&nbsp;&nbsp;&nbsp; Yahoo! Messenger: wahanaprogrammer<BR>
=20=20=20=20=20=20=20=20=20=20
<!-- |**|end egp html banner|**| -->

        </div>
=20=20=20=20=20=20
                  <div id=3D"ygrp-mkp">
      <div id=3D"hd">MARKETPLACE</div>
      <div id=3D"ads">
                  <div class=3D"ad">
            <hr size=3D1 noshade><a href=3D"http://us.ard.yahoo.com/SIG=3D1=
2muedlti/M=3D571476.11873916.12370328.11509771/D=3Dgroups/S=3D1705115364:MK=
P1/Y=3DYAHOO/EXP=3D1197436424/A=3D5086951/R=3D0/SIG=3D12k0vbbc9/*http://col=
lege-finder.net/index.cfm?key=3Dyahoo_colfngrouptxt_11873916&c=3DCA15293258=
7">Earn your degree in as few as 2 years - Advance your career with an AS, =
BS, MS degree</a> - College-Finder.net.          </div>
                              </div>
    </div>
=20=20=20=20=20=20
    <!-- yahoo logo -->
    <!-- |**|begin egp html banner|**| -->
    <div id=3D"ygrp-ft">
      <a href=3D"http://groups.yahoo.com/;_ylc=3DX3oDMTJkb2g2aWxmBF9TAzk3Mz=
U5NzE0BGdycElkAzgzMzIyNjUEZ3Jwc3BJZAMxNzA1MTE1MzY0BHNlYwNmdHIEc2xrA2dmcARzd=
GltZQMxMTk3NDI5MjI0">
      <img src=3D"http://us.i1.yimg.com/us.yimg.com/i/yg/img/logo/ma_grp_16=
0.gif" height=3D"15" width=3D"106" border=3D"0" alt=3D"Yahoo! Groups"></a> =
<br>
      <a href=3D"http://groups.yahoo.com/group/Programmer-VB/join;_ylc=3DX3=
oDMTJmOXY2NWw0BF9TAzk3MzU5NzE0BGdycElkAzgzMzIyNjUEZ3Jwc3BJZAMxNzA1MTE1MzY0B=
HNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzExOTc0MjkyMjQ-">Change settings via the We=
b</a> (Yahoo! ID required) <br>
      Change settings via email: <a href=3D"mailto:Programmer-VB-digest@yah=
oogroups.com?subject=3DEmail Delivery: Digest">Switch delivery to Daily Dig=
est</a> | <a href =3D "mailto:Programmer-VB-traditional@yahoogroups.com?sub=
ject=3DChange Delivery Format: Traditional">Switch format to Traditional</a=
> <br>

      <a href=3D"http://groups.yahoo.com/group/Programmer-VB;_ylc=3DX3oDMTJ=
kazlnMGlkBF9TAzk3MzU5NzE0BGdycElkAzgzMzIyNjUEZ3Jwc3BJZAMxNzA1MTE1MzY0BHNlYw=
NmdHIEc2xrA2hwZgRzdGltZQMxMTk3NDI5MjI0">
        Visit Your Group=20
      </a> |
      <a href=3D"http://docs.yahoo.com/info/terms/">
        Yahoo! Groups Terms of Use      </a> |
      <a href=3D"mailto:Programmer-VB-unsubscribe@yahoogroups.com?subject=
=3D">
        Unsubscribe      </a>=20
    </div>     <!-- |**|end egp html banner|**| -->
  </div> <!-- ygrp-msg -->

=20=20
  <!-- Sponsor -->
  <!-- |**|begin egp html banner|**| -->
  <div id=3D"ygrp-sponsor" style=3D"width:140px;float: left; clear: none; m=
argin-left: 5px; background:white; margin-bottom:25px ;position:absolute; t=
op:0; right: 0;">
    <!-- Network content -->
=20=20=20=20
    <!-- Start vitality -->
    <div id=3D"ygrp-vital">
              <div id=3D"vithd">Recent Activity</div>
        <ul style=3D"list-style-type:none; padding: 0; margin: 2px 0;">
=20=20=20=20=20=20=20=20=20=20=20=20
                <li style=3D"clear: both;">
      <div class=3D"ct" style=3D"float: right;"><span style=3D"display:none=
">&nbsp;</span>1</div>
      <div class=3D"cat"><a href=3D"http://groups.yahoo.com/group/Programme=
r-VB/spnew;_ylc=3DX3oDMTJmb3U5NW9qBF9TAzk3MzU5NzE0BGdycElkAzgzMzIyNjUEZ3Jwc=
3BJZAMxNzA1MTE1MzY0BHNlYwN2dGwEc2xrA3ZwaG90BHN0aW1lAzExOTc0MjkyMjQ-">New Ph=
otos</a></div>
    </li>
=20=20
=20=20=20=20=20=20=20=20=20=20=20=20
=20=20=20=20=20=20=20=20=20=20=20=20
=20=20=20=20=20=20=20=20=20=20=20=20
=20=20=20=20=20=20=20=20=20=20=20=20
        </ul>
            <a href=3D"http://groups.yahoo.com/group/Programmer-VB;_ylc=3DX=
3oDMTJlOWZxc2sxBF9TAzk3MzU5NzE0BGdycElkAzgzMzIyNjUEZ3Jwc3BJZAMxNzA1MTE1MzY0=
BHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTE5NzQyOTIyNA--">
        Visit Your Group      </a>
    </div>=20
=20=20=20=20=20=20=20=20=20=20=20=20=20=20
    <!-- Network content -->
              <div id=3D"nc">
              <div class=3D"ad">
                      <div id=3D"hd1">Y! Messenger</div>=20
<p><a href=3D"http://us.ard.yahoo.com/SIG=3D12jup8477/M=3D493064.10729668.1=
1333359.8674578/D=3Dgroups/S=3D1705115364:NC/Y=3DYAHOO/EXP=3D1197436424/A=
=3D3848578/R=3D0/SIG=3D11umg3fun/*http://us.rd.yahoo.com/evt=3D42403/*http:=
//messenger.yahoo.com">Files to share?</a></p>=20
<p>Send up to 1GB of</p>=20
<p>files in an IM.</p>                  </div>
                    <div class=3D"ad">
                      <div id=3D"hd1">Yahoo! Groups</div>=20
<p><a href=3D"http://us.ard.yahoo.com/SIG=3D12jsle4jb/M=3D493064.11036139.1=
1614791.8674578/D=3Dgroups/S=3D1705115364:NC/Y=3DYAHOO/EXP=3D1197436424/A=
=3D4725796/R=3D0/SIG=3D1192rfjiu/*http://groups.yahoo.com/group/realfood/">=
Real Food Group</a></p>=20
<p>Share recipes</p>=20
<p>and favorite meals.</p>                  </div>
                    <div class=3D"ad">
                      <div id=3D"hd1">Best of Y! Groups</div>=20
<p><a href=3D"http://us.ard.yahoo.com/SIG=3D12jj99j8r/M=3D493064.11127061.1=
1695037.8674578/D=3Dgroups/S=3D1705115364:NC/Y=3DYAHOO/EXP=3D1197436424/A=
=3D4763762/R=3D0/SIG=3D11ou7otip/*http://advision.webevents.yahoo.com/besto=
fyahoogroups/">Discover groups</a></p>=20
<p>that are the best</p>=20
<p>of their class.</p>                  </div>
          </div>
=20=20=20=20
  </div>   <!-- |**|end egp html banner|**| -->
  <div style=3D"clear:both; color: #FFF; font-size:1px;">.</div>
</div>   <img src=3D"http://geo.yahoo.com/serv?s=3D97359714/grpId=3D8332265=
/grpspId=3D1705115364/msgId=3D27619/stime=3D1197429224/nc1=3D3848578/nc2=3D=
4725796/nc3=3D4763762" width=3D"1" height=3D"1"> <br>

<span  style=3D"color: white;">__,_._,___</span>
<!--~-|**|PrettyHtmlEnd|**|-~-->
</body>
<!--~-|**|PrettyHtmlStart|**|-~-->
<head>
<style type=3D"text/css">
<!--
#ygrp-mkp{
  border: 1px solid #d8d8d8;
  font-family: Arial;
  margin: 14px 0px;
  padding: 0px 14px;
}
#ygrp-mkp hr{
  border: 1px solid #d8d8d8;
}
#ygrp-mkp #hd{
  color: #628c2a;
  font-size: 85%;
  font-weight: bold;
  line-height: 122%;
  margin: 10px 0px;
}
#ygrp-mkp #ads{
  margin-bottom: 10px;
}
#ygrp-mkp .ad{
  padding: 0 0;
}
#ygrp-mkp .ad a{
  color: #0000ff;
  text-decoration: none;
}
-->
</style>
</head>
<head>
<style type=3D"text/css">
<!--
#ygrp-sponsor #ygrp-lc{
  font-family: Arial;
}
#ygrp-sponsor #ygrp-lc #hd{
  margin: 10px 0px;
  font-weight: bold;
  font-size: 78%;
  line-height: 122%;
}
#ygrp-sponsor #ygrp-lc .ad{
  margin-bottom: 10px;
  padding: 0 0;
}
-->
</style>
</head>
<head>
<style type=3D"text/css">
<!--
#ygrp-mlmsg {font-size:13px; font-family: arial,helvetica,clean,sans-serif;=
*font-size:small;*font:x-small;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-se=
rif;}
#ygrp-mlmsg pre, code {font:115% monospace;*font-size:100%;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
    font-family: Georgia;=09
}
#ygrp-text p{
    margin: 0 0 1em 0;
}
#ygrp-tpmsgs{
    font-family: Arial;=09
    clear: both;
}
#ygrp-vitnav{
	padding-top: 10px;
	font-family: Verdana;
	font-size: 77%;
	margin: 0;
}
#ygrp-vitnav a{
	padding: 0 1px;
}
#ygrp-actbar{
	clear: both;
	margin: 25px 0;
	white-space:nowrap;
	color: #666;
	text-align: right;
}
#ygrp-actbar .left{
	float: left;
	white-space:nowrap;
}
.bld{font-weight:bold;}
#ygrp-grft{
	font-family: Verdana;
	font-size: 77%;
	padding: 15px 0;
}
#ygrp-ft{
  font-family: verdana;
  font-size: 77%;
  border-top: 1px solid #666;=20
  padding: 5px 0;=20
}
#ygrp-mlmsg #logo{
  padding-bottom: 10px;
}

#ygrp-vital{
	background-color: #e0ecee;
	margin-bottom: 20px;
	padding: 2px 0 8px 8px;
}
#ygrp-vital #vithd{
	font-size: 77%;
	font-family: Verdana;
	font-weight: bold;
	color: #333;
	text-transform: uppercase;
}
#ygrp-vital ul{
	padding: 0;
	margin: 2px 0;
}
#ygrp-vital ul li{
  list-style-type: none;
  clear: both;
  border: 1px solid #e0ecee;=20=20
}
#ygrp-vital ul li .ct{
  font-weight: bold;
  color: #ff7900;
  float: right;
  width: 2em;
  text-align:right;
  padding-right: .5em;
}
#ygrp-vital ul li .cat{
  font-weight: bold;
}
#ygrp-vital a{
	text-decoration: none;
}

#ygrp-vital a:hover{
  text-decoration: underline;
}

#ygrp-sponsor #hd{
	color: #999;
	font-size: 77%;
}
#ygrp-sponsor #ov{
	padding: 6px 13px;
	background-color: #e0ecee;
	margin-bottom: 20px;
}
#ygrp-sponsor #ov ul{
	padding: 0 0 0 8px;
	margin: 0;
}
#ygrp-sponsor #ov li{
	list-style-type: square;
	padding: 6px 0;
	font-size: 77%;
}
#ygrp-sponsor #ov li a{
	text-decoration: none;
	font-size: 130%;
}
#ygrp-sponsor #nc{
  background-color: #eee;
  margin-bottom: 20px;
  padding: 0 8px;
}
#ygrp-sponsor .ad{
	padding: 8px 0;
}
#ygrp-sponsor .ad #hd1{
	font-family: Arial;
	font-weight: bold;
	color: #628c2a;
	font-size: 100%;
	line-height: 122%;
}
#ygrp-sponsor .ad a{
	text-decoration: none;
}
#ygrp-sponsor .ad a:hover{
	text-decoration: underline;
}
#ygrp-sponsor .ad p{
	margin: 0;
}
o{font-size: 0; }
.MsoNormal{
   margin: 0 0 0 0;
}
#ygrp-text tt{
  font-size: 120%;
}
blockquote{margin: 0 0 0 4px;}
.replbq{margin:4}
-->
</style>
</head>
<!--~-|**|PrettyHtmlEnd|**|-~-->
</html><!--End group email -->


--RSoDzPPtsif6Gduy-1MvQtoCUxo7SOd8IvqWxKA--