blocks|key|2912366|text|如果使用的是MySQL命令行mysql>，则必须将SQL文件声明为source。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2912367|mysql>+source+\home\user\Desktop\test.sql;|code-block|syntax|javascript|2912368|entityMap^0|E|6|X|6|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

If you’re at the MySQL command line <code>mysql&gt;</code> you have to declare the SQL file as <code>source</code>.

<pre><code>mysql&gt; source \home\user\Desktop\test.sql;
</code></pre>

blocks|key|242834|text|你有相当多的选择：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|242835|242836|使用MySQL命令行客户端：mysql+-h+hostname+-u+user+database+<+path/to/test.sql|unordered-list-item|offset|length|style|CODE|242837|Install+MySQL图形用户界面工具并打开您的SQL文件，然后执行它|242838|使用phpmysql+(如果数据库可通过您的via服务器|242839|获得|242840|entityMap^0|0|0|E|1H|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|S|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|T|8|@$F|U|G|V|H|I]]|9|@]|A|$]]|$1|J|3|K|5|E|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|E|7|X|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Y|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|Q|$]]

You have quite a lot of options:

<ul>
<li>use the MySQL command line client: <code>mysql -h hostname -u user database &lt; path/to/test.sql</code></li>
<li>Install the MySQL GUI tools and open your SQL file, then execute it</li>
<li>Use phpmysql if the database is available via your webserver</li>
</ul>

blocks|key|2912383|text|您可以使用以下命令执行已写入文本文件中的mysql语句：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2912384|mysql+-u+yourusername+-p+yourpassword+yourdatabase+<+text_file|code-block|syntax|javascript|2912385|如果您的数据库尚未创建，请首先使用以下命令登录到mysql：|2912386|mysql+-u+yourusername+-p+yourpassword+yourdatabase|2912387|然后：|2912388|mysql>CREATE+DATABASE+a_new_database_name|2912389|2912390|mysql+-u+yourusername+-p+yourpassword+a_new_database_name+<+text_file|2912391|这应该就行了！|2912392|更多信息请点击此处：http://dev.mysql.com/doc/refman/5.0/en/mysql-batch-commands.html|offset|length|2912393|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/mysql-batch-commands.html^0|0|0|0|0|0|0|0|0|0|A|1S|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|16|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|17|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|18|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|19|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|1A|8|@]|9|@]|A|$E|F]]|$1|O|3|L|5|6|7|1B|8|@]|9|@]|A|$]]|$1|P|3|Q|5|D|7|1C|8|@]|9|@]|A|$E|F]]|$1|R|3|S|5|6|7|1D|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1E|8|@]|9|@$V|1F|W|1G|1|1H]]|A|$]]|$1|X|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|Y|$Z|$5|10|11|12|A|$13|14]]]]

you can execute mysql statements that have been written in a text file using the following command:

<pre><code>mysql -u yourusername -p yourpassword yourdatabase &lt; text_file
</code></pre>

if yourdatabase has not been created yet, log into your mysql first using:

<pre><code>mysql -u yourusername -p yourpassword yourdatabase
</code></pre>

then:

<pre><code>mysql&gt;CREATE DATABASE a_new_database_name
</code></pre>

then:

<pre><code>mysql -u yourusername -p yourpassword a_new_database_name &lt; text_file
</code></pre>

that should do it!

More info here: <a href="http://dev.mysql.com/doc/refman/5.0/en/mysql-batch-commands.html" rel="noreferrer">http://dev.mysql.com/doc/refman/5.0/en/mysql-batch-commands.html</a>

blocks|key|244354|text|我最喜欢的选择是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|244355|+mysql+--user="username"+--database="databasename"+--password="yourpassword"+<+"filepath"|code-block|syntax|javascript|244356|我这样使用它是因为当你用"“来串它的时候，你避免了错误的路径和空格的错误，可能还有更多我没有遇到的字符问题。|244357|244358|通过@elcuco注释，我建议在空格之前使用这个命令，这样它就会告诉bash忽略将其保存在历史中，这在大多数bash中都是有效的。|244359|如果您的命令仍然保存在历史中，请查看以下解决方案：|244360|Execute+command+without+keeping+it+in+history|offset|length|244361|244362|额外的安全性编辑|244363|为了安全起见，您可以使用以下命令，并在命令行输入中输入密码：|244364|mysql+--user="username"+--database="databasename"+-p+<+"filepath"|244365|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/8473121/execute-command-without-keeping-it-in-history^0|0|0|0|0|0|0|0|19|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|18|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1A|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1B|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1C|8|@]|9|@$P|1D|Q|1E|1|1F]]|A|$]]|$1|R|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1H|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1I|8|@]|9|@]|A|$]]|$1|W|3|X|5|D|7|1J|8|@]|9|@]|A|$E|F]]|$1|Y|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|Z|$10|$5|11|12|13|A|$14|15]]]]

