aku juga pernah alami masalah itu..
akhirnya aku coba cara gini:
1. tambahkan path di windows: klik kanan my computer pilih porperties,
advanced, environment variabel, edit path,
tambahkan lokasi dari mysql, OK, OK, OK, restart
2. trus ubah perintah shellnya jadi gini:
st = "cmd /c mysqldump -u admin --password=passwordku nama_database
--result-file=" & sBackupFile
err = Shell(st, 1)
coba deh.. kalo aku bisa sih pake cara ini...
----- Original Message ----
From: Toni Rahayu <[EMAIL PROTECTED]>
To: [email protected]
Sent: Tuesday, December 11, 2007 10:14:06 AM
Subject: [indoprog-vb] Shell for execute mysqldump
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
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
[Non-text portions of this message have been removed]
