LemonWiki共筆 - Recent changes [en]

Taiwan Programmer Community

Planetoid — Thu, 13 Aug 2026 05:58:54 GMT

← Older revision		Revision as of 13:58, 13 August 2026
Line 2:		Line 2:

	台灣開發者社群		台灣開發者社群

			=== AI, AI agent ===
			* [https://blindegg.kktix.cc/ Generative AI 年會製作委員會 - KKTIX]
			* [https://platform.kktix.cc/ Platform 月台 - KKTIX] (Platform 月台計畫 Stopover)


	=== Language specific ===		=== Language specific ===

Troubleshooting of Ollama API

Planetoid — Wed, 12 Aug 2026 09:03:11 GMT

How to fix "json: cannot unmarshal object ..."

← Older revision		Revision as of 17:03, 12 August 2026
(One intermediate revision by the same user not shown)
Line 3:		Line 3:

	{{Raise hand \| text = If you have any questions about the Ollama API, you can post them on the [https://github.com/ollama/ollama/issues Ollama GitHub Repository].}}		{{Raise hand \| text = If you have any questions about the Ollama API, you can post them on the [https://github.com/ollama/ollama/issues Ollama GitHub Repository].}}

			== How to Fix "Unauthorized" Error ==

			'''Error message:'''
			<pre>
			HTTP Error 401
			Response: {"error":"Unauthorized"}
			</pre>

			'''Solution'''

			Verify that your API key is correct by testing it with the following curl command:

			<pre>
			curl -s -o /dev/null -w "%{http_code}\n" -X POST https://ollama.com/api/chat -H "Authorization: Bearer REPLACE_WITH_YOUR_API_KEY" -H "Content-Type: application/json" -d '{"model":"gpt-oss:120b","messages":[{"role":"user","content":"hi"}],"stream":false}'
			</pre>

			Check the returned status code:
			* '''200''' — the API key is valid
			* '''401''' — the API key is invalid or incorrect

			== How to fix "prompt too long; exceeded max context length" when sending files ==

			'''Error message:'''
			<pre>
			HTTP Error 400: {"error":"prompt too long; exceeded max context length by 311181 tokens"}
			</pre>

			'''Applicable Model:'''

			* {{kbd \| key=gpt-oss:120b}}

			'''Solution'''

			Root Cause: The entire file content was concatenated into <code>content</code> as raw text. Ollama's <code>/api/chat</code> has no dedicated "file" field — text/document content must be extracted client-side and embedded directly into the message string, which counts fully against <code>num_ctx</code>.

			Incorrect Usage: Whole file dumped straight into content
			<pre>
			'messages' => [[
			'role' => 'user',
			'content' => file''get''contents($path) . "\n\nPlease summary this document"
			]]
			</pre>

			Correct Usage: Truncate / chunk / summarize before sending, and raise <code>num_ctx</code> to match
			<pre>
			'messages' => [[
			'role' => 'user',
			'content' => $chunkedText . "\n\nPlease summary this document"
			]],
			'options' => [
			'num_ctx' => 32768
			]
			</pre>

			'''Explanation:'''
			Ollama's chat endpoint only has a native <code>images</code> array (base64-encoded, vision models only). There is no <code>files</code> or <code>document</code> parameter. Any non-image file — PDF, txt, docx, log — must be converted to plain text on the client and inserted into <code>content</code>, so its size is not free; it consumes tokens exactly like typed text.

			If the resulting text exceeds the model's context window (<code>num_ctx</code>, default is often small, e.g. 2048–4096), the request fails with <code>"prompt too long"</code>. Fix by combining:

			* Explicitly setting a larger <code>num_ctx</code> in <code>options</code> (bounded by what the model/hardware can actually support)
			* Chunking the file and sending it in multiple requests
			* Pre-summarizing or using RAG-style retrieval so only relevant excerpts are sent, instead of the full file

			This fix resolves the <code>"prompt too long; exceeded max context length"</code> error when large files are pasted into chat.

	== How to fix "json: cannot unmarshal object ..." ==		== How to fix "json: cannot unmarshal object ..." ==

Capacity of Email Service

Planetoid — Tue, 11 Aug 2026 02:48:33 GMT

Email服務每封郵件的檔案大小上限

← Older revision		Revision as of 10:48, 11 August 2026
Line 6:		Line 6:
	'''建議''':		'''建議''':
	* 檔案大小 (file size) 控制在'''6-10MB''': 因為信件夾帶的檔案經過編碼([http://en.wikipedia.org/wiki/MIME MIME] encode)後，會導致檔案大小變大，所以寄信時的信件(含夾帶的檔案)檔案大小建議能控制在上限的三分之二，即6-10MB，以免被退信。		* 檔案大小 (file size) 控制在'''6-10MB''': 因為信件夾帶的檔案經過編碼([http://en.wikipedia.org/wiki/MIME MIME] encode)後，會導致檔案大小變大，所以寄信時的信件(含夾帶的檔案)檔案大小建議能控制在上限的三分之二，即6-10MB，以免被退信。
	* 超過10MB的檔案，可以考慮使用將附檔[[File compression\|壓縮]] 或放在Web、FTP、[http://en.wikipedia.org/wiki/Comparison_of_one-click_hosters 線上檔案儲存網站]、[[Snapchat of file sharing \| 閱後即焚檔案分享服務]] ex: [https://drive.google.com/ Google Drive] 單一檔案限 5TB<ref>[https://support.google.com/drive/answer/37603?hl=zh-Hant&vid=1-635756751147519182-13007898089037315163 檔案大小 - 雲端硬碟說明] {{access \| date = 2015-08-20}}</ref>, DropBox 單一檔案限2GB<ref>[https://www.dropbox.com/help/5 Dropbox 是否有檔案大小的限制或上限？ (Dropbox 說明中心)]</ref>, [http://www.mediafire.com/ MediaFire](非圖檔的單一檔案限200MB)~~, [http://www.yousendit.com/ YouSendIt](單一檔案限100MB) ...。~~		* 超過10MB的檔案，可以考慮使用將附檔[[File compression\|壓縮]] 或放在Web、FTP、[http://en.wikipedia.org/wiki/Comparison_of_one-click_hosters 線上檔案儲存網站]、[[Snapchat of file sharing \| 閱後即焚檔案分享服務]] ex: [https://drive.google.com/ Google Drive] 單一檔案限 5TB<ref>[https://support.google.com/drive/answer/37603?hl=zh-Hant&vid=1-635756751147519182-13007898089037315163 檔案大小 - 雲端硬碟說明] {{access \| date = 2015-08-20}}</ref>, DropBox 單一檔案限2GB<ref>[https://www.dropbox.com/help/5 Dropbox 是否有檔案大小的限制或上限？ (Dropbox 說明中心)]</ref>, [http://www.mediafire.com/ MediaFire](非圖檔的單一檔案限200MB) 等。

	<div style="width:100%; min-height: .01%; overflow-x: auto;">		<div style="width:100%; min-height: .01%; overflow-x: auto;">

Email testing

Planetoid — Tue, 11 Aug 2026 02:32:53 GMT

For role: users

← Older revision		Revision as of 10:32, 11 August 2026
Line 5:		Line 5:
	* [https://gmail.google.com/ Google Gmail]: plus sign {{exclaim}} the plus sign is not allowed by some websites		* [https://gmail.google.com/ Google Gmail]: plus sign {{exclaim}} the plus sign is not allowed by some websites
	* Suggest search keyword: [http://lmgtfy.com/?q=anonymous%20email anonymous email]、拋棄式信箱 (Disposable Email) e.g. ''$'' [http://doc.mail2000.com.tw/edm/o_act/virtual/htm/faq.htm Ｍail2000拋棄式帳號：全新網域輕鬆拋棄廣告信Bye-bye！]		* Suggest search keyword: [http://lmgtfy.com/?q=anonymous%20email anonymous email]、拋棄式信箱 (Disposable Email) e.g. ''$'' [http://doc.mail2000.com.tw/edm/o_act/virtual/htm/faq.htm Ｍail2000拋棄式帳號：全新網域輕鬆拋棄廣告信Bye-bye！]
	* ~~''服務停止''<ref>~~[~~https://support.microsoft.com/zh-tw/help/12407/microsoft-account-manage-aliases 管理您 Microsoft 帳戶上的別名]</ref>~~ [~~http://get.live.com/mail/overview Windows Live™ Hotmail~~]~~: [http://windows.microsoft.com/zh-TW/hotmail/conquergraymail/advanced/alias Alias~~] ~~/ 在一個收件匣建立多個別名 {{access \| date=2012-03-30}}~~		* [[Capacity of Email Service]]


	== For role: web developers ==		== For role: web developers ==

Capacity of Email Service

Planetoid — Tue, 11 Aug 2026 02:25:24 GMT

相關頁面

← Older revision		Revision as of 10:25, 11 August 2026
Line 120:		Line 120:
	* [[User_agent#Mail_user_clients_.2F_Mail_user_agents \|mail user client]]		* [[User_agent#Mail_user_clients_.2F_Mail_user_agents \|mail user client]]
	* [http://en.wikipedia.org/wiki/Comparison_of_webmail_providers Comparison of webmail providers - Wikipedia, the free encyclopedia]		* [http://en.wikipedia.org/wiki/Comparison_of_webmail_providers Comparison of webmail providers - Wikipedia, the free encyclopedia]
			* [[Email testing]]

	== 相關新聞聯播 ==		== 相關新聞聯播 ==

Email testing

Planetoid — Tue, 11 Aug 2026 02:25:06 GMT

For role: web developers

← Older revision		Revision as of 10:25, 11 August 2026
Line 9:		Line 9:

	== For role: web developers ==		== For role: web developers ==
			* {{Gd}} [https://www.caniemail.com/ Can I email… Support tables for HTML and CSS in emails] {{access \| date=2026-04-24}} e.g. [https://www.caniemail.com/features/image-webp/ Can I email… webP image format]
	* [[Troubleshooting of PHP errors#錯誤訊息: SMTP Error: Could not connect to SMTP host.]]		* [[Troubleshooting of PHP errors#錯誤訊息: SMTP Error: Could not connect to SMTP host.]]

Capacity of Email Service

Planetoid — Tue, 11 Aug 2026 02:25:03 GMT

相關頁面

← Older revision		Revision as of 10:25, 11 August 2026
Line 118:		Line 118:
	* {{Gd}} [[Procedure_of_campus_event#email \| email 溝通途徑的注意事項]]		* {{Gd}} [[Procedure_of_campus_event#email \| email 溝通途徑的注意事項]]
	* [[Anti Spam Email\|防制廣告信件]]		* [[Anti Spam Email\|防制廣告信件]]
	* {{Gd}} [https://www.caniemail.com/ Can I email… Support tables for HTML and CSS in emails] {{access \| date=2026-04-24}} e.g. [https://www.caniemail.com/features/image-webp/ Can I email… webP image format]
	* [[User_agent#Mail_user_clients_.2F_Mail_user_agents \|mail user client]]		* [[User_agent#Mail_user_clients_.2F_Mail_user_agents \|mail user client]]
	* [http://en.wikipedia.org/wiki/Comparison_of_webmail_providers Comparison of webmail providers - Wikipedia, the free encyclopedia]		* [http://en.wikipedia.org/wiki/Comparison_of_webmail_providers Comparison of webmail providers - Wikipedia, the free encyclopedia]

I need inspiration

Planetoid — Mon, 10 Aug 2026 04:05:44 GMT

Misc.

← Older revision		Revision as of 12:05, 10 August 2026
Line 52:		Line 52:
	=== Presentation ===		=== Presentation ===
	* [https://www.instagram.com/p/C0g2P5hRe4B/?igshid=ODhhZWM5NmIwOQ%3D%3D Deck.Gallery 是一個專門為設計師、創業者和市場行銷人員提供簡報設計靈感的平台。由產品設計師 Muharrem 創建，這個平台讓你可以欣賞到來自全球的精彩設計，也歡迎你提交自己的作品，與大家分享你的創意。如果你需要專業的設計服務，Deck.Gallery… \| Instagram]		* [https://www.instagram.com/p/C0g2P5hRe4B/?igshid=ODhhZWM5NmIwOQ%3D%3D Deck.Gallery 是一個專門為設計師、創業者和市場行銷人員提供簡報設計靈感的平台。由產品設計師 Muharrem 創建，這個平台讓你可以欣賞到來自全球的精彩設計，也歡迎你提交自己的作品，與大家分享你的創意。如果你需要專業的設計服務，Deck.Gallery… \| Instagram]

			=== Portfolio ===
			* [https://www.bestfolios.com/home Bestfolios - UI/UX Design Portfolio Inspiration and Showcase] 收集了設計師的作品集網站，作為 UI/UX 設計師打造個人作品集時的靈感來源。 {{access \| date = 2026-08-10}}

			* [https://www.awwwards.com/inspiration_search/porfolio/ Awwwards Nominees] Awwwards 網站收錄「作品集」類別的入圍與得獎網站。這些作品經過設計師社群投票得獎，可供觀摩排版、互動效果與視覺風格。 {{access \| date = 2026-08-10}}

	=== Misc. ===		=== Misc. ===

Troubleshooting of GIT

Planetoid — Fri, 07 Aug 2026 06:59:51 GMT

Git Push Failed: Invalid username or token (GitHub No Longer Supports Password Authentication)

Show changes

UX industry survey report

Planetoid — Wed, 05 Aug 2026 09:06:13 GMT

台灣

← Older revision		Revision as of 17:06, 5 August 2026
Line 6:		Line 6:

	使用者經驗設計產業與工作者年度調查		使用者經驗設計產業與工作者年度調查
	* [https://www.uigathering.org/ UXTW 台灣使用者經驗設計協會] (2024). [https://www.uxtw.org/%E7%94%A2%E6%A5%AD%E5%A0%B1%E5%91%8A-%E6%96%87%E7%AB%A0/ux-%E7%94%A2%E6%A5%AD%E8%88%87%E5%B7%A5%E4%BD%9C%E8%80%85%E8%AA%BF%E6%9F%A5%E5%A0%B1%E5%91%8A/2023 台灣使用者經驗設計產業與工作者 2023 年度調查]		* [https://www.uigathering.org/ UXTW 台灣使用者經驗設計協會] (2024). [https://www.uxtw.org/%E7%94%A2%E6%A5%AD%E5%A0%B1%E5%91%8A-%E6%96%87%E7%AB%A0/ux-%E7%94%A2%E6%A5%AD%E8%88%87%E5%B7%A5%E4%BD%9C%E8%80%85%E8%AA%BF%E6%9F%A5%E5%A0%B1%E5%91%8A/2023 台灣使用者經驗設計產業與工作者 2023 年度調查] ([https://drive.google.com/open?id=1kPYpU86BQqumy2h8ninX-P0sNFDLkHzK 完整報告 PDF 下載地址])
	* [https://www.uigathering.org/ UXTW 台灣使用者經驗設計協會] (2023). [https://www.facebook.com/theUXTW/posts/pfbid02U5SkJs33ekMzFHDwmg56d7EgY9BfugThxrvtDYGr1KZepfKGQSger2HgaXUGyTxMl 台灣使用者經驗設計產業與工作者 2022 年度調查] {{FB}} ([https://drive.google.com/file/d/1RcprBB1_j84s8x1YcTq5qD-PB7P4Q1Mq/view 完整報告 PDF 下載地址])		* [https://www.uigathering.org/ UXTW 台灣使用者經驗設計協會] (2023). [https://www.facebook.com/theUXTW/posts/pfbid02U5SkJs33ekMzFHDwmg56d7EgY9BfugThxrvtDYGr1KZepfKGQSger2HgaXUGyTxMl 台灣使用者經驗設計產業與工作者 2022 年度調查] {{FB}} ([https://drive.google.com/file/d/1RcprBB1_j84s8x1YcTq5qD-PB7P4Q1Mq/view 完整報告 PDF 下載地址])
	* [https://www.uigathering.org/ UXTW 台灣使用者經驗設計協會] (2022). [https://www.facebook.com/theUXTW/posts/10159525022523382 台灣使用者經驗設計產業與工作者 2021 年度調查] {{FB}} ([https://drive.google.com/file/d/1Iv4QPX-FaPmPtG3pGEe8216bxHdY0RlS/view 完整報告 PDF 下載地址])		* [https://www.uigathering.org/ UXTW 台灣使用者經驗設計協會] (2022). [https://www.facebook.com/theUXTW/posts/10159525022523382 台灣使用者經驗設計產業與工作者 2021 年度調查] {{FB}} ([https://drive.google.com/file/d/1Iv4QPX-FaPmPtG3pGEe8216bxHdY0RlS/view 完整報告 PDF 下載地址])

MySQL commands

Planetoid — Mon, 03 Aug 2026 07:48:17 GMT

← Older revision		Revision as of 15:48, 3 August 2026
(One intermediate revision by the same user not shown)
Line 75:		Line 75:
	# (optional) install {{kbd \| key =pv}} if the {{kbd \| key =pv}} was not installed for RHEL / CentOS / SL / Fedora Linux or {{kbd \| key =brew install pv}} for {{Mac}}<ref>[https://formulae.brew.sh/formula/pv pv — Homebrew Formulae]</ref>		# (optional) install {{kbd \| key =pv}} if the {{kbd \| key =pv}} was not installed for RHEL / CentOS / SL / Fedora Linux or {{kbd \| key =brew install pv}} for {{Mac}}<ref>[https://formulae.brew.sh/formula/pv pv — Homebrew Formulae]</ref>
	# (optional if the 7Zip was not installed) {{kbd \| key =yum install p7zip}} for RHEL / CentOS / SL / Fedora Linux		# (optional if the 7Zip was not installed) {{kbd \| key =yum install p7zip}} for RHEL / CentOS / SL / Fedora Linux
			'''method 1''': Import *.sql file:
	'''method 1~~''': {{Gd}} Import the compressed *.sql file with gzip (especially for BIG sql file). It will show a progress bar and estimated time to complete the mysql command:~~
	~~# Install {{kbd \| key =pv}}~~
	# Check if the file is gzip format (test the compressed file integrity) ex: (1) {{kbd \| key = <nowiki>gunzip -t database.sql.gz</nowiki>}} If not, it will return the message "gzip: database.sql.gz: not in gzip format." (2) Using [http://www.winmd5.com/ WinMD5 Free] for {{Win}} or [http://linux.die.net/man/1/md5sum md5sum] command for {{Linux}} to obtain MD5 checksum of files.
	# {{kbd \| key = <nowiki> pv database.sql.gz \| gunzip \| mysql -u username -p -h localhost --default_character_set utf8 --force DATA_BASE_NAME</nowiki>}} <ref>[http://journal.andrewloe.com/2009/05/12/pv-gzip-mysql/ pv + gzip + mysql — W. Andrew Loe III: Journal]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}
	~~# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} The console window will show ETA (Estimated Time of Arrival)~~

	~~'''method 2~~''': Import *.sql file:
	# (optional if the .sql file was compressed) {{kbd \| key =unzip data.zip}} or {{kbd \| key =gzip -d data.gz}} if the file was compressed by gzip		# (optional if the .sql file was compressed) {{kbd \| key =unzip data.zip}} or {{kbd \| key =gzip -d data.gz}} if the file was compressed by gzip
	# {{kbd \| key = <nowiki>mysql -u username -p -h localhost --default_character_set utf8 --force DATA_BASE_NAME < data.sql</nowiki>}} <ref>[http://www.cyberciti.biz/faq/import-mysql-dumpfile-sql-datafile-into-my-database/ Import MySQL Dumpfile, SQL Datafile Into My Database]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}		# {{kbd \| key = <nowiki>mysql -u username -p -h localhost --default_character_set utf8 --force DATA_BASE_NAME < data.sql</nowiki>}} <ref>[http://www.cyberciti.biz/faq/import-mysql-dumpfile-sql-datafile-into-my-database/ Import MySQL Dumpfile, SQL Datafile Into My Database]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}
	# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }}		# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }}

			'''method 2''': Import *.sql file with {{kbd \| key =--binary-mode}} (useful when the dump contains complex JSON string, binary data or BLOB fields, to avoid "\r\n" being misinterpreted and causing corrupted imports):
			# (optional if the .sql file was compressed) {{kbd \| key =unzip data.zip}} or {{kbd \| key =gzip -d data.gz}} if the file was compressed by gzip
			# {{kbd \| key = <nowiki>mysql -u username -p -h localhost --default_character_set utf8 --binary-mode --force DATA_BASE_NAME < data.sql</nowiki>}} <ref>[https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html#option_mysql_binary-mode mysql Command-Line Client Options — MySQL Reference Manual]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}
			# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} {{kbd \| key =--binary-mode}} disables all client-side conversions of {{kbd \| key =\r\n}} and treats {{kbd \| key =\0}} as a normal character, which is recommended whenever the dump was produced with {{kbd \| key =mysqldump --hex-blob}} or otherwise contains binary/BLOB content

	'''method 3''': Import the *.sql file (especially for BIG sql file). It will show a progress bar and estimated time to complete the mysql command<ref>[http://dba.stackexchange.com/questions/17367/how-can-i-monitor-the-progress-of-an-import-of-a-large-sql-file mysql - How can I monitor the progress of an import of a large .sql file? - Database Administrators Stack Exchange]</ref>:		'''method 3''': Import the *.sql file (especially for BIG sql file). It will show a progress bar and estimated time to complete the mysql command<ref>[http://dba.stackexchange.com/questions/17367/how-can-i-monitor-the-progress-of-an-import-of-a-large-sql-file mysql - How can I monitor the progress of an import of a large .sql file? - Database Administrators Stack Exchange]</ref>:
Line 92:		Line 90:
	# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} The console window will show ETA (Estimated Time of Arrival)		# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} The console window will show ETA (Estimated Time of Arrival)

	'''method 4''': Import ZIP file to MySql directly:		'''method 4''': Same as method 3, but combined with {{kbd \| key =--binary-mode}} to safely handle binary/BLOB content while showing a progress bar:
			# Install {{kbd \| key =pv}}
			# {{kbd \| key = <nowiki>pv data.sql \| mysql -u username -p -h localhost --default_character_set utf8 --binary-mode --force DATA_BASE_NAME</nowiki>}} and press {{kbd \| key = <nowiki>Enter</nowiki> }}
			# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} The console window will show ETA (Estimated Time of Arrival), and {{kbd \| key =--binary-mode}} disables all client-side conversions of {{kbd \| key =\r\n}} and treats {{kbd \| key =\0}} as a normal character, which is recommended whenever the dump was produced with {{kbd \| key =mysqldump --hex-blob}} or otherwise contains binary/BLOB content

			'''method 5''': {{Gd}} Import the compressed *.sql file with gzip (especially for BIG sql file). It will show a progress bar and estimated time to complete the mysql command:
			# Install {{kbd \| key =pv}}
			# Check if the file is gzip format (test the compressed file integrity) ex: (1) {{kbd \| key = <nowiki>gunzip -t database.sql.gz</nowiki>}} If not, it will return the message "gzip: database.sql.gz: not in gzip format." (2) Using [http://www.winmd5.com/ WinMD5 Free] for {{Win}} or [http://linux.die.net/man/1/md5sum md5sum] command for {{Linux}} to obtain MD5 checksum of files.
			# {{kbd \| key = <nowiki> pv database.sql.gz \| gunzip \| mysql -u username -p -h localhost --default_character_set utf8 --force DATA_BASE_NAME</nowiki>}} <ref>[http://journal.andrewloe.com/2009/05/12/pv-gzip-mysql/ pv + gzip + mysql — W. Andrew Loe III: Journal]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}
			# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} The console window will show ETA (Estimated Time of Arrival)

			'''method 6''': Same as method 5, but combined with {{kbd \| key =--binary-mode}} to safely handle binary/BLOB content while showing a progress bar:
			# Install {{kbd \| key =pv}}
			# Check if the file is gzip format (test the compressed file integrity) ex: (1) {{kbd \| key = <nowiki>gunzip -t database.sql.gz</nowiki>}} If not, it will return the message "gzip: database.sql.gz: not in gzip format." (2) Using [http://www.winmd5.com/ WinMD5 Free] for {{Win}} or [http://linux.die.net/man/1/md5sum md5sum] command for {{Linux}} to obtain MD5 checksum of files.
			# {{kbd \| key = <nowiki> pv database.sql.gz \| gunzip -c \| mysql -u username -p -h localhost --default_character_set utf8 --binary-mode --force DATA_BASE_NAME</nowiki>}} and press {{kbd \| key = <nowiki>Enter</nowiki> }}
			# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} The console window will show ETA (Estimated Time of Arrival), and {{kbd \| key =--binary-mode}} disables all client-side conversions of {{kbd \| key =\r\n}} and treats {{kbd \| key =\0}} as a normal character, which is recommended whenever the dump was produced with {{kbd \| key =mysqldump --hex-blob}} or otherwise contains binary/BLOB content

			'''method 7''': Import ZIP file to MySql directly:
	# Install the 7Zip		# Install the 7Zip
	# {{kbd \| key = <nowiki>7za x -so data.zip \| mysql -u username -p -h localhost --default_character_set utf8 --force DATA_BASE_NAME</nowiki>}} <ref>[http://stackoverflow.com/questions/11267309/importing-zipped-files-in-mysql-using-command-line database - Importing zipped files in Mysql using command line - Stack Overflow]</ref><ref>[http://needs-be.blogspot.tw/2011/01/install-7zip-on-centos-55.html Install 7Zip on CentOS 5.5]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}		# {{kbd \| key = <nowiki>7za x -so data.zip \| mysql -u username -p -h localhost --default_character_set utf8 --force DATA_BASE_NAME</nowiki>}} <ref>[http://stackoverflow.com/questions/11267309/importing-zipped-files-in-mysql-using-command-line database - Importing zipped files in Mysql using command line - Stack Overflow]</ref><ref>[http://needs-be.blogspot.tw/2011/01/install-7zip-on-centos-55.html Install 7Zip on CentOS 5.5]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}
Line 151:		Line 166:
	{{Template:Data factory flow}}		{{Template:Data factory flow}}

	[[Category:MySQL]]		[[Category: MySQL]]
	[[Category:Data Science]]		[[Category: Data Science]]
			[[Category: Revised with LLMs]]

Guiding principles on generative artificial intelligence in Mandarin

Planetoid — Mon, 03 Aug 2026 05:52:36 GMT

相關法規

← Older revision		Revision as of 13:52, 3 August 2026
(One intermediate revision by the same user not shown)
Line 53:		Line 53:
	== 相關法規 ==		== 相關法規 ==
	* 台灣行政院新聞傳播處 (2025-08-28). [https://www.ey.gov.tw/Page/9277F759E41CCD91/5d673d1e-f418-47dc-ab35-a06600f77f07 政院通過「人工智慧基本法」草案建構AI發展與應用良善環境打造臺灣成為AI人工智慧島 (行政院全球資訊網-本院一般新聞)]		* 台灣行政院新聞傳播處 (2025-08-28). [https://www.ey.gov.tw/Page/9277F759E41CCD91/5d673d1e-f418-47dc-ab35-a06600f77f07 政院通過「人工智慧基本法」草案建構AI發展與應用良善環境打造臺灣成為AI人工智慧島 (行政院全球資訊網-本院一般新聞)]
	* [https://artificialintelligenceact.eu/ EU Artificial Intelligence Act \| Up-to-date developments and analyses of the EU AI Act]		* 歐盟《人工智慧法案》 (歐盟 AI 法案) [https://artificialintelligenceact.eu/ EU Artificial Intelligence Act \| Up-to-date developments and analyses of the EU AI Act]
	* 中國 [https://en.wikipedia.org/wiki/Interim_Measures_for_the_Management_of_Generative_AI_Services Interim Measures for the Management of Generative AI Services - Wikipedia] ([https://www.cac.gov.cn/2023-07/13/c_1690898327029107.htm 生成式人工智慧服務管理暫行辦法_中央網路安全和資訊化委員會辦公室])		* 中國 [https://en.wikipedia.org/wiki/Interim_Measures_for_the_Management_of_Generative_AI_Services Interim Measures for the Management of Generative AI Services - Wikipedia] ([https://www.cac.gov.cn/2023-07/13/c_1690898327029107.htm 生成式人工智慧服務管理暫行辦法_中央網路安全和資訊化委員會辦公室])

HTTP request and response data tool

Planetoid — Fri, 31 Jul 2026 07:25:10 GMT

References

@@ Line 59: / Line 59: @@
 </pre>
 === other tools ===
@@ Line 95: / Line 134: @@
 <references/>
-[[Category:Design]]
+[[Category: Design]]
-[[Category:Programming]]
+[[Category: Programming]]
-[[Category:Data collecting]]
+[[Category: Data collecting]]
-[[Category:Security]]
+[[Category: Security]]

I need inspiration

Planetoid — Fri, 31 Jul 2026 04:06:21 GMT

← Older revision		Revision as of 12:06, 31 July 2026
(2 intermediate revisions by the same user not shown)
Line 6:		Line 6:
	* [https://dribbble.com/shots?sort=views Popular show cases on dribbble.com]: "Web designers, graphic designers, illustrators, icon artists, typographers, logo designers, and other creative types share small screenshots (shots) that show their work, process, and current projects." <ref>[http://dribbble.com/site/about Dribbble - About]</ref> {{access \| date = 2023-01-04}}		* [https://dribbble.com/shots?sort=views Popular show cases on dribbble.com]: "Web designers, graphic designers, illustrators, icon artists, typographers, logo designers, and other creative types share small screenshots (shots) that show their work, process, and current projects." <ref>[http://dribbble.com/site/about Dribbble - About]</ref> {{access \| date = 2023-01-04}}
	** 「專門為平面設計師和創意專業人士設立。這個網站提供了一個展示和發現創意作品的空間，涵蓋了各種設計類別，如網頁設計、品牌、動畫和插畫等。可以按顏色、標籤和時間篩選內容，方便使用者發現特定的設計風格或趨勢。Dribbble 也為設計師們提供了一個交流想法、分享作品和相互獲得靈感的空間。」Made with GPT-4 🤖		** 「專門為平面設計師和創意專業人士設立。這個網站提供了一個展示和發現創意作品的空間，涵蓋了各種設計類別，如網頁設計、品牌、動畫和插畫等。可以按顏色、標籤和時間篩選內容，方便使用者發現特定的設計風格或趨勢。Dribbble 也為設計師們提供了一個交流想法、分享作品和相互獲得靈感的空間。」Made with GPT-4 🤖
	* [http://www.webindexgallery.com/index.php CSS Galleries / Web Index Gallery]
	* [https://www.behance.net/ Behance 在线作品集]: [https://www.behance.net/search?field=132&content=projects&sort=appreciations&time=week UI/UX projects on Behance] {{access \| date = 2016-06-20}}		* [https://www.behance.net/ Behance 在线作品集]: [https://www.behance.net/search?field=132&content=projects&sort=appreciations&time=week UI/UX projects on Behance] {{access \| date = 2016-06-20}}
			** 「Adobe 旗下的創意作品集平台，涵蓋平面設計、插畫、攝影、UI/UX、動態影像等多元領域。使用者可以建立完整的專案作品集、追蹤喜愛的創作者，並依熱門程度、時間或領域篩選作品，是全球設計師展示與求職的重要平台之一。」Made with Claude 🤖
	* [http://www.site.uplabs.com/ Web design and development, Daily – SiteUp] {{access \| date = 2016-02-29}}		* [http://www.site.uplabs.com/ Web design and development, Daily – SiteUp] {{access \| date = 2016-02-29}}
			** 「每日更新的網頁設計與開發資源分享平台，內容包含 UI 素材、程式碼片段、設計靈感等，適合開發者與設計師快速獲取當日精選的實用資源與趨勢動態。」Made with Claude 🤖
	* [http://www.heyshow.com/gallery/ 設計畫廊 \| 黑秀網 HeyShow.com] {{access \| date = 2015-12-10}}		* [http://www.heyshow.com/gallery/ 設計畫廊 \| 黑秀網 HeyShow.com] {{access \| date = 2015-12-10}}
			** 「台灣早期具代表性的華文設計社群網站，畫廊區收錄插畫、平面設計、攝影等各類創作作品，讓設計師與創作者能夠展示作品集、交流創作心得，並認識台灣本地的設計圈生態。」Made with Claude 🤖
	* [http://woofeng.cn/inspiration/web/ 黄蜂网woofeng.cn] {{access \| date = 2016-09-02}}		* [http://woofeng.cn/inspiration/web/ 黄蜂网woofeng.cn] {{access \| date = 2016-09-02}}
			** 「中國的設計靈感與素材分享網站，網頁設計欄目彙整大量國內外優秀網站作品，並延伸提供平面、UI、攝影等相關教學與資源下載，是簡體中文使用者常用的設計參考站台之一。」Made with Claude 🤖
	* tool: [https://chrome.google.com/webstore/detail/panda-5-news-inspiration/haafibkemckmbknhfkiiniobjpgkebko Panda 5 \| News & Inspiration Dashboard] on {{Chrome}}		* tool: [https://chrome.google.com/webstore/detail/panda-5-news-inspiration/haafibkemckmbknhfkiiniobjpgkebko Panda 5 \| News & Inspiration Dashboard] on {{Chrome}}
			** 「一款 Chrome 瀏覽器擴充功能，將新分頁轉換為設計靈感儀表板，整合多個設計新聞與作品展示網站的最新內容，讓使用者一開啟瀏覽器就能瀏覽當日的設計趨勢與新聞。」Made with Claude 🤖
	* CodePen: Explore [https://codepen.io/tag/nav-bar Pens tagged 'nav-bar' on CodePen] or browse [https://codepen.io/chriscoyier/pens/tags Chris Coyier's tagged pens on CodePen]		* CodePen: Explore [https://codepen.io/tag/nav-bar Pens tagged 'nav-bar' on CodePen] or browse [https://codepen.io/chriscoyier/pens/tags Chris Coyier's tagged pens on CodePen]
			** 「前端開發者社群平台，讓使用者以 HTML、CSS、JavaScript 撰寫並即時預覽網頁作品（稱為 Pen）。可依標籤（如 nav-bar）搜尋特定元件的實作範例，是尋找互動效果與版面實作程式碼的實用資源。」Made with Claude 🤖
	* [https://muz.li/ Muzli - Design inspiration hub]		* [https://muz.li/ Muzli - Design inspiration hub]
			** 「以瀏覽器擴充功能形式提供的設計靈感彙整工具，自動蒐集來自各大設計網站的最新作品、文章與趨勢，並整合成單一資訊流，方便設計師隨時掌握業界動態與獲取創作靈感。」Made with Claude 🤖
	* ''$'' [https://mobbin.com/ Mobbin — UI & UX design inspiration for mobile & web apps]: Find design patterns in seconds, such as screens, UI elements, flows, and text within screenshots.		* ''$'' [https://mobbin.com/ Mobbin — UI & UX design inspiration for mobile & web apps]: Find design patterns in seconds, such as screens, UI elements, flows, and text within screenshots.
			** 「付費訂閱的 UI/UX 設計模式資料庫，收錄大量真實 App 與網站的畫面截圖，並依畫面類型、元件、使用流程等分類整理，讓設計師能快速查找特定情境（如登入、結帳）的業界實作範例。」Made with Claude 🤖
			* ''$'' [https://www.details.so/inspo The details behind the world's best websites.]
			** 「付費制的網站設計拆解分析平台，深入剖析知名網站在排版、動效、色彩與互動細節上的設計決策，適合想學習頂尖網站背後設計思維、而非僅止於視覺參考的使用者。」Made with Claude 🤖

	=== Admin UI Design Showcase ===		=== Admin UI Design Showcase ===
Line 114:		Line 123:
	{{Template:Build a website}}		{{Template:Build a website}}

	[[Category:Design]]		[[Category: Design]]
			[[Category: Revised with LLMs]]

Capacity of Email Service

Planetoid — Fri, 31 Jul 2026 03:02:23 GMT

Email服務每封郵件的檔案大小上限

← Older revision		Revision as of 11:02, 31 July 2026
(One intermediate revision by the same user not shown)
Line 6:		Line 6:
	'''建議''':		'''建議''':
	* 檔案大小 (file size) 控制在'''6-10MB''': 因為信件夾帶的檔案經過編碼([http://en.wikipedia.org/wiki/MIME MIME] encode)後，會導致檔案大小變大，所以寄信時的信件(含夾帶的檔案)檔案大小建議能控制在上限的三分之二，即6-10MB，以免被退信。		* 檔案大小 (file size) 控制在'''6-10MB''': 因為信件夾帶的檔案經過編碼([http://en.wikipedia.org/wiki/MIME MIME] encode)後，會導致檔案大小變大，所以寄信時的信件(含夾帶的檔案)檔案大小建議能控制在上限的三分之二，即6-10MB，以免被退信。
	* 超過10MB的檔案，可以考慮使用將附檔[[File compression\|壓縮]] 或放在Web、FTP、[http://en.wikipedia.org/wiki/Comparison_of_one-click_hosters 線上檔案儲存網站]、[[Snapchat of file sharing \| 閱後即焚檔案分享服務]] ex: [https://drive.google.com/ Google Drive] 單一檔案限 5TB<ref>[https://support.google.com/drive/answer/37603?hl=zh-Hant&vid=1-635756751147519182-13007898089037315163 檔案大小 - 雲端硬碟說明] {{access \| date = 2015-08-20}}</ref>, DropBox 單一檔案限2GB<ref>[https://www.dropbox.com/help/5 Dropbox 是否有檔案大小的限制或上限？ (Dropbox 說明中心)]</ref>, [http://www.mediafire.com/ MediaFire](非圖檔的單一檔案限200MB), [http://www.yousendit.com/ YouSendIt](單一檔案限100MB~~), [http://www.4shared.com/ 4shared.com](單一檔案限50MB~~)...。		* 超過10MB的檔案，可以考慮使用將附檔[[File compression\|壓縮]] 或放在Web、FTP、[http://en.wikipedia.org/wiki/Comparison_of_one-click_hosters 線上檔案儲存網站]、[[Snapchat of file sharing \| 閱後即焚檔案分享服務]] ex: [https://drive.google.com/ Google Drive] 單一檔案限 5TB<ref>[https://support.google.com/drive/answer/37603?hl=zh-Hant&vid=1-635756751147519182-13007898089037315163 檔案大小 - 雲端硬碟說明] {{access \| date = 2015-08-20}}</ref>, DropBox 單一檔案限2GB<ref>[https://www.dropbox.com/help/5 Dropbox 是否有檔案大小的限制或上限？ (Dropbox 說明中心)]</ref>, [http://www.mediafire.com/ MediaFire](非圖檔的單一檔案限200MB), [http://www.yousendit.com/ YouSendIt](單一檔案限100MB) ...。

	<div style="width:100%; min-height: .01%; overflow-x: auto;">		<div style="width:100%; min-height: .01%; overflow-x: auto;">
Line 118:		Line 118:
	* {{Gd}} [[Procedure_of_campus_event#email \| email 溝通途徑的注意事項]]		* {{Gd}} [[Procedure_of_campus_event#email \| email 溝通途徑的注意事項]]
	* [[Anti Spam Email\|防制廣告信件]]		* [[Anti Spam Email\|防制廣告信件]]
			* {{Gd}} [https://www.caniemail.com/ Can I email… Support tables for HTML and CSS in emails] {{access \| date=2026-04-24}} e.g. [https://www.caniemail.com/features/image-webp/ Can I email… webP image format]
	* [[User_agent#Mail_user_clients_.2F_Mail_user_agents \|mail user client]]		* [[User_agent#Mail_user_clients_.2F_Mail_user_agents \|mail user client]]
	* [http://en.wikipedia.org/wiki/Comparison_of_webmail_providers Comparison of webmail providers - Wikipedia, the free encyclopedia]		* [http://en.wikipedia.org/wiki/Comparison_of_webmail_providers Comparison of webmail providers - Wikipedia, the free encyclopedia]

Document converter

Planetoid — Thu, 23 Jul 2026 07:53:55 GMT

文件(Word, PPT...)轉換成Flash

← Older revision		Revision as of 15:53, 23 July 2026
Line 117:		Line 117:
	=== 文件(TXT, CSV...)轉換成Excel ===		=== 文件(TXT, CSV...)轉換成Excel ===
	[[Microsoft_Excel#Batch_convert_TXT.2FCSV_to_EXCEL \| Batch convert TXT/CSV to EXCEL]] '''可批次'''		[[Microsoft_Excel#Batch_convert_TXT.2FCSV_to_EXCEL \| Batch convert TXT/CSV to EXCEL]] '''可批次'''

	~~=== 文件(Word, PPT...)轉換成Flash ===~~
	* [http://print2flash.com/index.php Print2Flash] ([http://print2flash.com/samples/sample2.php sample]) Supported types: doc, ppt, xls, rtf, htm, html, pdf, jpg, jpeg, tif, tiff, bmp, gif, png, txt, odt, odg, odp, odf

	=== 文件轉換成圖片 ===		=== 文件轉換成圖片 ===

Accessibility

Planetoid — Tue, 21 Jul 2026 10:18:49 GMT

相關資源

← Older revision		Revision as of 18:18, 21 July 2026
Line 79:		Line 79:
	* [http://www.batol.net/index.asp 無障礙全球資訊網]		* [http://www.batol.net/index.asp 無障礙全球資訊網]
	* [https://twitter.com/bernardtyers/status/791673687707713537?s=06 Bernard Tyers on Twitter: Our @HODigital Access Needs posters have been translated into Chinese for Taiwan! Thank you @VioletVivirand on Github! #a11y #accessibility] {{access \| date = 2016-12-20}}		* [https://twitter.com/bernardtyers/status/791673687707713537?s=06 Bernard Tyers on Twitter: Our @HODigital Access Needs posters have been translated into Chinese for Taiwan! Thank you @VioletVivirand on Github! #a11y #accessibility] {{access \| date = 2016-12-20}}
			* [https://coseeing.org/ Coseeing 嶼我共視] 「透過多元形式（工具開發、部落格、推廣活動）讓大眾理解障礙者的真實需求與生活情況。目標是讓所有人都能「共同看見」世界，促進共融與理解。」 {{access \| date = 2026-07-21}}

	== 多國語言（Multilingual Support） ==		== 多國語言（Multilingual Support） ==

Boot up Tasks

Planetoid — Mon, 20 Jul 2026 02:55:53 GMT

快捷文字與自動替換文字

← Older revision		Revision as of 10:55, 20 July 2026
Line 202:		Line 202:
	* 「傳送到」[https://www.howtogeek.com/howto/windows-vista/customize-the-windows-vista-send-to-menu/ Customize the Send To Menu in Windows 10, 8, 7, or Vista]		* 「傳送到」[https://www.howtogeek.com/howto/windows-vista/customize-the-windows-vista-send-to-menu/ Customize the Send To Menu in Windows 10, 8, 7, or Vista]


			=== 自動偵測 PHP 最新版本路徑 ===
			[[Integration of CodeRunner with MAMP]]

	=== 快捷文字與自動替換文字 ===		=== 快捷文字與自動替換文字 ===

← Older revision		Revision as of 10:25, 11 August 2026
Line 118:		Line 118:
	* {{Gd}} [[Procedure_of_campus_event#email \| email 溝通途徑的注意事項]]		* {{Gd}} [[Procedure_of_campus_event#email \| email 溝通途徑的注意事項]]
	* [[Anti Spam Email\|防制廣告信件]]		* [[Anti Spam Email\|防制廣告信件]]
	* {{Gd}} [https://www.caniemail.com/ Can I email… Support tables for HTML and CSS in emails] {{access \| date=2026-04-24}} e.g. [https://www.caniemail.com/features/image-webp/ Can I email… webP image format]
	* [[User_agent#Mail_user_clients_.2F_Mail_user_agents \|mail user client]]		* [[User_agent#Mail_user_clients_.2F_Mail_user_agents \|mail user client]]
	* [http://en.wikipedia.org/wiki/Comparison_of_webmail_providers Comparison of webmail providers - Wikipedia, the free encyclopedia]		* [http://en.wikipedia.org/wiki/Comparison_of_webmail_providers Comparison of webmail providers - Wikipedia, the free encyclopedia]

← Older revision		Revision as of 15:48, 3 August 2026
(One intermediate revision by the same user not shown)
Line 75:		Line 75:
	# (optional) install {{kbd \| key =pv}} if the {{kbd \| key =pv}} was not installed for RHEL / CentOS / SL / Fedora Linux or {{kbd \| key =brew install pv}} for {{Mac}}<ref>[https://formulae.brew.sh/formula/pv pv — Homebrew Formulae]</ref>		# (optional) install {{kbd \| key =pv}} if the {{kbd \| key =pv}} was not installed for RHEL / CentOS / SL / Fedora Linux or {{kbd \| key =brew install pv}} for {{Mac}}<ref>[https://formulae.brew.sh/formula/pv pv — Homebrew Formulae]</ref>
	# (optional if the 7Zip was not installed) {{kbd \| key =yum install p7zip}} for RHEL / CentOS / SL / Fedora Linux		# (optional if the 7Zip was not installed) {{kbd \| key =yum install p7zip}} for RHEL / CentOS / SL / Fedora Linux
			'''method 1''': Import *.sql file:
	'''method 1~~''': {{Gd}} Import the compressed *.sql file with gzip (especially for BIG sql file). It will show a progress bar and estimated time to complete the mysql command:~~
	~~# Install {{kbd \| key =pv}}~~
	# Check if the file is gzip format (test the compressed file integrity) ex: (1) {{kbd \| key = <nowiki>gunzip -t database.sql.gz</nowiki>}} If not, it will return the message "gzip: database.sql.gz: not in gzip format." (2) Using [http://www.winmd5.com/ WinMD5 Free] for {{Win}} or [http://linux.die.net/man/1/md5sum md5sum] command for {{Linux}} to obtain MD5 checksum of files.
	# {{kbd \| key = <nowiki> pv database.sql.gz \| gunzip \| mysql -u username -p -h localhost --default_character_set utf8 --force DATA_BASE_NAME</nowiki>}} <ref>[http://journal.andrewloe.com/2009/05/12/pv-gzip-mysql/ pv + gzip + mysql — W. Andrew Loe III: Journal]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}
	~~# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} The console window will show ETA (Estimated Time of Arrival)~~

	~~'''method 2~~''': Import *.sql file:
	# (optional if the .sql file was compressed) {{kbd \| key =unzip data.zip}} or {{kbd \| key =gzip -d data.gz}} if the file was compressed by gzip		# (optional if the .sql file was compressed) {{kbd \| key =unzip data.zip}} or {{kbd \| key =gzip -d data.gz}} if the file was compressed by gzip
	# {{kbd \| key = <nowiki>mysql -u username -p -h localhost --default_character_set utf8 --force DATA_BASE_NAME < data.sql</nowiki>}} <ref>[http://www.cyberciti.biz/faq/import-mysql-dumpfile-sql-datafile-into-my-database/ Import MySQL Dumpfile, SQL Datafile Into My Database]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}		# {{kbd \| key = <nowiki>mysql -u username -p -h localhost --default_character_set utf8 --force DATA_BASE_NAME < data.sql</nowiki>}} <ref>[http://www.cyberciti.biz/faq/import-mysql-dumpfile-sql-datafile-into-my-database/ Import MySQL Dumpfile, SQL Datafile Into My Database]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}
	# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }}		# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }}

			'''method 2''': Import *.sql file with {{kbd \| key =--binary-mode}} (useful when the dump contains complex JSON string, binary data or BLOB fields, to avoid "\r\n" being misinterpreted and causing corrupted imports):
			# (optional if the .sql file was compressed) {{kbd \| key =unzip data.zip}} or {{kbd \| key =gzip -d data.gz}} if the file was compressed by gzip
			# {{kbd \| key = <nowiki>mysql -u username -p -h localhost --default_character_set utf8 --binary-mode --force DATA_BASE_NAME < data.sql</nowiki>}} <ref>[https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html#option_mysql_binary-mode mysql Command-Line Client Options — MySQL Reference Manual]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}
			# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} {{kbd \| key =--binary-mode}} disables all client-side conversions of {{kbd \| key =\r\n}} and treats {{kbd \| key =\0}} as a normal character, which is recommended whenever the dump was produced with {{kbd \| key =mysqldump --hex-blob}} or otherwise contains binary/BLOB content

	'''method 3''': Import the *.sql file (especially for BIG sql file). It will show a progress bar and estimated time to complete the mysql command<ref>[http://dba.stackexchange.com/questions/17367/how-can-i-monitor-the-progress-of-an-import-of-a-large-sql-file mysql - How can I monitor the progress of an import of a large .sql file? - Database Administrators Stack Exchange]</ref>:		'''method 3''': Import the *.sql file (especially for BIG sql file). It will show a progress bar and estimated time to complete the mysql command<ref>[http://dba.stackexchange.com/questions/17367/how-can-i-monitor-the-progress-of-an-import-of-a-large-sql-file mysql - How can I monitor the progress of an import of a large .sql file? - Database Administrators Stack Exchange]</ref>:
Line 92:		Line 90:
	# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} The console window will show ETA (Estimated Time of Arrival)		# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} The console window will show ETA (Estimated Time of Arrival)

	'''method 4''': Import ZIP file to MySql directly:		'''method 4''': Same as method 3, but combined with {{kbd \| key =--binary-mode}} to safely handle binary/BLOB content while showing a progress bar:
			# Install {{kbd \| key =pv}}
			# {{kbd \| key = <nowiki>pv data.sql \| mysql -u username -p -h localhost --default_character_set utf8 --binary-mode --force DATA_BASE_NAME</nowiki>}} and press {{kbd \| key = <nowiki>Enter</nowiki> }}
			# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} The console window will show ETA (Estimated Time of Arrival), and {{kbd \| key =--binary-mode}} disables all client-side conversions of {{kbd \| key =\r\n}} and treats {{kbd \| key =\0}} as a normal character, which is recommended whenever the dump was produced with {{kbd \| key =mysqldump --hex-blob}} or otherwise contains binary/BLOB content

			'''method 5''': {{Gd}} Import the compressed *.sql file with gzip (especially for BIG sql file). It will show a progress bar and estimated time to complete the mysql command:
			# Install {{kbd \| key =pv}}
			# Check if the file is gzip format (test the compressed file integrity) ex: (1) {{kbd \| key = <nowiki>gunzip -t database.sql.gz</nowiki>}} If not, it will return the message "gzip: database.sql.gz: not in gzip format." (2) Using [http://www.winmd5.com/ WinMD5 Free] for {{Win}} or [http://linux.die.net/man/1/md5sum md5sum] command for {{Linux}} to obtain MD5 checksum of files.
			# {{kbd \| key = <nowiki> pv database.sql.gz \| gunzip \| mysql -u username -p -h localhost --default_character_set utf8 --force DATA_BASE_NAME</nowiki>}} <ref>[http://journal.andrewloe.com/2009/05/12/pv-gzip-mysql/ pv + gzip + mysql — W. Andrew Loe III: Journal]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}
			# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} The console window will show ETA (Estimated Time of Arrival)

			'''method 6''': Same as method 5, but combined with {{kbd \| key =--binary-mode}} to safely handle binary/BLOB content while showing a progress bar:
			# Install {{kbd \| key =pv}}
			# Check if the file is gzip format (test the compressed file integrity) ex: (1) {{kbd \| key = <nowiki>gunzip -t database.sql.gz</nowiki>}} If not, it will return the message "gzip: database.sql.gz: not in gzip format." (2) Using [http://www.winmd5.com/ WinMD5 Free] for {{Win}} or [http://linux.die.net/man/1/md5sum md5sum] command for {{Linux}} to obtain MD5 checksum of files.
			# {{kbd \| key = <nowiki> pv database.sql.gz \| gunzip -c \| mysql -u username -p -h localhost --default_character_set utf8 --binary-mode --force DATA_BASE_NAME</nowiki>}} and press {{kbd \| key = <nowiki>Enter</nowiki> }}
			# enter {{kbd \| key = <nowiki>password</nowiki> }} and press {{kbd \| key = <nowiki>Enter</nowiki> }} The console window will show ETA (Estimated Time of Arrival), and {{kbd \| key =--binary-mode}} disables all client-side conversions of {{kbd \| key =\r\n}} and treats {{kbd \| key =\0}} as a normal character, which is recommended whenever the dump was produced with {{kbd \| key =mysqldump --hex-blob}} or otherwise contains binary/BLOB content

			'''method 7''': Import ZIP file to MySql directly:
	# Install the 7Zip		# Install the 7Zip
	# {{kbd \| key = <nowiki>7za x -so data.zip \| mysql -u username -p -h localhost --default_character_set utf8 --force DATA_BASE_NAME</nowiki>}} <ref>[http://stackoverflow.com/questions/11267309/importing-zipped-files-in-mysql-using-command-line database - Importing zipped files in Mysql using command line - Stack Overflow]</ref><ref>[http://needs-be.blogspot.tw/2011/01/install-7zip-on-centos-55.html Install 7Zip on CentOS 5.5]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}		# {{kbd \| key = <nowiki>7za x -so data.zip \| mysql -u username -p -h localhost --default_character_set utf8 --force DATA_BASE_NAME</nowiki>}} <ref>[http://stackoverflow.com/questions/11267309/importing-zipped-files-in-mysql-using-command-line database - Importing zipped files in Mysql using command line - Stack Overflow]</ref><ref>[http://needs-be.blogspot.tw/2011/01/install-7zip-on-centos-55.html Install 7Zip on CentOS 5.5]</ref> and press {{kbd \| key = <nowiki>Enter</nowiki> }}
Line 151:		Line 166:
	{{Template:Data factory flow}}		{{Template:Data factory flow}}

	[[Category:MySQL]]		[[Category: MySQL]]
	[[Category:Data Science]]		[[Category: Data Science]]
			[[Category: Revised with LLMs]]