Selasa, 20 Juli 2010

backup database mysql dg vb

15.45  twin_c  2 comments

Pernah ditanya soal back up database my sql dengan visual basic...stelah searching n testing..,kaya gini ni scriptnya:

Private Sub Command1_Click()
Open "C:\bkTest.bat" For Output As #1
Dim ComandoSh As String
ComandoSh = "c:\mysql\bin\mysqldump.exe --host=localhost --user=root --password=pasTest --database=DBTest -R DBTest > c:\BKTest.sql"
Print #1, ComandoSh
Close 1
ProcId = Shell("C:\bkTest.bat", vbHide)
End Sub

Where:
host=localhost
user=root
pass=pasTest
database=DBTest
Backup file = BKTest.sql

Posted in:

2 komentar:

Where: ' error di bagian ini "where:" mbak..?? Tolong pencerahannya makasih...

host=localhost
user=root
pass=pasTest
database=DBTest
Backup file = BKTest.sql

WHERE GAK USAH DITULIS,,,ITU CUMA KETERANGAN..

Posting Komentar