When loading a database schema into MySQL on platforms such as Linux & Windows, the usual format is to redirect a SQL text file to the MySQL interpreter as follows,
mysql -u username -p database < file.sql
at which point it challenges the user for their password, and if correct the SQL file is processed.
On VMS, the limitations of the piping mechanism mean that this fails. However the following *does* work,
$ mysql -u username -p -e "source file.sql" database
Discussions around the use of MySQL on VMS
1 post • Page 1 of 1