My favorite option to do that will be:

<pre><code> mysql --user="username" --database="databasename" --password="yourpassword" &lt; "filepath"
</code></pre>

I use it this way because when you string it with "" you avoiding wrong path and mistakes with spaces and - and probably more problems with chars that I did not encounter with.

<hr>

With @elcuco comment I suggest using this command with [space] before so it tell bash to ignore saving it in history, this will work out of the box in most bash.

in case it still saving your command in history please view the following solutions:

<a href="https://stackoverflow.com/questions/8473121/execute-command-without-keeping-it-in-history">Execute command without keeping it in history</a>

<hr>

extra security edit

Just in case you want to be extra safe you can use the following command and enter the password in the command line input:

<pre><code>mysql --user="username" --database="databasename" -p &lt; "filepath"
</code></pre>

blocks|key|241744|text|所有排名靠前的答案都很好。但是，如果有人想要从远程服务器上的文本文件运行查询，并且将结果保存到一个文件(而不是在控制台上显示)，您可以这样做：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|241745|mysql+-u+yourusername+-p+yourpassword+yourdatabase+<+query_file+>+results_file|code-block|syntax|javascript|241746|希望这对某些人有帮助。|241747|entityMap^0|15|U|0|0|0|B|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|N|$]]

All the top answers are good. But just in case someone wants to run the query from a text file on a remote server AND save results to a file (instead of showing on console), you can do this:

<pre><code>mysql -u yourusername -p yourpassword yourdatabase &lt; query_file &gt; results_file
</code></pre>

Hope this helps someone.

blocks|key|3127033|text|将.sql文件的路径指定为：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3127034|source+c:/dump/SQL/file_name.sql;|code-block|syntax|javascript|3127035|​|3127036|📷|atomic|3127037|3127038|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/de510c0396cfb2f81d8430e63ff7e6fb.png|imageAlt^0|0|E|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|12|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|13|8|@]|D|@]|E|$]]|$1|M|3|N|5|O|7|14|8|@]|D|@$9|15|A|16|1|17]]|E|$]]|$1|P|3|L|5|6|7|18|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|19|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|X|Y|-4]]]]

Give the path of .sql file as:

<pre><code>source c:/dump/SQL/file_name.sql;
</code></pre>

<img src="https://i.stack.imgur.com/UBCCy.png" alt="See In The Image:">

blocks|key|2912783|text|我来这里也是为了寻找这个答案，我发现最适合我的是:注意，我使用的是Ubuntu16.x.x|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2912784|2912785|Access+mysql使用：|ordered-list-item|2912786|2912787|mysql+-u+<your_user>+-+p|offset|length|style|CODE|2912788|2912789|在mysql提示符下，输入：|2912790|2912791|source+file_name.sql|2912792|希望这能有所帮助。|2912793|entityMap^0|0|0|0|0|0|O|0|0|0|0|0|K|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|X|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|Y|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|10|8|@$I|11|J|12|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|N|3|O|5|E|7|14|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|16|8|@$I|17|J|18|K|L]]|9|@]|A|$]]|$1|S|3|T|5|6|7|19|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|V|$]]

I came here searching for this answer as well, and here is what I found works the best for me: Note I am using Ubuntu 16.x.x

<ol>
<li>Access mysql using:</li>
</ol>

<code>mysql -u &lt;your_user&gt; - p</code> 

<ol start="2">
<li>At the mysql prompt, enter:</li>
</ol>

<code>source file_name.sql</code>

Hope this helps.

blocks|key|239402|text|mysql>+source+C:\Users\admin\Desktop\fn_Split.sql|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|239403|不要指定单引号。|unstyled|239404|如果上述命令不起作用，请将文件复制到c:+drive，然后重试。如下所示：|239405|mysql>+source+C:\fn_Split.sql|239406|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$B|C]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>mysql&gt; source C:\Users\admin\Desktop\fn_Split.sql
</code></pre>

Do not specify single quotes.

If the above command is not working, copy the file to c: drive and try again.
as shown below,

<pre><code>mysql&gt; source C:\fn_Split.sql
</code></pre>

blocks|key|3127056|text|我将执行以下操作，而不是重定向|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3127057|mysql+-h+<hostname>+-u+<username>+--password=<password>+-D+<database>+-e+'source+<path-to-sql-file>'|code-block|syntax|javascript|3127058|这将执行文件path-to-sql-file|3127059|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

instead of redirection I would do the following

<pre><code>mysql -h &lt;hostname&gt; -u &lt;username&gt; --password=&lt;password&gt; -D &lt;database&gt; -e 'source &lt;path-to-sql-file&gt;'
</code></pre>

