Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 16th January 2008, 12:14
Hellbound Hellbound is offline
Senior Member
 
Join Date: Sep 2005
Posts: 116
Thanks: 4
Thanked 1 Time in 1 Post
Default mysql import zip/gzip

hi guys,

I've two problems with phpmyadmin,

first thing is the default setting in package doesn't allow importing ZIP or GZIP and I went through the whole config file inside /home/admispconfig/ispconfig/web/phpmyadmin
and yet I couldn't figure out whats wrong with thid.


the second problem is that I have increase the post size in php.ini that is for ispconfig httpd to 100MB and now it's written : (Max: 102 kKiB) in the import page but again when I import a sql file with 70MB size and each time it goes like this:


Code:
Script timeout passed, if you want to finish import, please resubmit same file and import will resume.
I'm uploading at 100MB per second so uploading must take below 60 seconds but it goes to time out...


Please help me... thanks
Reply With Quote
Sponsored Links
  #2  
Old 17th January 2008, 09:18
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,976
Thanks: 825
Thanked 5,369 Times in 4,216 Posts
Default

Quote:
first thing is the default setting in package doesn't allow importing ZIP or GZIP and I went through the whole config file inside /home/admispconfig/ispconfig/web/phpmyadmin and yet I couldn't figure out whats wrong with thid.
The PHP that comes with ISPConfig does not support zip files.

Quote:
I'm uploading at 100MB per second so uploading must take below 60 seconds but it goes to time out...
phpmyadmin is not a good solution to import large database dumps. You should import them from the shell with the mysql command. Exapmple:

mysql -u yourusername -p < thesqldump.sql
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
Hellbound (17th January 2008)
  #3  
Old 17th January 2008, 10:30
Hellbound Hellbound is offline
Senior Member
 
Join Date: Sep 2005
Posts: 116
Thanks: 4
Thanked 1 Time in 1 Post
Default

Hi,

First Thanks for the reply, I appreciate it.

I can't give access to my clients to use mysql to import their databases.
at the other hand the gzip of this file is less than 10MB.

how can I recompile php that comes with ispconfig with something that supports ZIP and GZIP?

thanks
Reply With Quote
  #4  
Old 17th January 2008, 10:42
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,976
Thanks: 825
Thanked 5,369 Times in 4,216 Posts
Default

Quote:
I can't give access to my clients to use mysql to import their databases. at the other hand the gzip of this file is less than 10MB.
I guess this does not matter in this case as phpmyadmin has to uncompress the file before it is imported and ths number of sql satmements is the same and the timeout appears during import of the statements as you posted above that the upload itself took only a short time.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 17th January 2008, 10:55
Hellbound Hellbound is offline
Senior Member
 
Join Date: Sep 2005
Posts: 116
Thanks: 4
Thanked 1 Time in 1 Post
Default

You might be right but how can I compile to accept ZIP or GZIP anyway?

thanks
Reply With Quote
  #6  
Old 17th January 2008, 16:29
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Take a look at the compile script in install_ispconfig/compile_aps. There's a section where PHP gets compiled. You'd have to modify the ./configure string. To leran what configuration options are available, you can download the PHP source code from php.net, unpack it, go to the source directory and run
Code:
./configure --help
__________________
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
The Following User Says Thank You to falko For This Useful Post:
Hellbound (17th January 2008)
  #7  
Old 17th January 2008, 18:46
Hellbound Hellbound is offline
Senior Member
 
Join Date: Sep 2005
Posts: 116
Thanks: 4
Thanked 1 Time in 1 Post
Default

any reason why zip/gzip was taken out from php?

thanks
Reply With Quote
  #8  
Old 17th January 2008, 18:51
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,976
Thanks: 825
Thanked 5,369 Times in 4,216 Posts
Default

ISPConfig does not need it and it will cause a additional dependency.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #9  
Old 30th January 2008, 13:22
Hellbound Hellbound is offline
Senior Member
 
Join Date: Sep 2005
Posts: 116
Thanks: 4
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by till
ISPConfig does not need it and it will cause a additional dependency.

is it the same reason that ispconfig WEB FTP does not have compress/decompress or zip or unzip?

how can we add it?


Thanks
Reply With Quote
  #10  
Old 30th January 2008, 13:30
Hellbound Hellbound is offline
Senior Member
 
Join Date: Sep 2005
Posts: 116
Thanks: 4
Thanked 1 Time in 1 Post
 
Default

Quote:
Originally Posted by till
ISPConfig does not need it and it will cause a additional dependency.

is it the same reason that ispconfig WEB FTP does not have compress/decompress or zip or unzip?

how can we add it?


Thanks
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
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
import mysql data - specifiy charset adam Installation/Configuration 1 16th September 2006 23:30
cant import mysql databse nowe warrior Installation/Configuration 1 7th September 2006 20:42
mySQL import issues palkat General 1 14th May 2006 15:56
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 20:13.


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