/inputfile does not like path

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
dpboyer
Posts: 4
Joined: Thu 21 Mar 2019 15:41

/inputfile does not like path

Post by dpboyer » Thu 21 Mar 2019 15:49

I'm trying to execute a sql file from a batch file... if I give it: /fileinput "D:\file.sql" it errors saying the fileinput is not correct, but if I first cd into the directory and just use /fileinput "file.sql" it works fine... how do I get it to allow a path as part of the file name?

alexa

Re: /inputfile does not like path

Post by alexa » Thu 21 Mar 2019 18:37

We were not able to reproduce this issue on the latest version 8.1 https://www.devart.com/dbforge/mysql/st ... nload.html

Could you please let us know what product version you are using?

dpboyer
Posts: 4
Joined: Thu 21 Mar 2019 15:41

Re: /inputfile does not like path

Post by dpboyer » Thu 21 Mar 2019 18:52

Version 8.1.22

So this works:
>D:
>cd\
>CALL %DBFORGE% /execute /connection:"User Id=%DB_USER%;Password=%DB_PWD%;Host=%HOST%;Port=3320;Database=%DB%;Character Set=utf8" /inputfile "ImportDBCSV.sql"

But this does not:
>CALL %DBFORGE% /execute /connection:"User Id=%DB_USER%;Password=%DB_PWD%;Host=%HOST%;Port=3320;Database=%DB%;Character Set=utf8" /inputfile "D:\ImportDBCSV.sql"

it throws:
=======================================================================================================================
Devart dbForge Studio 2019 for MySQL version 8.1.22.0
Copyright 2019 Devart. All rights reserved.
=======================================================================================================================

Invalid command line. The switch '/inputfile' has not been set or has been set incorrectly.

alexa

Re: /inputfile does not like path

Post by alexa » Fri 22 Mar 2019 15:15

Please use the following command:

Code: Select all

/inputfile:"D:\ImportDBCSV.sql"

dpboyer
Posts: 4
Joined: Thu 21 Mar 2019 15:41

Re: /inputfile does not like path

Post by dpboyer » Fri 22 Mar 2019 16:40

That worked. Thank you

Post Reply