LiteSpeed Technologies
Download Download     Blog Blog     Wiki Wiki     Forum Forum     Store     Contact Contact    

Go Back   LiteSpeed Support Forums > LiteSpeed Web Server > Install/Configuration > phpmyadmin database backup error

Reply
 
Thread Tools Display Modes
  #1  
Old 11-09-2008, 04:15 PM
ASTRAPI ASTRAPI is offline
Senior Member
 
Join Date: Oct 2008
Posts: 78
Smile phpmyadmin database backup error

Hi

I am trying to backup my database and it always stop at 15 or 23 mb's

I use mysql40 and ,add if not exists and ,complete inserts and ,at the end gzipped.

With apache is ok and i don't get any error message in litespeed.
Reply With Quote
  #2  
Old 11-09-2008, 05:19 PM
mistwang mistwang is offline
LiteSpeed Staff
 
Join Date: May 2003
Location: New Jersey
Posts: 7,585
http://www.litespeedtech.com/docs/we...maxDynRespSize
Reply With Quote
  #3  
Old 11-09-2008, 05:21 PM
ASTRAPI ASTRAPI is offline
Senior Member
 
Join Date: Oct 2008
Posts: 78
Can you give me more easy to do info please?

What i must change to what?

Also dows this setting efect my forum speed or anything else?

Thanks

Last edited by ASTRAPI; 11-09-2008 at 05:28 PM..
Reply With Quote
  #4  
Old 11-09-2008, 05:30 PM
anewday anewday is offline
Senior Member
 
Join Date: Nov 2007
Location: New York
Posts: 723
Change Dynamic Response Body Size to the value of the size of the database. It will not affect the forum speed. You can just change it back after backing up the database.
Reply With Quote
  #5  
Old 11-09-2008, 05:30 PM
mistwang mistwang is offline
LiteSpeed Staff
 
Join Date: May 2003
Location: New Jersey
Posts: 7,585
You can increase it to whatever value to make sure it large enough.
It does not affect your forum speed.
Reply With Quote
  #6  
Old 11-09-2008, 05:31 PM
ASTRAPI ASTRAPI is offline
Senior Member
 
Join Date: Oct 2008
Posts: 78
Thank you
Reply With Quote
  #7  
Old 11-09-2008, 05:32 PM
anewday anewday is offline
Senior Member
 
Join Date: Nov 2007
Location: New York
Posts: 723
I beat George to it.
Reply With Quote
  #8  
Old 11-09-2008, 05:56 PM
ASTRAPI ASTRAPI is offline
Senior Member
 
Join Date: Oct 2008
Posts: 78
My database is 34mb gunzipped now ...

About 250 mb uncompressed.

So what is a good setting for this?

And also when i have to change the setting again?

Thanks
Reply With Quote
  #9  
Old 11-10-2008, 01:51 PM
mistwang mistwang is offline
LiteSpeed Staff
 
Join Date: May 2003
Location: New Jersey
Posts: 7,585
Just increase it to a number large enough and you will not hit for a long while.
If you dump the DB in Gzipped format, 100mb should be enough,
if in uncompressed format, 400mb should be good.
Reply With Quote
  #10  
Old 11-11-2008, 06:01 PM
ASTRAPI ASTRAPI is offline
Senior Member
 
Join Date: Oct 2008
Posts: 78
where is this setting?
Reply With Quote
Reply

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


All times are GMT -7. The time now is 03:40 PM.



- Archive - Top
© Copyright 2003-2011 LiteSpeed Technologies, Inc. All rights reserved. Privacy Policy.