This will execute the file path-to-sql-file

blocks|key|244506|text|从命令行直接传递密码参数永远不是一种好的做法，它保存在~/.bash_history文件中，并且可以从其他应用程序访问。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|244507|改用下面的代码：|244508|mysql+-u+user+--host+host+--port+9999+database_name+<+/scripts/script.sql+-p
Enter+password:|code-block|syntax|javascript|244509|entityMap^0|R|F|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

Never is a good practice to pass the password argument directly from the command line, it is saved in the <code>~/.bash_history</code> file and can be accessible from other applications.

Use this instead:

<pre><code>mysql -u user --host host --port 9999 database_name &lt; /scripts/script.sql -p
Enter password:
</code></pre>

blocks|key|3127050|text|mysql+-uusername+-ppassword+database-name+<+file.sql|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3127051|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>mysql -uusername -ppassword database-name &lt; file.sql
</code></pre>

blocks|key|2912855|text|有很多方法可以做到这一点。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2912856|From+Workbench:+File+>+Run+SQL+Script+--+then+follow+prompts

From+Windows+Command+Line:
+++Option+1:+mysql+-u+usr+-p
+++++++++++++mysql>+source+file_path.sql
+++Option+2:+mysql+-u+usr+-p+'-e+source+file_path.sql'
+++Option+3:+mysql+-u+usr+-p+<+file_path.sql
+++Option+4:+put+multiple+'source'+statements+inside+of+file_path.sql+(I+do+this+to+drop+and+recreate+schemas/databases+which+requires+multiple+files+to+be+run)
+++++++++++++mysql+-u+usr+-p+<+file_path.sql|code-block|syntax|javascript|2912857|如果从命令行获得错误，请确保您以前运行过|2912858|cd+{!!>>mysqld.exe+home+directory+here<<!!}
mysqld.exe+--initialize+|2912859|这必须从mysqld.exe目录中运行，因此是CD目录。|2912860|希望这是有帮助的，而不是多余的。|2912861|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

So many ways to do it.

<pre><code>From Workbench: File &gt; Run SQL Script -- then follow prompts

From Windows Command Line:
 Option 1: mysql -u usr -p
 mysql&gt; source file_path.sql
 Option 2: mysql -u usr -p '-e source file_path.sql'
 Option 3: mysql -u usr -p &lt; file_path.sql
 Option 4: put multiple 'source' statements inside of file_path.sql (I do this to drop and recreate schemas/databases which requires multiple files to be run)
 mysql -u usr -p &lt; file_path.sql
</code></pre>

If you get errors from the command line, make sure you have previously run 

<pre><code>cd {!!&gt;&gt;mysqld.exe home directory here&lt;&lt;!!}
mysqld.exe --initialize 
</code></pre>

This must be run from within the mysqld.exe directory, hence the CD.

Hope this is helpful and not just redundant.

blocks|key|2912404|text|很可能，您只需要更改斜杠/黑斜杠:+from|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2912405|+\home\sivakumar\Desktop\test.sql|code-block|syntax|javascript|2912406|至|2912407|+/home/sivakumar/Desktop/test.sql|2912408|所以命令应该是：|2912409|source+/home/sivakumar/Desktop/test.sql|2912410|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Very likely, you just need to change the slash/blackslash:
from

<pre><code> \home\sivakumar\Desktop\test.sql
</code></pre>

to

<pre><code> /home/sivakumar/Desktop/test.sql
</code></pre>

So the command would be:

<pre><code>source /home/sivakumar/Desktop/test.sql
</code></pre>

blocks|key|2912866|text|从Linux14.04到MySQL5.7，使用cat命令和MySql登录：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2912867|cat+/Desktop/test.sql+%7C+sudo+mysql+-uroot+-p+|code-block|syntax|javascript|2912868|您可以将此方法用于许多直接从外壳程序执行的MySQL命令。例如：|2912869|echo+"USE+my_db;+SHOW+tables;"+%7C+sudo+mysql+-uroot+-p+|2912870|请确保使用分号(';')分隔命令。|2912871|我在上面的答案中没有看到这种方法，我认为这是一个很好的贡献。|2912872|entityMap^0|N|3|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|10|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|11|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|T|$]]

From linux 14.04 to MySql 5.7, using <code>cat</code> command piped with mysql login:
<pre><code>cat /Desktop/test.sql | sudo mysql -uroot -p 
</code></pre>
You can use this method for many MySQL commands to execute directly from Shell. Eg:
<pre><code>echo &quot;USE my_db; SHOW tables;&quot; | sudo mysql -uroot -p 
</code></pre>
Make sure you separate your commands with semicolon (';').
I didn't see this approach in the answers above and thought it is a good contribution.

