Subject: Re[2]: [Programmer-VB] Shell for execute mysqldump
From: yudhamanik ycid <[email-masked]>
To: Rizky Prihanto <[email-masked]>
Date: Wed, 12 Dec 2007 11:22:33 -0800
List-Id: <Programmer-VB.yahoogroups.com>

wah, ini dia yg ditunggu...

tapi kok hasil file Test.sql nya 0 byte ya.... ???

(saya jalanin langsung dari command prompt)

RP> dim sQueryString as string
RP>  
RP> sQueryString = "C:\Program Files\MYSQL\MySQL Server 5.0\bin\mysqldump.exe "   _
RP>                        "--user=MyUser -R --triggers
RP> --add-drop-table --verbose "   _
RP>                        "MyDatabase > D:\backup\Test.sql"
RP>  
RP>   Kill "backup.bat"
RP>   Open "backup.bat" For Binary As #1
RP>    Put #1, 1, sQueryString
RP>   Close #1

RP>   d = shell("backup.bat", vbNormalFocus)
RP>  
RP> DONE!