blocks|key|5352421|text|对于那些使用Windows的用户，我能够在cmd.exe中使用以下命令将一个大的mysqldump文件导入到我的本地XAMPP安装中|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5352422|C:\xampp\mysql\bin>mysql+-u+{DB_USER}+-p+{DB_NAME}+<+path/to/file/ab.sql|code-block|syntax|javascript|5352423|另外，我刚刚写了一个关于MySQL导入的问题的more+detailed+answer，如果这就是你想要的。|5352424|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/5186675/restoring-a-mysql-database/6300591#6300591^0|L|7|0|0|N|K|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|@$9|Z|A|10|1|11]]|E|$]]|$1|M|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

For those using a Windows OS, I was able to import a large mysqldump file into my local XAMPP installation using this command in <code>cmd.exe</code>:

<pre><code>C:\xampp\mysql\bin&gt;mysql -u {DB_USER} -p {DB_NAME} &lt; path/to/file/ab.sql
</code></pre>

Also, I just wrote a <a href="https://stackoverflow.com/questions/5186675/restoring-a-mysql-database/6300591#6300591">more detailed answer</a> to another question on MySQL imports, if this is what you're after.

blocks|key|1534573|text|转到xampp+shell命令行并运行|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1534574|mysql+-h+localhost+-u+username+databasename+<+dump.sql|code-block|syntax|javascript|1534575|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Go to the xampp shell command line 
and run

<pre><code>mysql -h localhost -u username databasename &lt; dump.sql
</code></pre>

blocks|key|1824755|text|您可能还需要指定主机。从您的声明看，您似乎是在Windows上运行的。试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1824756|mysql+-h+localhost+-u+#myusername+-p+#mypasswd+MYBASE
++++++<+c:/user/folderss/myscript.sql|code-block|syntax|javascript|1824757|或|1824758|mysql+-h+localhost+-u+#myusername+-p+#mypasswd+MYBASE
+++++++<+"c:\user\folderss\myscript.sql"|1824759|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You may also need to specify the host. From your statement, it looks like you run on Windows. Try this:

<pre><code>mysql -h localhost -u #myusername -p #mypasswd MYBASE
 &lt; c:/user/folderss/myscript.sql
</code></pre>

Or

<pre><code>mysql -h localhost -u #myusername -p #mypasswd MYBASE
 &lt; "c:\user\folderss\myscript.sql"
</code></pre>

blocks|key|3935127|text|mysql+-h+localhost+-u+username+databasename+<+dump.sql|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3935128|很有效，试试吧。如果密码为空，则无需添加-p参数。|unstyled|offset|length|style|CODE|3935129|entityMap^0|0|K|2|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@$G|O|H|P|I|J]]|9|@]|A|$]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>mysql -h localhost -u username databasename &lt; dump.sql
</code></pre>

It works, try it.
If password is blank no need to add the <code>-p</code> args.

blocks|key|5352658|text|将数据库转储文件复制到(Windows+PC)+D:\xampp\mysql\bin|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5352659|mysql+-h+localhost+-u+root+Databasename+<@data11.sql|code-block|syntax|javascript|5352660|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Copy Database Dump File at (Windows PC)
D:\xampp\mysql\bin

<pre><code>mysql -h localhost -u root Databasename &lt;@data11.sql
</code></pre>

blocks|key|5352682|text|这条由Daniel发布的命令非常有效|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5352683|C:\xampp\mysql\bin>mysql+-u+{DB_USER}+-p+{DB_NAME}+<+path/to/file/ab.sql|code-block|syntax|javascript|5352684|只需将db用户名和db名称放入，而不包括这些backets|5352685|**注意:请确保您的数据库文件位于htdocs文件夹中，否则将收到拒绝访问错误|5352686|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

this command posted by Daniel works like charm

<pre><code>C:\xampp\mysql\bin&gt;mysql -u {DB_USER} -p {DB_NAME} &lt; path/to/file/ab.sql
</code></pre>

just put the db username and db name without those backets

**NOTE: Make sure your database file is reside inside the htdocs folder, else u'll get an Access denied error

blocks|key|1530497|text|它是有效的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1530498|mysql+-u+root+-p+db_name+<+"C:\folder_name\db_name.sql"|code-block|syntax|javascript|1530499|以C:\为例|offset|length|style|CODE|1530500|entityMap^0|0|0|1|3|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

It works:

<pre><code>mysql -u root -p db_name &lt; "C:\folder_name\db_name.sql"
</code></pre>

<code>C:\</code> is for example

