This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

SQL too big
#1
SQL too big
[Image: 457c3d00db040994dd33bd910a119e1a.png]

only tried to import a db that is 49.56 mb into phpmyadmin.

Just asking where I can change my upload file size limit or do I have to ask my host to do that
Reply
Thanks given by:
#2
RE: SQL too big
edit this problem is now solved but now it says this:
New SSO module and IP whitelist/blacklist - Got a packet bigger than 'max_allowed_packet' bytes
Reply
Thanks given by:
#3
RE: SQL too big
http://lmgtfy.com/?q=max_allowed_packet
Reply
Thanks given by:
#4
RE: SQL too big
I changed it to 10000m but still not big enough
Reply
Thanks given by:
#5
RE: SQL too big
For databases larger than 10mb it is suggested to use something like http://www.ozerov.de/bigdump/ or similar rather than change your server upload max size settings.
-TGates - Project Council

SEARCH the Forums or read theĀ DOCUMENTATION before posting!
Support Sentora and Donate: HERE

Find my support or modules useful? Donate to TGates HERE
Developers and code testers needed!
Contact TGates for more information
Reply
Thanks given by:
#6
RE: SQL too big
Edit the lines of your php.ini, as follows:
Code:
upload_max_filesize = 128M
post_max_size = 128M
max_execution_time = 120
max_input_time = -1
memory_limit = 128M
Or as needed.
Reply
Thanks given by:


Forum Jump:


Users browsing this thread: 3 Guest(s)