Import mysql table with VBscript

		Webmaster Forum > Scripting/Programming & Debugging > ASP & VBScript Forum
Import mysql table with VBscript

ASP & VBScript Forum Need help from a webmaster with ASP or VBScript, you may ask in this forum?

LinkBack

Thread Tools

Display Modes

#1 (permalink)

07-08-2008, 05:33 PM

apffal

Junior Member

Join Date: Jul 2008

Posts: 1

apffal is an unknown quantity at this point

Import mysql table with VBscript

I cannot import a mysql table into a database using a VBscript, using the code below
What' s wrong ?
Thanks in advance

Code:

Set objShell = CreateObject("WScript.Shell")
objShell.CurrentDirectory = "c:\Programs\Mysql\Mysql server 5.0\bin"
Set filesys = CreateObject("Scripting.FileSystemObject")
path = filesys.GetAbsolutePathName("d:\Bdata\mysql\rel.sql")
Set objScriptExec = objShell.Exec("mysql -u apffal trl < " & path & "")

This ad is part of our Revenue Sharing program

« VBScript/ASP - Kicking off process question | How to pass multiple pameters? »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Free PHP/MYSQL, Tired of trying everywhere else	xxanime2xx	Hosting Forum	1	10-11-2008 11:58 AM
Free Web Hosting with PHP, MySQL and cPanel	akupunyer	Hosting Forum	1	10-11-2008 11:47 AM
How can I copy data from a html table?	bomba	JavaScript & AJAX Forum	0	02-08-2008 10:56 AM
Import of Recordset from CSV - Character problem	mbordeaux	ASP & VBScript Forum	0	12-04-2007 09:09 PM
Free PHP/MySQL hosting	swiftn4g	Hosting Forum	0	07-24-2007 10:28 PM

All times are GMT. The time now is 02:48 AM.