Execute mysql dump using power shell

Question

I am setting up a new Azure database using mysql server with a database. I want to dump a .sql file to this database using powershell

Executing the below code throws exception in '<', since it is reserved for future use, as a workaround I tired putting the entire statement in quotes.Still facing same issue.

$path = "C:\tools\mysql\current\bin\mysql.exe" &"$path" -h $servername -u $username -p $databasename < filename.sql

The expected result is to dump the filename.sql into mysql server database.

Possible duplicate stackoverflow.com/questions/40173988/… stackoverflow.com/questions/46937146/… — root
– root, Commented Mar 29, 2019 at 13:54
The above link doesn't explain about importing. I am specifically looking for importing mysql. — kottis
– kottis, Commented Mar 31, 2019 at 14:49

Mohit Verma · Accepted Answer · 2019-04-25 06:08:41Z

0

Try something like this and see if it helps:

Use Get-Content to read the file and pipe | it to your command. Use & to run the command.

get-content 'c:\folder\backup.sql' | &"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe" -u user --password=pass dbnamedbname

answered Apr 25, 2019 at 6:08

Mohit Verma

5,3002 gold badges14 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Execute mysql dump using power shell

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