Batch Load text files to MySQL

[Piglette]

Hello Hans:

I have a process that I need to run once a week. Loading many pipe-delimited text files to preexisting MySQL tables. Windows 7

Is there a batch way of doing this using VBS (for example)?

Thanks

Lukas van der Walde

[HansV]

I have no experience with MySQL. Perhaps Import data from txt file or excel to Mysql vbscript will give you some ideas. You'll have to adapt the code of course.

[Piglette]

Hans:

Thanks very much! That looks promising.

Lukas

[Jezza]

Hello Hans:

I have a process that I need to run once a week. Loading many pipe-delimited text files to preexisting MySQL tables. Windows 7

Is there a batch way of doing this using VBS (for example)?

Thanks

Lukas van der Walde

Hi Lukas, this is very possible and must assume you have the correct permissions on the Windows 7 machine and the correct account that has insert permissions on the My SQL database. The small issue you will have is the batch file will show the username and password as clear text in its content: Use it like this

Code: Select all

set database_name=db_name
mysql –u root --password=pass --database %database_name% < c:/myInsertFile/sql_insert.sql

I hope that helps