/inputfile does not like path
/inputfile does not like path
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?
Re: /inputfile does not like path
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?
Could you please let us know what product version you are using?
Re: /inputfile does not like path
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.
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.
Re: /inputfile does not like path
Please use the following command:
Code: Select all
/inputfile:"D:\ImportDBCSV.sql"
Re: /inputfile does not like path
That worked. Thank you