1. 
$ C:\wamp64\bin\mariadb\mariadb10.6.3\bin\mysql.exe -u username -p --default-character-set=utf8
2. 選擇db:
$ use dbname;
3. 匯入資料:
$ source c:\xxx.sq

學習

創作

職場產業

<div class="draft-block draft--p left">1. <br>$ C:\wamp64\bin\mariadb\mariadb10.6.3\bin\mysql.exe -u username -p --default-character-set=utf8</div>
<div class="draft-block draft--p left">2. 選擇db:<br>$ use dbname;</div>
<div class="draft-block draft--p left">3. 匯入資料:<br>$ source c:\xxx.sql;</div>
<div class="draft-block draft--p left">匯入大檔案可以用這種方式，phpmyadmin會有上傳大小限制。</div>
<div class="draft-block draft--p left"></div>
<div class="draft-block draft--p left"><span style="font-weight: bold; ">後記:</span></div>
<div class="draft-block draft--p left">ERROR 1118 (42000) at line 29 in file: 'c:\wamp64\xxx.sql': Row size too large (&gt; 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help.</div>
<div class="draft-block draft--p left">=&gt;遇到這個問題解法為<br>找到my.ini在[mysqld]下面一行加上 innodb_strict_mode = 0</div>
<div class="draft-block draft--p left"></div>
<div class="draft-block draft--p left"><span style="font-style: italic; ">本筆記參考:<br>1.</span><a href="https://www.huaweicloud.com/articles/5c13b6300e162ee619bf4c32d0c42890.html" target="_blank" class="draft--a"><span style="font-style: italic; ">https://www.huaweicloud.com/articles/5c13b6300e162ee619bf4c32d0c42890.html</span></a><span style="font-style: italic; "><br>2. </span><a href="https://blog.51cto.com/meiling/1625449" target="_blank" class="draft--a"><span style="font-style: italic; ">https://blog.51cto.com/meiling/1625449</span></a></div>

<p>1. <br>
$ C:\wamp64\bin\mariadb\mariadb10.6.3\bin\mysql.exe -u username -p --default-character-set=utf8</p>
<p>2. 選擇db:<br>
$ use dbname;</p>
<p>3. 匯入資料:<br>
$ source c:\xxx.sql;</p>
<p>匯入大檔案可以用這種方式，phpmyadmin會有上傳大小限制。</p>
<p><br></p>
<p><strong>後記:</strong></p>
<p>ERROR 1118 (42000) at line 29 in file: 'c:\wamp64\xxx.sql': Row size too large (&gt; 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help.</p>
<p>=&gt;遇到這個問題解法為<br>
找到my.ini在[mysqld]下面一行加上 innodb_strict_mode = 0</p>
<p><br></p>
<p><em>本筆記參考:<br>
1.</em><a href="https://www.huaweicloud.com/articles/5c13b6300e162ee619bf4c32d0c42890.html"><em>https://www.huaweicloud.com/articles/5c13b6300e162ee619bf4c32d0c42890.html</em></a><em><br>
2. </em><a href="https://blog.51cto.com/meiling/1625449"><em>https://blog.51cto.com/meiling/1625449</em></a></p>

1. 
$ C:\wamp64\bin\mariadb\mariadb10.6.3\bin\mysql.exe -u username -p --default-character-set=utf8

匯入大檔案可以用這種方式，phpmyadmin會有上傳大小限制。

ERROR 1118 (42000) at line 29 in file: 'c:\wamp64\xxx.sql': Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help.

=>遇到這個問題解法為
找到my.ini在[mysqld]下面一行加上 innodb_strict_mode = 0

本筆記參考:
1.https://www.huaweicloud.com/articles/5c13b6300e162ee619bf4c32d0c42890.html
2. https://blog.51cto.com/meiling/1625449

Wamp Server Mariadb import