Loading...

.sql檔過大無法匯入phpMyAdmin

Temperature: 0 °C

ChungChung
修改phpMyAdmin資料夾中的config.inc.php檔。
打開後找到下列兩行或自行加入:

$cfg['UploadDir'] = 'ImportSQLFile';  ←上傳資料夾的名稱
$cfg['SaveDir'] = 'ExportSQLFile';       ←匯出資料夾的名稱

然後在phpmyadmin中建立ImportSQLFile與ExportSQLFile資料夾,
一個用來上傳大容量的sql檔,一個用來匯出sql檔。
把需要匯入的大容量sql檔以winscp上傳到ImportSQLFile資料夾中,
再回到phpmyadmin載入介面,
就會發現在載入檔案的地方多出web server upload directory的功能。
此時僅需要選擇剛剛傳進去的SQL檔就可以輕鬆匯入了!
https://innstory.com/story-sql檔過大無法匯入phpMyAdmin-139

Prev
 招集令Yessir

Next
JavaScript_檢查_Radio_Button 

About the Author

Chung

我是chung
網路工作者
主業是網站系統開發建置
副業是做夢,寫故事
作品請參考/teme.biz
做夢請參考/innstory.com
聯絡/chung.teme@gmail.com

#有人用筆寫日記,有人用歲月寫日記,有人用照片寫日記,而我,用innstory寫日記。

Visitor message

Leave some footprints to prove that you visited me

Recommended reading

Author's other related stories

動態留言功能調整

動態留言功能調整

guestmap 最近改進了朋友動態的發文方式.... 一開始在功能方面加上了...

php函式紀錄

php函式紀錄

常常忘記,只得紀錄下來...... AddSlashes: 字符串加入斜線。...

PHP網路爬蟲之抓取Open Graph(OG) Meta tags

PHP網路爬蟲之抓取Open Graph(OG) Meta tags

用google爬了很多文章.... 最後終於找到一篇內容..... 只是測試了半天.....

Please select an option

error

Hi, thank you for your participation, but you cannot vote repeatedly~

Join innstory now and start recording your story.

"Innstory" is a place to store stories. We are committed to becoming a warm platform. Deepening the bonds between people is our direction.
We are convinced that the blockchain between people is not just a cold calculation. Join us now.

Wrong format