How to upload a big SQL file

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..

 

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:

Code:

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.

 

If it's a very big SQL file, it's probably easier to try this:
http://www.howtoforge.com/faq/6_4_en.html

 

You could also look into a phpMyAdmin config option.
Have a look at your

Code:

phpmyadmin/config.inc.php (and for info phpmyadmin/config.sample.inc.php)

Code:

/**
 * 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…

Edit:

Code:

UploadDir

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'] = '';

 

Hi, Kindly read very usefull article for huge sql data uploading at http://www.nobleatom.com