Plesk 11.x / Linux :: Increase Import Database Size
May 4, 2015
I have a virtual server with CentOS 6.4 (Final) and Plesk 11.5.30 and I would like to increase the database size to import because right now it's only 2MB and I have to put online a website with 10MB.
I'm running Plesk 12. I install it today, using the ISO which parallels provides, which includes centos 6.5 and preinstalled Plesk 12 in my vps. Then I logged in plesk, and I did everything it wants. Then I upgraded my php, to php 5.4.36 according to the manual that Paralells provides, and then I tried to increase the max upload file size for phpmyadmin. I have edited my /usr/local/psa/admin/conf/php.ini file and tried to restart using with 3 different ways using terminal:
1st: service sw-cp-server restart 2st: /etc/init.d/psa stop /etc/init.d/psa start 3st: reboot (which rebooted all the vps)
My php.ini file is:
short_open_tag = On y2k_compliance = Off output_buffering = Off max_execution_time = 600 max_input_time = 600 memory_limit = 256M max_file_uploads = 99999 max_input_vars = 2000
[Code] ....
However, when I'm trying to import a 31mb sql file, I always get that error, and only some of my tables are being imported:
#1153 - Got a packet bigger than 'max_allowed_packet' bytes
I am trying to import a database I have however I cannot get it working for the last 2 hours!
I have tried various commands like logging into mysql entering the "use" command to use a database and then variations of the "source" command but my db.sql file doesn't run.
Also tried the full command
mysql -uroot -pMYPASS MYDBNAME < /var/www/site/db.sql
I've created a website for a client using Sitefinity CMS and MS SQL Server 2008 R2. I've transferred the database from my local SQL server to the production server using SQL Management Studio.
I've created a customer and subscription for hosting the website and it's all up and running perfectly. However, I want to automate the backup of the SQL database for the website which I can only do if the subscription knows about the SQL database for that website. So, how do I associate the two? How do I get the database to show up in plesk for that customer such that it can be part of the scheduled backups - and of course also somethign I could restore via plesk if I had too?
The database exists. It wasn't create via plesk in any way, but I want plesk to be able to back it up, and ideally for it to show up in the customers subscription, etc.
Since we upgraded to Plesk 11.5 or (I'm not shure) the last Update 12, user can not import MySQL-Databases anymore.
If the user open phpMyAdmin for import and select the database and click on Ok, phpMyAdmin does nothing.
I heard that could be a problem with JQUERY and I checked the files in ParallelsadminhtdocsdomainsdatabasesphpMyAdminjsjquery and all files seems to be there.
Only if I check the source of the phpMyAdmin Import-Website it seems, there is a problem with jquery-1.6.2+fix-9521.js.
But how I can fix this problem for all Windows-Servers.
I currently am running on a VPS and I'm trying to edit the max size a user can upload through phpMyAdmin. I have tried editing the php.ini file located at /etc/php.ini to find it wasn't the right file.
Where do I need to go via SSH to edit the proper file?
I'm trying to perform SSO to my application. for my login i get an error "Size of a request header field exceeds server limit". I believe the header size got increased then the limit set in apache server. I'm guessing so.
the flow of request: Apache -> tomcat -> SAP Business Objects.
For my colleagues login the SSO works fine with out issue.
So, how to increase the HTTP header size. I'm bridging apache and tomcat using AJP connector. below is the AJP connector parameters in server.xml
Chrome/Chromium don't offer to "remember this password" if using https with a self signed, or no, certificate, which is pretty frustrating when your job requires regular logins to various Plesk installations!
The trick, apparently, is to import your self signed certificates into Chrome's chrome://settings/certificates list, so I'm trying to do this with Plesk's default panel certificate.
From Tools & Settings -> SSL Certificates, I've hit the 'Download the Panel's SSL Certificate' link to get the .pem file but when I import this into Chrome I'm asked to provide the password it was encrypted with. Where would I find this password? Or do I need to replace the default with my own self-signed?
We have too many DNS servers such as BIND, PowerDNS, NSD on different platform.I need transfer all zones to Plsek server.Is there a ready-made solution import dns zones using axfr?
why, or when this happened, but all of a sudden the PHP Memory Limit for all of my domains is 64M? I used to have it set to 128. How to change this setting so that all domains have the ability to go to 128M ?
I did not try editing last_httpd.include as it was recommended that this was not edited in the post above.
Is there something I am missing!
The Parallels version is 11.0.9 on Linux. It is a VPS package. Is it possible that the host is not allowing the increase or is it all down to my setup?
I am trying to increase the PHP memory limit for all Plesk hosted sites.
I've updated the 'memory_limit' setting in /etc/php.ini
Then I ran
Code: /usr/local/psa/admin/sbin/httpdmng --reconfigure-all /usr/local/psa/admin/sbin/httpdmng --reconfigure-server Checking a phpinfo() page on hosted sites I see that this setting has not been effective.
Checking some /var/www/vhosts/system/domain.com/etc/php.ini also shows the old setting, and I can see that these files have not been updated.
I note that all these domain php.ini files have been modified earlier today, all at the same time, so presumably some process did regenerate them earlier. All these files hae the "DO NOT MODIFY ..." heading
I realise that I can go the the domain in Plesk GUI and save the PHP settings to force an update, but is there anyway to force the regeneration of all of these files via CLI?
MICROUPDATE : 11.5.30 Update #47, last updated at June 11, 2014 03:26 AM
OPERATING SYSTEM : CentOS 6.5 (Final)
PROBLEM DESCRIPTION ------------------------------- Need to increase round cube attachment size
STEPS TO REPRODUCE ----------------------------------
i need to increase round cube attachment size. i'm unable to find installation folder. How to increase attachment size
ACTUAL RESULT ----------------------- Attachment size should be less than 5MB
EXPECTED RESULT ----------------------------------- Attachment size allows upto 50MB
ANY ADDITIONAL INFORMATION -------------------------------------------------------------- increased size in Tools & Settings > Server-Wide Mail Settings > Maximum message size
I have one subscription that shows incorrect statistics for the log file size. In the statistics pane it reports 130MB, while on the server in the /var/www/vhosts/domain/logs I only see 1.7MB.
Are there any other locations where logs are kept that are included in the statistics?