| View previous topic :: View next topic |
| Author |
Message |
jamesbowers
-
Joined: 26 Apr 2019
Posts: 1
|
 Posted: Fri May 24, 2019 11:17 am Post subject: Can somebody please help me? |
 |
|
On an old server we had, it was running Server version: 5.5.58 - MySQL Community Server (GPL)
Now our new server runsServer version: 8.0.15 - MySQL Community Server - GPL.
We have a system that once an engineer has completed a form it send it back to the server as a CSV file. Then we have a vbs file that runs and imports the CSV into the database. Now this worked fine on the old server, but I cant get it to work on the new server.
I am a bit limited on what to look for, such as error details, but bsiaclayy the line to import is this
Dim cmd
cmd = "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqlimport --local --user=root --password=May2019 new_db_2005 --fields-optionally-enclosed-by=\"" --fields-terminated-by=, --ignore-lines=1 --columns=" & colLine & " --verbose " & fileName
Can anybody give me a wild guess why this has now stopped working on a newer version? |
|
| Back to top |
  |
 |
admin
Site Admin
Joined: 03 Mar 2002
Posts: 1348
|
| Posted: Mon May 27, 2019 3:12 pm Post subject: Re: Can somebody please help me? |
|
|
| jamesbowers wrote: |
cmd = "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqlimport --local --user=root --password=May2019 new_db_2005 --fields-optionally-enclosed-by=\"" --fields-terminated-by=, --ignore-lines=1 --columns=" & colLine & " --verbose " & fileName |
Try building the command and typing it directly in a Windows command line window. This will help you see what this command generates as errors.
_________________
Follow @abyssws on Twitter
Subscribe to our newsletter
_________________
Forum Administrator
Aprelium - https://aprelium.com |
|
| Back to top |
|
|
jasonbond
-
Joined: 18 Mar 2021
Posts: 1
Location: Australia
|
| Posted: Sun Apr 18, 2021 11:28 am Post subject: Re: Can somebody please help me? |
|
|
| admin wrote: | | jamesbowers wrote: |
cmd = "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqlimport --local --user=root --password=May2019 new_db_2005 --fields-optionally-enclosed-by=\"" --fields-terminated-by=, --ignore-lines=1 --columns=" & colLine & " --verbose " & fileName |
Try building the command and typing it directly in a Windows command line window. This will help you see what this command generates as errors. |
Thanks for sharing. I had the same problem and now get fixed. |
|
| Back to top |
|
|
|
