How to execute an remote .sql in mysql command line

Question

I have a file located at `E:\Backup\sql\mybackup.sql` I'm logging into command line and I'm at the command prompt `mysql>` How would I restore the database mydatabase? I thought it was ``` mydatabase > "E:\Backup\sql\mybackup.sql" ``` but it keeps saying unknown command at each `\`

Accepted Answer

Run it like:

```
mysql -h localhost -u root -p mydatabase < "E:/Backup/sql/mybackup.sql"
```

How to execute an remote .sql in mysql command line

Solution

Problem