How to upload a big SQL file

Discussion in 'Tips/Tricks/Mods' started by AngelDrago, Feb 1, 2009.

  1. AngelDrago

    AngelDrago Member

    Hello Everyone how do i overcome this problem with out using remote tools... what i like to use is phpmyadmin...

    this is the error message i'm getting..
    You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

    thank you..
  2. Antennipasi

    Antennipasi ISPConfig Developer ISPConfig Developer

    one have to edit php.ini values to increase limits. in my install i have couple developers who prefers also phpmyadmin, and i have increased values like this:

    in /etc/php5/apache2/php.ini:
    max_execution_time = 60     ; Maximum execution time of each script, in seconds (def. 30)
    max_input_time = 90 ; Maximum amount of time each script may spend parsing request data (def. 60)
    memory_limit = 128M      ; Maximum amount of memory a script may consume (def. 128mb)
    upload_max_filesize = 16M ; Maximum allowed size for uploaded files. (def. 2mb)
    post_max_size = 16M ; (def. 8mb)
    don't forget to reload apache after modify. those are quite big numbers, one should adjust them to fit to demands.
  3. falko

    falko Super Moderator ISPConfig Developer

  4. make-fun

    make-fun Member

    You could also look into a phpMyAdmin config option.
    Have a look at your
    phpmyadmin/ (and for info phpmyadmin/
     * web-server upload directory
    $cfg['UploadDir']   = ''; // [B]Directory for uploaded files[/B] that can be executed by
                              // phpMyAdmin. For example './upload'. Leave empty for
                              // no upload directory support
    You should be careful and evaluate who is using phpmyadmin.
    Customizing this file, so user can upload only within their allowed path maybe an option…

    Directory where SQL files can be uploaded by means other than phpMyAdmin (for example with FTP).
    This allows file import even if file uploads are disabled in php.ini. For example './upload'.
    Leave empty for no upload directory support. Use %u for username inclusion.
    Note: the dropdown file select field is only shown after a file was successfully uploaded.
    $cfg['UploadDir'] = '';
    Last edited: Feb 3, 2009
  5. khubab1

    khubab1 New Member

Share This Page