blocks|key|2066356|text|我怀疑您将能够通过phpmyadmin导入1GB文件，但是您可以尝试在php.ini中增加以下值并重新启动wamp。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2066357|post_max_size=1280M
upload_max_filesize=1280M
max_execution_time+=+300+//increase+time+as+per+your+server+requirement.+|code-block|syntax|javascript|2066358|您也可以从命令提示符尝试下面的命令，您的路径可能因您的MySQL安装而不同。|2066359|C:\wamp\bin\mysql\mysql5.5.24\bin\mysql.exe+-u+root+-p+db_name+<+C:\some_path\your_sql_file.sql|2066360|您应该在max_allowed_packet中增加mysql的my.ini以避免MySQL+server+gone+away错误，如下所示|offset|length|style|CODE|2066361|max_allowed_packet+=+100M|2066362|entityMap^0|0|0|0|0|4|I|V|6|14|M|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|Y|8|@$M|Z|N|10|O|P]|$M|11|N|12|O|P]|$M|13|N|14|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|S|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|T|$]]

I suspect you will be able to import 1 GB file through phpmyadmin But you can try by increasing the following value in php.ini and restart the wamp.
<pre><code>post_max_size=1280M
upload_max_filesize=1280M
max_execution_time = 300 //increase time as per your server requirement. 
</code></pre>
You can also try below command from command prompt, your path may be different as per your MySQL installation.
<pre><code>C:\wamp\bin\mysql\mysql5.5.24\bin\mysql.exe -u root -p db_name &lt; C:\some_path\your_sql_file.sql
</code></pre>
You should increase the <code>max_allowed_packet</code> of mysql in <code>my.ini</code> to avoid <code>MySQL server gone away</code> error, something like this
<pre><code>max_allowed_packet = 100M
</code></pre>

blocks|key|2066478|text|步骤1:找到位于phpmyadmin目录中的config.inc.php文件。就我的情况而言，它位于这里：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|2066479|C:\wamp\apps\phpmyadmin3.4.5\config.inc.php+|code-block|syntax|javascript|2066480|注:+phymyadmin3.4.5文件夹名在不同版本的wamp中有所不同|2066481|步骤2:找到其上带有$cfg['UploadDir']的行，并将其更新为：|2066482|$cfg['UploadDir']+=+'upload';|2066483|步骤3:在phpmyadmin目录中创建一个名为“upload”的目录。|2066484|C:\wamp\apps\phpmyadmin3.2.0.1\upload\|2066485|步骤4:将大型sql文件复制并粘贴到要导入到phymyadmin的上载目录中。|2066486|步骤5:从从phymyadmin到导入的下拉列表中选择文件。|2066487|entityMap^0|0|4|M|E|0|0|0|0|4|A|H|0|0|0|4|0|0|0|13|0|0|R|0^^$0|@$1|2|3|4|5|6|7|11|8|@$9|12|A|13|B|C]|$9|14|A|15|B|D]]|E|@]|F|$]]|$1|G|3|H|5|I|7|16|8|@]|E|@]|F|$J|K]]|$1|L|3|M|5|6|7|17|8|@]|E|@]|F|$]]|$1|N|3|O|5|6|7|18|8|@$9|19|A|1A|B|C]|$9|1B|A|1C|B|D]]|E|@]|F|$]]|$1|P|3|Q|5|I|7|1D|8|@]|E|@]|F|$J|K]]|$1|R|3|S|5|6|7|1E|8|@$9|1F|A|1G|B|C]]|E|@]|F|$]]|$1|T|3|U|5|I|7|1H|8|@]|E|@]|F|$J|K]]|$1|V|3|W|5|6|7|1I|8|@$9|1J|A|1K|B|C]]|E|@]|F|$]]|$1|X|3|Y|5|6|7|1L|8|@$9|1M|A|1N|B|C]]|E|@]|F|$]]|$1|Z|3|-4|5|6|7|1O|8|@]|E|@]|F|$]]]|10|$]]

Step 1: 
Find the <code>config.inc.php</code> file located in the phpmyadmin directory. In my case it is located here: 

<pre><code>C:\wamp\apps\phpmyadmin3.4.5\config.inc.php 
</code></pre>