blocks|key|1530381|text|毫无疑问，它做到了这一点：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1530382|C:\xampp\mysql\bin>mysql+-u+{DB_USER}+-p+{DB_NAME}+<+path/to/file/ab.sql|code-block|syntax|javascript|1530383|但是有时你可能会发现"MySql服务器已经走了一条路“，因此你需要改变mysql/bin/my.ini+max_allowed_packet+=+64M+to+my.ini|offset|length|style|BOLD|CODE|1530384|entityMap^0|0|0|Z|G|1G|Y|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Q|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|R|8|@$I|S|J|T|K|L]|$I|U|J|V|K|M]]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

No Doubt It does the trick:

<pre><code>C:\xampp\mysql\bin&gt;mysql -u {DB_USER} -p {DB_NAME} &lt; path/to/file/ab.sql
</code></pre>

But some time you many find "MySql Server has Gone a way" 
For that you need to change mysql/bin/my.ini <code>max_allowed_packet = 64M to my.ini</code>

blocks|key|1530463|text|/opt/lampp/bin/./mysql+-u数据库名-p数据库名<+sqlfilepath.sql|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1530464|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

/opt/lampp/bin/./mysql -u dbusername -p dbname &lt; sqlfilepath.sql

blocks|key|1824943|text|我认为命令是可以的，问题是空格。请注意-u和#myusername之间以及-p和#mypasswd之间的空格。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1824944|mysql+-u+#myusername+-p+#mypasswd+MYBASE+<+c:\user\folderss\myscript.sql|code-block|syntax|javascript|1824945|也可以写成：|1824946|mysql+-u#myusername+-p#mypasswd+MYBASE+<+c:\user\folderss\myscript.sql|1824947|而且，你不需要添加-p和命令时间，如果你的密码是空的，它不会问你密码。如果你有数据库的密码，它会要求你输入密码。|1824948|谢谢|1824949|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|$]]

I think the commands are OK, issue is with the spaces.
Please observe the spaces between -u and #myusername also between -p and #mypasswd.

<pre><code>mysql -u #myusername -p #mypasswd MYBASE &lt; c:\user\folderss\myscript.sql
</code></pre>

Can also be written as:

<pre><code>mysql -u#myusername -p#mypasswd MYBASE &lt; c:\user\folderss\myscript.sql
</code></pre>

Also, you need not add -p and the time of command, if your password is blank, it will not ask you for the password.
If you have password to your database, it will ask for the password.

Thanks

blocks|key|3935189|text|过程很简单-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3935190|3935191|将数据库移动到所需的文件夹，例如/xampp/mysql文件夹。|ordered-list-item|3935192|打开cmd并导航到上面的位置，然后使用命令导入db+-+"mysql+-u+|3935193|+dbpassword+newDbName+|3935194|3935195|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|N|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|P|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|Q|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|L|$]]

The process is simple- 

<ol>
<li>Move the database to the desired folder e.g. /xampp/mysql folder. </li>
<li>Open cmd and navigate to the above location</li>
<li>Use command to import the db - "mysql -u root -p dbpassword newDbName &lt; dbtoimport.sql"</li>
<li>Check for the tables for verification.</li>
</ol>

blocks|key|1825342|text|在Windows中，将MySQL文件(即example.sql)放在C:\xampp\mysql\bin中。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1825343|打开XAMPP控制面板，然后启动Shell：|1825344|cd+c:\xampp\mysql\bin
mysql+--default-character-set=utf8+-h+localhost+-u+username+databasename+<+example.sql|code-block|syntax|javascript|1825345|1825346|+注意:如果您打算使用-8，使用--default-character-set=utf8可以帮助防止特殊字符的编码问题。|blockquote|BOLD|1825347|1825348|1825349|然后，从C:\xampp\mysql\bin中删除MySQL文件。|1825350|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html#option_mysql_default-character-set^0|K|B|Y|I|0|0|0|0|1|A|G|S|G|S|0|0|0|0|4|I|0^^$0|@$1|2|3|4|5|6|7|13|8|@$9|14|A|15|B|C]|$9|16|A|17|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|18|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|19|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]|$1|N|3|O|5|P|7|1B|8|@$9|1C|A|1D|B|Q]|$9|1E|A|1F|B|C]]|D|@$9|1G|A|1H|1|1I]]|E|$]]|$1|R|3|-4|5|6|7|1J|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|1K|8|@]|D|@]|E|$]]|$1|T|3|U|5|6|7|1L|8|@$9|1M|A|1N|B|C]]|D|@]|E|$]]|$1|V|3|-4|5|6|7|1O|8|@]|D|@]|E|$]]]|W|$X|$5|Y|Z|10|E|$11|12]]]]