blocks|key|2912422|text|在命令提示符中使用以下命令-|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2912423|source+\\home\\user\\Desktop\\test.sql;|code-block|syntax|javascript|2912424|不使用引号。即使路径包含空格(‘’)，也要使用，完全不要用引号。|2912425|entityMap^0|1|5|0|0|A|9|N|8|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|X|8|@]|D|@]|E|$]]]|N|$]]

use the following from mysql command prompt-

<pre><code>source \\home\\user\\Desktop\\test.sql;
</code></pre>

Use no quotation. Even if the path contains space(' ') use no quotation at all.

blocks|key|3126668|text|由于mysql+-u+yourusername+-p+yourpassword+yourdatabase+<+text_file不能在远程服务器(亚马逊的EC2)上运行...|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3126669|确保首先创建数据库。|3126670|然后：|3126671|mysql+--host=localhost+--user=your_username+--password=your_password+your_database_name+<+pathTofilename.sql|code-block|syntax|javascript|3126672|entityMap^0|2|1Q|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|U|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|V|8|@]|D|@]|E|$M|N]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

Since <code>mysql -u yourusername -p yourpassword yourdatabase &lt; text_file</code> did not work on a remote server (Amazon's EC2)...

Make sure that the Database is created first.

Then:

<pre><code>mysql --host=localhost --user=your_username --password=your_password your_database_name &lt; pathTofilename.sql
</code></pre>

blocks|key|2912749|text|作为将来的参考，我发现在你的msql控制台中的Windows下，这个方法与上述方法相比是有效的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2912750|mysql>>source+c://path_to_file//path_to_file//file_name.sql;|offset|length|style|CODE|2912751|如果你的根驱动器没有被称为"c“，那么只需与你的驱动器互换。首先尝试反斜杠，如果它们不起作用，尝试正斜杠。如果它们也不起作用，请确保您有完整的文件路径和文件名上的.sql扩展名，如果您的版本坚持使用分号，请确保它在那里，然后重试。|2912752|entityMap^0|0|7|1H|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

For future reference, I've found this to work vs the aforementioned methods, under Windows in your msql console:

mysql>><code>source c://path_to_file//path_to_file//file_name.sql;</code>

If your root drive isn't called "c" then just interchange with what your drive is called. First try backslashes, if they dont work, try the forward slash. If they also don't work, ensure you have your full file path, the .sql extension on the file name, and if your version insists on semi-colons, ensure it's there and try again.

blocks|key|2912772|text|我犯了这个错误，并尝试了所有我能得到的建议，但都没有用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2912773|最后，问题是我的文件夹在文件夹名称中有一个空格，在文件夹路径中显示为一个正斜杠，一旦我找到并删除它，它就工作得很好。|2912774|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I had this error, and tried all the advice i could get to no avail.

Finally, the problem was that my folder had a space in the folder name which appearing as a forward-slash in the folder path, once i found and removed it, it worked fine.

blocks|key|2912885|text|我使用Bash的Here字符串来执行即时SQL：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2912886|mysql+-uroot+-p+<<<"select+date(now())"|code-block|syntax|javascript|2912887|https://www.gnu.org/software/bash/manual/html_node/Redirections.html#Here-Strings|offset|length|2912888|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|29|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|T|8|@]|9|@$I|U|J|V|1|W]]|A|$]]|$1|K|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|H]]]]

I use Bash's Here Strings for an instant SQL execution:
<pre><code>mysql -uroot -p &lt;&lt;&lt;&quot;select date(now())&quot;
</code></pre>
<a href="https://www.gnu.org/software/bash/manual/html_node/Redirections.html#Here-Strings" rel="nofollow noreferrer">https://www.gnu.org/software/bash/manual/html_node/Redirections.html#Here-Strings</a>

I want to execute a text file containing SQL queries, in MySQL.

I tried to run <code>source /Desktop/test.sql</code> and received the error: 

<blockquote>
 mysql> . \home\sivakumar\Desktop\test.sql ERROR: Failed to open file
 '\home\sivakumar\Desktop\test.sql', error: 2
</blockquote>

Any idea on what I am doing wrong?

How to run SQL script in MySQL?

数据库

服务器

Windows

MySQL

我想在MySQL中执行一个包含SQL查询的文本文件。我尝试运行source /Desktop/test.sql，但收到以下错误： mysql> .\home\sivakumar\Desktop\test.sql错误:无法打开文件'\home\sivakumar\Desktop\test.sql'，错误:2你知道我做错了什么吗？

问如何在MySQL中运行SQL脚本？
EN

回答 19

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在MySQL中运行SQL脚本？EN

回答 19

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在MySQL中运行SQL脚本？
EN