<div>
Below is the syntax to use:<br />
<br />
mysql --host=servernane --user=username --password=password database_name &lt;&nbsp;pathTofilename.sql<br />
i.e. mysql -host=jupiter.localdomain.<wbr />local -user=john.doe -password=IdontKnow salesDB &lt;&nbsp;myscript.sql
</div>


Below is the syntax to use:

mysql --host=servernane --user=username --password=password database_name < pathTofilename.sql
i.e. mysql -host=jupiter.localdomain.local -user=john.doe -password=IdontKnow salesDB < myscript.sql

<div>
You can access remote machines too?
</div>


<div>
yes assuming the user account is granted access from a specific machine or % for any machine; used with grant statement
</div>


yes assuming the user account is granted access from a specific machine or % for any machine; used with grant statement

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I'm running MySQL on Win7, and I cannot remember, how can I execute myscript.sql from cmd?<br />
<br />
Thank you
</div>
</div>


Hi Experts,

I'm running MySQL on Win7, and I cannot remember, how can I execute myscript.sql from cmd?

Thank you

Executing a .sql file with CMD

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.