In Windows, place the MySQL file (i.e. <code>example.sql</code>) in <code>C:\xampp\mysql\bin</code>.

Open the XAMPP Control Panel, and launch Shell:

<pre><code>cd c:\xampp\mysql\bin
mysql --default-character-set=utf8 -h localhost -u username databasename &lt; example.sql
</code></pre>

<blockquote>
 Note: Using <a href="https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html#option_mysql_default-character-set" rel="nofollow noreferrer"><code>--default-character-set=utf8</code></a> can help to prevent encoding issues with special characters if you intend on working with UTF-8.
</blockquote>

Afterwards, remove the MySQL file from <code>C:\xampp\mysql\bin</code>.

blocks|key|5352380|text|在受控步骤中进行故障排除：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5352381|(1)脚本看起来正常吗？|5352382|DOS+E:\trials\SoTrials\SoDbTrials\MySQLScripts
type+ansi.sql
show+databases|code-block|syntax|javascript|5352383|(2)是否可以连接到数据库(即使没有指定主机)？|5352384|DOS+E:\trials\SoTrials\SoDbTrials\MySQLScripts
mysql+-u+root+-p+mysql
Enter+password:+********
Welcome+to+the+MySQL+monitor.++Commands+end+with+;+or+\g.
Your+MySQL+connection+id+is+9
Server+version:+5.0.51b-community-nt+MySQL+Community+Edition+(GPL)
Type+'help;'+or+'\h'+for+help.+Type+'\c'+to+clear+the+buffer.|5352385|(3)你能找到脚本的来源吗？(希望获得更多/更好的错误信息)|5352386|mysql>+source+ansi.sql
%2B--------------------%2B
%7C+Database+++++++++++%7C
%2B--------------------%2B
%7C+information_schema+%7C
%7C+...++++++++++++++++%7C
%7C+test+++++++++++++++%7C
%2B--------------------%2B
7+rows+in+set+(0.01+sec)
mysql>+quit
Bye|5352387|(4)为什么它(仍然不能)工作？|5352388|DOS+E:\trials\SoTrials\SoDbTrials\MySQLScripts
mysql+-u+root+-p+mysql+<+ansi.sql
Enter+password:+********
Database
information_schema
...
test|5352389|我怀疑脚本的编码可能是罪魁祸首，但我得到了UTF8或UTF16编码文件的语法错误：|5352390|ERROR+1064+(42000)+at+line+1:+You+have+an+error+in+your+SQL+syntax;+check+the+manual+that+corresponds+to+your
MySQL+server+version+for+the+right+syntax+to+use+near+'´╗┐
show+databases'+at+line+1|5352391|这可能是一个版本问题；所以我认为你应该确保你的脚本的编码。|5352392|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|14|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|15|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|16|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|17|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|18|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|19|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|1A|8|@]|9|@]|A|$G|H]]|$1|U|3|V|5|6|7|1B|8|@]|9|@]|A|$]]|$1|W|3|X|5|F|7|1C|8|@]|9|@]|A|$G|H]]|$1|Y|3|Z|5|6|7|1D|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|11|$]]

Do your trouble shooting in controlled steps:

(1) Does the script looks ok? 

<pre><code>DOS E:\trials\SoTrials\SoDbTrials\MySQLScripts
type ansi.sql
show databases
</code></pre>

(2) Can you connect to your database (even without specified the host)?

<pre><code>DOS E:\trials\SoTrials\SoDbTrials\MySQLScripts
mysql -u root -p mysql
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.51b-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
</code></pre>

(3) Can you source the script? (Hoping for more/better error info)

<pre><code>mysql&gt; source ansi.sql
+--------------------+
| Database |
+--------------------+
| information_schema |
| ... |
| test |
+--------------------+
7 rows in set (0.01 sec)
mysql&gt; quit
Bye
</code></pre>

(4) Why does it (still not) work?

<pre><code>DOS E:\trials\SoTrials\SoDbTrials\MySQLScripts
mysql -u root -p mysql &lt; ansi.sql
Enter password: ********
Database
information_schema
...
test
</code></pre>

I suspected that the encoding of the script could be the culprit, but I got syntax errors for UTF8 or UTF16 encoded files:

<pre><code>ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '´╗┐
show databases' at line 1
</code></pre>

This could be a version thing; so I think you should make sure of the encoding of your script.

