Great Ide, Cuma masih ada masalah pada file backup.bat nya, backup sukses hanya sampai create file Test.sql saja yang isinya kosong (file size 0 byte) saya coba jalankan manual file backup.bat nya hasilnya sama, isi file masih kosong padahal kalo saya coba ketik langsung di command promt hasilnya sukses, isi file bat dari hasil running program :
C:\Program Files\MYSQL\MySQL Server 5.0\bin\mysqldump.exe -u root suryakencana >
C:\backup\Test.sql
NB: user = root, database = suryakencana, MySQL version = 5.0
Ditunggu solusinya bos...
Thx B4
"Rizky Prihanto" <[EMAIL PROTECTED]> on 12/11/2007 04:41:11 AM
Please respond to [email protected]
To: [email protected]
cc: (bcc: Toni Rahayu/IT/domino_srv)
Subject: Re: [Programmer-VB] Shell for execute mysqldump
betul sekali. ngga error. dulu aku jg sempet stress spanyol pas mo bikin
utility utk backup via mysqldump. masalahnya, shell ngga bs njalanin pake
parameter. tapi akhirnya aku nemu caranya, aku akalin manfaatin file *.bat
(batch execute). script nya gini :
dim sQueryString as string
sQueryString = "C:\Program Files\MYSQL\MySQL Server 5.0\bin\mysqldump.exe "
& _
"--user=MyUser -R --triggers --add-drop-table
--verbose " & _
"MyDatabase > D:\backup\Test.sql"
Kill "backup.bat"
Open "backup.bat" For Binary As #1
Put #1, 1, sQueryString
Close #1
d = shell("backup.bat", vbNormalFocus)
DONE!
parameter2 lainnya, itu optional
-R : utk dumping stored procedure/function
--triggers : utk dumping trigger
--verbose : utk nampilin proses dumping
lainnya, silakan liat ndiri di mysqldump --help ^_^
cobain deh om..
--
regards,
Rizky Prihanto
~~~~~~~~~~~~~~~~~~~
Office : C4 Computer Communities Club (http://www.cee-papat.com)
Personal : http://www.software-arsitek.web.id
On Dec 11, 2007 10:12 AM, Toni Rahayu <[EMAIL PROTECTED]> wrote:
>
>
> Dear All,
> Saya minta bantuan nih, saya pake ini :
>
> d = Shell("C:\Program Files\MYSQL\MySQL Server 5.0\bin\mysqldump.exe -u
> MyUser
> MyDatabase>D:\backup\Test.sql", vbNormalFocus)
>
> script ini gak error, cuma gak nyimpan, padahal kalau saya ketik langsung
> di
> command prompt langsung nyimpan gak masalah.
>
> Thanks B4
>
>
>
>
> Wahana Programmer Groups Links
>
> Yahoo! Groups Links
>
>
>
>
|
betul sekali. ngga error. dulu aku jg sempet stress spanyol pas mo bikin utility utk backup via mysqldump. masalahnya, shell ngga bs njalanin pake parameter. tapi akhirnya aku nemu caranya, aku akalin manfaatin file *.bat (batch execute). script nya gini :
dim sQueryString as string
sQueryString = "C:\Program Files\MYSQL\
"--user=MyUser -R --triggers --add-drop-table --verbose " & _
"MyDatabase > D:\backup\Test.
Kill "backup.bat"
Open "backup.bat" For Binary As #1 Put #1, 1, sQueryString Close #1 d = shell("backup.bat", vbNormalFocus) DONE!
parameter2 lainnya, itu optional
-R : utk dumping stored procedure/function
--triggers : utk dumping trigger
--verbose : utk nampilin proses dumping
lainnya, silakan liat ndiri di mysqldump --help ^_^
cobain deh om..
-- regards, Rizky Prihanto ~~~~~~~~~~~~ Office : C4 Computer Communities Club (http://www.cee- Personal : http://www.software On Dec 11, 2007 10:12 AM, Toni Rahayu <toni.rahayu@
|
att2.eml
Description: Binary data
Toni Rahayu PT. Omedata Electronics IT Department Hunting : (62-22) 6030805 Ext 121 Faxs : (62-22) 6030896 Homepage : http://www.toni-rahayu.co.cc
