sql問題載入

a20080001

我要上傳備 份檔的時候發生了這件事情我該怎麼辦?
他說的文件,我貼在下面
1.16 I cannot upload big dump files (memory, HTTP or timeout problems). Starting with version 2.7.0, the import engine has been re–written and these problems should not occur. If possible, upgrade your phpMyAdmin to the latest version to take advantage of the new import features.
The first things to check (or ask your host provider to check) are the values of upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP. One user also said that post_max_size and memory_limit need to be larger than upload_max_filesize.

There exist several workarounds if your upload is too big or your hosting provider is unwilling to change the settings:

• Look at the $cfg['UploadDir'] feature. This allows one to upload a file to the server via scp, ftp, or your favorite file transfer method. PhpMyAdmin is then able to import the files from the temporary directory. More information is available in the Configuration section of this document.
• Using a utility (such as BigDump) to split the files before uploading. We cannot support this or any third party applications, but are aware of users having success with it.
• If you have shell (command line) access, use MySQL to import the files directly. You can do this by issuing the "source" command from within MySQL: source filename.sql.

這篇就是她說的,我不知道該怎麼改容量限制..
我的輩分檔容量是10mb

lendlice0001

#1
換別的備份管理軟體不就行了
連改都不用改...

就算你文章看不懂 google 翻譯就有了

a20080001

不是備份管理的問題
是上傳檔案容量限制
我是用AppServ 2.5.9

bn5656

你ragnarok 的資料庫 呢
沒備份地方 要導入 當然 有限制

a20080001

lendlice0001

I cannot upload big dump files (memory, HTTP or timeout problems).
我不能上傳大轉儲文件（內存， HTTP或超時問題） 。
Starting with version 2.7.0, the import engine has been re–written and these problems should not occur.
從版本2.7.0 ，匯入系統已經重寫及這些問題應該不會出現。
If possible, upgrade your phpMyAdmin to the latest version to take advantage of the new import features.
如果可能的話，您的phpMyAdmin升級到最新版本，以利用新的匯入功能。
The first things to check (or ask your host provider to check) are the values of upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file.
第一件檢查的事（或請您的主機供應商檢查）是檢查 'upload_max_filesize' 、'memory_limit' 和 'post_max_size' 在 php.ini 配置文件中的值。
All of these three settings limit the maximum size of data that can be submitted and handled by PHP.
所有這三個設置限制的最大尺寸的數據，可提出和處理的PHP 。
One user also said that post_max_size and memory_limit need to be larger than upload_max_filesize.
一個使用者也表示 'post_max_size' 和 'memory_limit' 必須大於 'upload_max_filesize'。
There exist several workarounds if your upload is too big or your hosting provider is unwilling to change the settings:
存在著幾個變通方法，如果您的上載過大，或您的託管服務提供商不願意更改設置：
Look at the $cfg['UploadDir'] feature.
看看 $cfg['UploadDir'] 作用
This allows one to upload a file to the server via scp, ftp, or your favorite file transfer method.
這允許一個上傳文件到服務器，經由 SCP、 FTP、或您喜愛的方式傳輸文件。
PhpMyAdmin is then able to import the files from the temporary directory.
然後 PhpMyAdmin 就可以從臨時目錄中匯入文件。
More information is available in the Configuration section of this document.
更多信息可在配置節本文件。
Using a utility (such as BigDump) to split the files before uploading.
使用工具（如BigDump ）在上傳之前分割文件。
We cannot support this or any third party applications, but are aware of users having success with it.
我們不能支援這一或任何第三方應用程序，但都知道使用者已成功的解決此問題。
If you have shell (command line) access, use MySQL to import the files directly.
如果您有shell （命令行）存取，使用MySQL直接匯入文件。
You can do this by issuing the "source" command from within MySQL: source filename.sql.
為此，您可以通過發放“源文件”命令，在MySQL的：來源filename.sql 。