blocks|key|5352617|text|我认为行动的问题不是逃脱了斜杠。在windows中，像："c:\user\folderss\myscript.sql"这样的路径在命令行中应该写成：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5352618|+c:\\\user\\\folders\\\myscript.sql|code-block|syntax|javascript|5352619|或者：|5352620|c:/user/folders/myscript.sql|5352621|因此，来自"c:\user"的"\u"被解释为命令。|5352622|有关详细信息，请参阅：http://dev.mysql.com/doc/refman/5.5/en/mysql-commands.html|5352623|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.5/en/mysql-commands.html^0|S|V|0|0|0|0|5|9|F|4|0|B|1M|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|13|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|14|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|15|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|16|8|@$9|17|A|18|B|C]|$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1B|8|@]|D|@$9|1C|A|1D|1|1E]]|E|$]]|$1|S|3|-4|5|6|7|1F|8|@]|D|@]|E|$]]]|T|$U|$5|V|W|X|E|$Y|Z]]]]

I think the OP's problem was not escaping the slashes. 
on windows a path like: <code>"c:\user\folderss\myscript.sql"</code> should in the command line be written like either: 

<pre><code> c:\\\user\\\folders\\\myscript.sql
</code></pre>

or: 

<pre><code>c:/user/folders/myscript.sql
</code></pre>

therefore <code>"\u"</code> from <code>"c:\user"</code> was interpreted as a command.

see: <a href="http://dev.mysql.com/doc/refman/5.5/en/mysql-commands.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.5/en/mysql-commands.html</a> for more info

blocks|key|1534720|text|这是我尝试从xampp服务器的cmd导入数据库，正确的命令对我来说是这样的，你可以用你的requirements.and改变它，我还附加了一些错误，我第一次从命令line.you导入数据库时，可以看到我使用的最后一个命令，我将它粘贴在这里，它对我也有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1534721|mysql+-h+localhost+-u+root+ovxsolut_windhs+<+C:\Users\eee\Downloads\ovxsolut_windhs.sql|code-block|syntax|javascript|1534722|​|1534723|📷|atomic|offset|length|1534724|1534725|1534726|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/816892f96ae5f1d5d10cc36b25227afd.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/72cd55e808126a2ddea2d379fb77bb30.png^0|0|0|0|0|1|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|13|8|@]|9|@$L|14|M|15|1|16]]|A|$]]|$1|N|3|J|5|K|7|17|8|@]|9|@$L|18|M|19|1|1A]]|A|$]]|$1|O|3|H|5|6|7|1B|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|W|X|-4]]|Y|$5|S|T|U|A|$V|Z|X|-4]]]]

here is my try to import database from cmd in xampp server 
the correct command for me is this you can change it with your requirements.and i also attached Errors that i face first time importing db from command line.you can see last command that i use and i paste it here also its working fro me.

<pre><code>mysql -h localhost -u root ovxsolut_windhs &lt; C:\Users\eee\Downloads\ovxsolut_windhs.sql
</code></pre>

<a href="https://i.stack.imgur.com/t0q01.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/t0q01.png" alt="d"></a>
<a href="https://i.stack.imgur.com/RSnQV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RSnQV.png" alt="enter image description here"></a>

blocks|key|1530525|text|C:\xampp\mysql\bin>mysql文件{DB_USER}文件{DB_NAME}+<路径/到/文件/文件名.sql|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1530526|mysql+-u根-p+dbname<+"C:\Users\sdkca\Desktop\mydb.sql“|1530527|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|$]]

C:\xampp\mysql\bin&gt;mysql -u {DB_USER} -p {DB_NAME} &lt; path/to/file/filename.sql
mysql -u root -p dbname&lt; &quot;C:\Users\sdkca\Desktop\mydb.sql&quot;

blocks|key|5352555|text|mysql+-h+localhost+-u+username+-p+databasename+<+dump.sql|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|5352556|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 -h localhost -u username -p databasename &lt; dump.sql
</code></pre>

I have this command:

<pre><code>mysql -u #myusername -p #mypasswd MYBASE &lt; c:\user\folderss\myscript.sql
</code></pre>

But I get the following error:

<pre><code>Error
unknow command '\U'
unknow command '\m'
unknow command '\D'
unknow command '\L'
</code></pre>

Import mysql DB with XAMPP in command LINE

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我有这个命令：mysql -u #myusername -p #mypasswd MYBASE < c:\user\folderss\myscript.sql但我得到以下错误：Errorunknow command '\U'unknow command '\m'unknow command '\D'unknow command '\L'

问在命令行中使用XAMPP导入mysql DB
EN

回答 17

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在命令行中使用XAMPP导入mysql DBEN

回答 17

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在命令行中使用XAMPP导入mysql DB
EN