Note: phymyadmin3.4.5 folder name is different in different version of wamp

Step 2: 
Find the line with <code>$cfg['UploadDir']</code> on it and update it to:

<pre><code>$cfg['UploadDir'] = 'upload';
</code></pre>

Step 3: 
Create a directory called ‘upload’ within the phpmyadmin directory.

<pre><code>C:\wamp\apps\phpmyadmin3.2.0.1\upload\
</code></pre>

Step 4: 
Copy and paste the large sql file into upload directory which you want importing to phymyadmin

Step 5: 
Select sql file from drop down list from phymyadmin to import.

blocks|key|3147663|text|Ram+Sharma指示的值可能需要在Wamp别名配置文件中更改。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3147664|在<wamp_dir>/alias/phpmyadmin.conf中，在<Directory>部分：|CODE|3147665|++php_admin_value+upload_max_filesize+1280M
++php_admin_value+post_max_size+1280M
++php_admin_value+max_execution_time+1800|code-block|syntax|javascript|3147666|entityMap^0|0|A|0|1|W|10|B|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@$9|T|A|U|B|H]|$9|V|A|W|B|H]]|D|@]|E|$]]|$1|I|3|J|5|K|7|X|8|@]|D|@]|E|$L|M]]|$1|N|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|O|$]]

The values indicated by Ram Sharma might need to be changed in Wamp alias configuration files instead.

In <code>&lt;wamp_dir&gt;/alias/phpmyadmin.conf</code>, in the <code>&lt;Directory&gt;</code> section:

<pre><code> php_admin_value upload_max_filesize 1280M
 php_admin_value post_max_size 1280M
 php_admin_value max_execution_time 1800
</code></pre>

blocks|key|613062|text|确保在更新的phpMyAdmin应用程序上也检查phpMyAdmin配置文件！，默认情况下它被设置为128+by。即使您将phpmyadmin.conf！更新为所需的值，仍然需要更新php.ini|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|613063|样本路径:+C:\wamp64\alias\phpmyadmin.conf|613064|或通过您的WAMP图标编辑：->Apache+->别名目录->+phpMyAdmin|613065|​|613066|📷|atomic|613067|613068|613069|613070|613071|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/9a578e89388f185728a62ef79f90a7c9.png|imageAlt|1|https://developer.qcloudimg.com/http-save/yehe-900000/8a4f0c029cbe0d074f4816c33e3de5a0.png^0|0|13|1P|F|0|0|0|16|0|0|0|1|0|0|0|0|0|1|1|0|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|6|7|19|8|@$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|1C|8|@]|D|@]|E|$]]|$1|L|3|M|5|N|7|1D|8|@]|D|@$9|1E|A|1F|1|1G]]|E|$]]|$1|O|3|K|5|6|7|1H|8|@]|D|@]|E|$]]|$1|P|3|K|5|6|7|1I|8|@]|D|@]|E|$]]|$1|Q|3|M|5|N|7|1J|8|@]|D|@$9|1K|A|1L|1|1M]]|E|$]]|$1|R|3|K|5|6|7|1N|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|1O|8|@]|D|@]|E|$]]]|T|$U|$5|V|W|X|E|$Y|Z|10|-4]]|11|$5|V|W|X|E|$Y|12|10|-4]]]]

Make sure to check the phpMyAdmin config file as well! On newer WAMP applications it is set to 128Mb by default. Even if you update php.ini to desired values you still need to update the phpmyadmin.conf!

Sample path: C:\wamp64\alias\phpmyadmin.conf

Or edit through your WAMP icon by: ->Apache -> Alias directories -> phpMyAdmin

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

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

