Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Tips/Tricks/Mods

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 1st February 2009, 07:37
AngelDrago AngelDrago is offline
Senior Member
 
Join Date: Sep 2005
Location: Florida -- USA
Posts: 100
Thanks: 4
Thanked 0 Times in 0 Posts
Default 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..
__________________
Danke für Ihre Hilfe
AngelDrago
Reply With Quote
Sponsored Links
  #2  
Old 1st February 2009, 11:27
Antennipasi Antennipasi is offline
ISPConfig Developer
 
Join Date: Dec 2008
Location: Finland
Posts: 67
Thanks: 6
Thanked 13 Times in 12 Posts
Default

Quote:
Originally Posted by AngelDrago View Post
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.
Reply With Quote
  #3  
Old 2nd February 2009, 12:57
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
Default

If it's a very big SQL file, it's probably easier to try this:
http://www.howtoforge.com/faq/6_4_en.html
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #4  
Old 4th February 2009, 00:21
make-fun make-fun is offline
Member
 
Join Date: Jan 2008
Posts: 92
Thanks: 8
Thanked 8 Times in 7 Posts
Default

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']   = ''; // Directory for uploaded files 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'] = '';

Last edited by make-fun; 4th February 2009 at 00:29.
Reply With Quote
  #5  
Old 28th August 2009, 17:46
khubab1 khubab1 is offline
Junior Member
 
Join Date: Aug 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

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

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Chroot SSH + ISPConfig Norman Installation/Configuration 27 26th March 2007 04:40
PHP error chrno Installation/Configuration 2 7th September 2006 14:27
[ISPconfig Install] Cannot allocate memory Cordoban Installation/Configuration 3 25th August 2006 14:20
Howto suggestion suse PhP ver 4 + Ver 5 wwparrish Suggest HOWTO 11 7th August 2006 14:29
ISPConfig faiture glt50 Installation/Configuration 16 6th July 2006 02:58


All times are GMT +2. The time now is 16:42.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.