How to execute MySQL commands in file from the host to container running MySQL server using Powershell?

Question

These are similar but not exactly the same

How to execute MySQL command from the host to container running MySQL server?

How to execute mysqldump command from the host machine to a mysql docker container

This command works pretty in Git Bash even on Windows:

docker exec -i some_docker_container mysql -uroot -psome_password mydb<tables.sql

Same command on Powershell says:

ERROR 1049 (42000): Unknown database 'mydb<tables.sql'

How to pass tables.sql file as parameter? (it contains some create tables statements)

vonPryz · Accepted Answer · 2021-01-20 14:18:25Z

2

The command that works in Git Bash is using input redirection. That doesn't work in Powershell, as < is reserved for future use. Since Powershell doesn't parse < as redirection, it passes string literal mydb<tables.sql as the database name. Thus, the error message.

To execute the script file, use -e "source script.sql" for invoking mysql client in batch mode processing.

answered Jan 20, 2021 at 14:18

vonPryz

24.3k10 gold badges58 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to execute MySQL commands in file from the host to container running MySQL server using Powershell?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related