blocks|key|613034|text|我也面临着同样的问题，奇怪的是，改变php.ini中的值对我来说是行不通的。但我又找到了一个对我有用的解决方案。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|613035|单击您的Wamp服务器图标->+MySQL+->+MySQL控制台|unordered-list-item|613036|一旦MySQL控制台打开。输入您的MySQL密码并输入以下命令：|613037|使用user_database_name|ordered-list-item|613038|源路径/to/your/sql/path/filename.sql|613039|如果你仍然有问题，看这个视频。|613040|entityMap|0|LINK|mutability|MUTABLE|url|https://youtu.be/ecRT_GPQPGE^0|I|7|0|0|0|0|0|C|2|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|$]]|$1|I|3|J|5|H|7|13|8|@]|D|@]|E|$]]|$1|K|3|L|5|M|7|14|8|@]|D|@]|E|$]]|$1|N|3|O|5|M|7|15|8|@]|D|@]|E|$]]|$1|P|3|Q|5|6|7|16|8|@]|D|@$9|17|A|18|1|19]]|E|$]]|$1|R|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|S|$T|$5|U|V|W|E|$X|Y]]]]

I also faced the same problem and, strangely enough, changing the values in <code>php.ini</code> did not work for me.
But I found out one more solution that worked for me.
<ul>
<li>Click your Wamp server icon -&gt; MySQL -&gt; MySQL console</li>
<li>Once MySQL console is open. Enter your MySQL password and enter these commands:</li>
</ul>
<ol>
<li>use user_database_name</li>
<li>source path/to/your/sql/path/filename.sql</li>
</ol>
If you still have problems, watch this <a href="https://youtu.be/ecRT_GPQPGE" rel="nofollow noreferrer">video</a>.

blocks|key|3147510|text|有哪些可能的方法可以这样做，比如导入.sql文件的任何SQL查询？|type|blockquote|depth|inlineStyleRanges|entityRanges|data|3147511|尝尝这个|unstyled|3147512|+mysql+-u<user>+-p<password>+<database+name>+<+/path/to/dump.sql|code-block|syntax|javascript|3147513|假设dump.sql是1GB转储文件|offset|length|style|CODE|3147514|entityMap^0|0|0|0|2|8|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|S|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|T|8|@]|9|@]|A|$H|I]]|$1|J|3|K|5|D|7|U|8|@$L|V|M|W|N|O]]|9|@]|A|$]]|$1|P|3|-4|5|D|7|X|8|@]|9|@]|A|$]]]|Q|$]]

<blockquote>
 What are the possible ways to do that such as any SQL query to import .sql file ?
</blockquote>

Try this

<pre><code> mysql -u&lt;user&gt; -p&lt;password&gt; &lt;database name&gt; &lt; /path/to/dump.sql
</code></pre>

assuming <code>dump.sql</code> is your 1 GB dump file

blocks|key|3147534|text|名为phpMyAdmin的UploadDir特性允许通过另一种机制上传文件，然后从服务器的文件系统导入文件。见http://docs.phpmyadmin.net/en/latest/faq.html#i-cannot-upload-big-dump-files-memory-http-or-timeout-problems。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3147535|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.phpmyadmin.net/en/latest/faq.html#i-cannot-upload-big-dump-files-memory-http-or-timeout-problems^0|1J|30|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

A phpMyAdmin feature called UploadDir permits to upload your file via another mechanism, then importing it from the server's file system. See <a href="http://docs.phpmyadmin.net/en/latest/faq.html#i-cannot-upload-big-dump-files-memory-http-or-timeout-problems" rel="nofollow">http://docs.phpmyadmin.net/en/latest/faq.html#i-cannot-upload-big-dump-files-memory-http-or-timeout-problems</a>.

blocks|key|613157|text|如果您将尝试通过phpmyadmin加载如此大的文件，那么您需要将php.ini中的php.ini更改为您的需求，然后上传之后，您将不得不将其还原回。会发生什么呢？如果您想要加载一个3GB的文件。您必须在php.ini中再次更改这些参数。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|613158|解决此问题的最佳解决方案是在windows中打开命令提示符。|613159|查找wamp+mysql目录的路径。|613160|通常，它是C:/wamp64/bin/mysql/mysqlversion/bin/mysql.exe|offset|length|style|CODE|613161|执行mysql+-u+root|613162|您将处于mysql命令提示符中。|613163|使用use命令切换数据库。|613164|mysql>+use+database_name
mysql>+source+[file_path]|code-block|syntax|javascript|613165|如果是Windows，下面是示例。|613166|mysql>+source+C:/sqls/sql1GB.sql|613167|就这样。如果您的数据库超过10+or或1000+or。这个方法仍然适用于你。|613168|entityMap^0|0|0|0|5|1A|0|2|D|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|16|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|17|8|@$H|18|I|19|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|1A|8|@$H|1B|I|1C|J|K]]|9|@]|A|$]]|$1|N|3|O|5|6|7|1D|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1E|8|@]|9|@]|A|$]]|$1|R|3|S|5|T|7|1F|8|@]|9|@]|A|$U|V]]|$1|W|3|X|5|6|7|1G|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|T|7|1H|8|@]|9|@]|A|$U|V]]|$1|10|3|11|5|6|7|1I|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|13|$]]

If you will try to load such a large file through phpmyadmin then you would need to change upload_file_size in php.ini to your requirements and then after uploading you will have to revert it back. What will happen? If you would like to load a 3GB file. You will have to change those parameters in php.ini again.

The best solution to solve this issue to open command prompt in windows.

Find path of wamp mysql directory.

Usually, it is <code>C:/wamp64/bin/mysql/mysqlversion/bin/mysql.exe</code>

Execute <code>mysql -u root</code>

You will be in mysql command prompt

Switch database with use command.

<pre><code>mysql&gt; use database_name
mysql&gt; source [file_path]
</code></pre>

In case of Windows, here is the example.

<pre><code>mysql&gt; source C:/sqls/sql1GB.sql
</code></pre>

That's it. If you will have a database over 10GB or 1000GB. This method will still work for you.

blocks|key|3147583|text|导入之前，只需确保max_allowed_pack值设置了一些很大的东西，否则您将得到一个错误：Error+2006+MySQL+server+gone+away.|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3147584|然后尝试命令：mysql+-u+root+-p+database_name+<+file.sql|3147585|entityMap^0|1C|Y|0|7|15|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

Before importing just make sure you have max_allowed_pack value set some thing large else you will get an error: <code>Error 2006 MySQL server gone away.</code> 

Then try the command: <code>mysql -u root -p database_name &lt; file.sql</code>

blocks|key|611255|text|你可以用以下的方式来做；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|611256|您可以转到控制面板/cpanel并添加主机%25，这意味着现在可以从本地计算机访问数据库服务器。现在您可以安装并使用MySQL管理员或Navicat导入和导出数据库，而无需使用PHP，我多次使用它上传200+MB到500+MB的数据，没有任何问题。|ordered-list-item|611257|使用gzip，bzip2压缩进行导出和导入。我在Windows中使用PEA+ZIP软件(免费)。尽量避免Winrar和Winzip|611258|使用将MySQL文件拆分成几个部分的Splitter。在我个人的建议中，不推荐|611259|使用PHP设置(动态更改最大上传和最大执行时间)，正如其他朋友已经提到的那样，是有成效的，但并不总是如此。|611260|entityMap^0|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|$]]|$1|E|3|F|5|D|7|O|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|P|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Q|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|L|$]]

You can do it in following ways;

<ol>
<li>You can go to control panel/cpanel and add host % 
It means now the database server can be accessed from your local machine.
Now you can install and use MySQL Administrator or Navicat to import and export database with out using PHP-Myadmin, I used it several times to upload 200 MB to 500 MB of data with no issues</li>
<li>Use gzip, bzip2 compressions for exporting and importing. I am using PEA ZIP software (free) in Windows. Try to avoid Winrar and Winzip</li>
<li>Use MySQL Splitter that splits up the sql file into several parts. In my personal suggestion, Not recommended</li>
<li>Using PHP INI setting (dynamically change the max upload and max execution time) as already mentioned by other friends is fruitful but not always.</li>
</ol>

blocks|key|3147727|text|我建议您一定要使用mysql命令提示符，这将是更快的选项。因为phpmyadmin+UI和浏览器本身对进程请求都有限制。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3147728|下面是使用mysql命令行的步骤。|3147729|如果你使用xampp/wamp/mamp并不重要|3147730|find+mysql+directory+in+xampp/wamp/mamp+in+your+system+directory|code-block|syntax|javascript|3147731|查找bin文件夹路径是system+dir/(xampp/wamp)/mysql/bin|3147732|now+open+command+prompt+i'll+refer+to+windows

please+change+directory+in+command+line+and+point+to+path_to_mysql_bin|3147733|然后用户跟随命令|3147734|"mysql-u+root+-p+-h+localhost“按回车系统将再次要求输入密码。|3147735|你终于加入了|3147736|请使用命令"use+Database_name“指向特定的数据库，这样就可以了|3147737|如果你想把数据库上传到前。温度表|3147738|然后按照以下步骤执行|3147739|use+temp;
source+path_to_sql_file_where_db_is_store_in_your_system.sql;|3147740|这将上载temp+db中的sql文件数据库。|3147741|如果你没有从这件事中得到任何部分，那么请下午我一定会帮助你。|3147742|米特什|3147743|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1B|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1C|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|1D|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|1E|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|1F|8|@]|9|@]|A|$I|J]]|$1|O|3|P|5|6|7|1G|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1H|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1I|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1J|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1K|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1L|8|@]|9|@]|A|$]]|$1|10|3|11|5|H|7|1M|8|@]|9|@]|A|$I|J]]|$1|12|3|13|5|6|7|1N|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|1O|8|@]|9|@]|A|$]]|$1|16|3|17|5|6|7|1P|8|@]|9|@]|A|$]]|$1|18|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]]|19|$]]

I suggest you'd definitely use mysql command prompt that would be faster option. because there are limitation in phpmyadmin UI and browsers itself for process request

following are steps to use mysql command line.

doesnt matter if you user xampp/wamp/mamp

<pre><code>find mysql directory in xampp/wamp/mamp in your system directory
</code></pre>

search for bin folder path is system dir/(xampp/wamp)/mysql/bin

<pre><code>now open command prompt i'll refer to windows

please change directory in command line and point to path_to_mysql_bin
</code></pre>

then user following command

"mysql-u root -p -h localhost" press enter system will ask for password press enter again

finally you're in

please use command "use Database_name" to point to specific database and you're good to go

if you want to upload database in to for ex. temp table

then follow these steps

<pre><code>use temp;
source path_to_sql_file_where_db_is_store_in_your_system.sql;
</code></pre>

this will upload sql file database in temp db

if you didnt get any part from this then please pm me i'll definitely help you out.

Mitesh

blocks|key|612969|text|我试过用SQLyog，它已经完成了工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|612970|entityMap|0|LINK|mutability|MUTABLE|url|http://www.webyog.com/^0|4|6|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I've tried with the <a href="http://www.webyog.com" rel="nofollow">SQLyog</a> and It has done the work.

blocks|key|3147821|text|转到c:/wamp/app/phpadmin3.5.2，创建一个名为‘upload’config.inc.php的新子文件夹来查找和更新这一行：$cfg‘’UploadDir‘=’‘UploadDir’=‘upload’现在当您导入一个数据库时，您将在web服务器上载目录中给出一个下拉列表，其中包含这个目录中的所有文件。选择您想要的文件，您就完成了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3147822|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|$]]

Go to c:/wamp/apps/phpadmin3.5.2
Make a new subfolder called ‘upload’
Edit config.inc.php to find and update this line: $cfg[‘UploadDir’] = ‘upload’
Now when you import a database, you will give a drop-down list in web server upload directory with all the files in this directory. Chose the file you want and you are done.

I want to import over 1GB size <code>sql</code> file to <code>MySQL</code> database in localhost <code>WAMP/phpmyadmin</code>. But <code>phpmyadmin</code> UI doesn't allow to import such big file.

What are the possible ways to do that such as any <code>SQL</code> query to import .sql file ?

Thanks

How to Import 1GB .sql file to WAMP/phpmyadmin

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

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

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

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

社区新版编辑器体验调研

我希望将超过1GB大小的sql文件导入到本地主机WAMP/phpmyadmin中的MySQL数据库中。但是phpmyadmin UI不允许导入这么大的文件。有哪些可能的方法可以这样做，如导入SQL文件的任何.sql查询？谢谢

问如何将1GB .sql文件导入WAMP/phpmyadmin
EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将1GB .sql文件导入WAMP/phpmyadminEN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将1GB .sql文件导入WAMP/phpmyadmin
EN