Phpmyadmin Maxfile Size Change
Jul 6, 2009we can import dataabse with phpmyadmin files which size is under 8meg
how can we change it for example to 50meg
we can import dataabse with phpmyadmin files which size is under 8meg
how can we change it for example to 50meg
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 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
CentOS 6.6
Plesk 12.0.18
64-bit
At some point, not sure when, PHPMyAdmin's (as accessed through the admin panel by clicking on a customer, manage hosting, databases, etc) permissions have changed such that I cannot view, edit or add MySQL routines/procedures. This appears to have occurred system-wide, though I have not checked every database on the server.
Is there a fix to get the permissions set so that I can make these changes again?
One of our resellers has an account.. When looking into cpanel, it says that that account is using 3300megs. When we go into the ftp of that account, in reality it is only using 1.3megs. This is a huge difference! Most of folders are empty.
We are using the latest version of WHM and Cpanel.
I have a client on a dedicated IP, today we needed to downgrade the web hosting plan. As the web hosting plan puts users on a default shared IP, this plan change also changed the dedicated IP to the shared one causing some propagation issues for a small period of time.
I have contacted WHMCS about this asking if they had a way of changing the clients plan but keeping the IP address intact as this could lead to some very undesirable outcomes. They explained that it is not their fault and to contact Parallels.
I know I can change the plan directly in Plesk however by initiating the plan change via WHMCS, everything is automated.
Has anyone helped clients transition from one domain to another? Maybe dissolving a partnership or renaming their company... so a new domain name has been registered and a new website created.
2 Issues:
#1 Using .htaccess 301 redirect
We used the following command line in their old website's htaccess file
Redirect 301 / [url]
The goal was to get people try to visit any page of their old website (i.e. OldWebsite.com/contact.html) redirected to their new website (i.e. NewWebsite.com/contact.html). Isn't that supposed to change the address bar's URL, too? For some reason, I visit their old site and I seem to be redirected to their new website but the address bar still has their old domain name? Something is going on???
#2 Having their new company name for 2 years now. People can enter her new company name in Google, MSN or Yahoo. Her new company name appears in the search results but has the old domain name associated with it. We are trying to get rid of any reference to that old domain name? What's the easiest way to do this? So what people see in search engines is:
New Company
Short Meta Description
www.OldDomain.com
What steps did I miss in this transition?
What steps do I have to take on their old website/old web server to control it's appearance on search engines and make sure people get to the new website?
as you know we can use followins to back up db
1- HMS [(hosting Managemen Script = cPanel / Plesk/vDeck]
2-phpmyadmin adn 3.th party script
3-SSH/Telnet
but why db size is differrent after backing-up?
db in server is for example 120MB
When i use SSH to back up db is 75MB
// // phpmyadin-------------120 mb
HMS ---------------------110MB
what size stripe size people are using on their web servers on their raid setups?
Larger, or smaller considering the nature of web based files being smaller.
I am hosting 80 domains on a dedicated server which is dishing up only about 80GB per month in bandwidth. Disk space is minimal at under 20GB. Sites are mostly PHP5 and MySQL. Some Perl. Using apache2.
Right now the server is a dual Opteron and it seems to be overkill for the job at hand. In an effort to lower my monthly cost I am wondering how small of a server I can go with and still allow some margin for only minimal growth.
Dare I go as small as one of these (from cheapest to most $):
1.7 Pentium 4 and 512 RAM, IDE
Athlon 3000+ and 1GB RAM, SATA
2.8 Pentium D and 1GB RAM, SATA
Used chirpy's method
/etc/init.d/chkservd stop
/etc/init.d/mysql stop
umount /var/tmp
umount /tmp
replace "256000" "512000" -- /scripts/securetmp
rm /usr/tmpDSK
/scripts/securetmp --auto
cd /tmp
ln -s /var/lib/mysql/mysql.sock
/etc/init.d/mysql start
/etc/init.d/chkservd start
df
Problem
[root@host ~]# umount /tmp
umount: /tmp: device is busy
umount: /tmp: device is busy
[root@cmee34 ~]# lsof | grep /tmp
sshd 6650 root 9u unix 0xf57fe300 24988 /tmp/ssh-SDVLUi6650/agent.6650
If I killall -9 sshd, I got obviously logged out of ssh. I need to make /tmp 1GB instead of the current 500MB it is now.
I seem to be hitting the tcpsndbuf max size occasionally, my host says they can not change it (there is plenty of free ram) and if I want it raised, I need to upgrade to a larger plan.
Was just curious as to what kind of tcpsndbuf size you guys have on your VPS plans?
I have an issue of overload on my server running just a wordpress blog. I described my problem here :p=5384916
my website is situated on a folder named xxxx/public_html/
Now I discovered a folder named logs. its path is xxxx/logs
there is 2 files on it:
access.log ( 19 GB )
and error.log ( 31 Mb )
is it a relationship between my server overload and my access.log big size?
I have never been to a datacenter. My friend has a rack at a datacenter near my house so he will be able to provide me some space for a monthly payment. At first I thought of getting a 1U server but it ended up costing too much and a hassle to find the proper sized parts. Now I have decided to go with a mini tower instead so I was wondering whether it would make a difference if I were to use a mini tower or a larger sized tower. If I used a mini would I be able to fit more computers or would it not make a difference?
View 14 Replies View RelatedSo I got the dedicated server.
Now, when I upload files to my server, some files upload fine but most upload but with 0 file size. That's weird. What can cause this? I used 3 FTP clients same results also no passive mode..
I manage a high traffic website on one of my dedicated servers. It currently serves around 2 million uniques/mo.
In time, due to page changes, around 200 important URIs got a redirect [L,R=301] in the main .htaccess file that's sitting on the root directory.
Redirects are in the form of : person/J/James_Blake_2000/ --> /user/James_Blake/
Thus, the .htaccess file has reached well above 200 lines.
I would like to kindly ask for advice: should I limit the dimension of this htaccess file ?
How do you guys treat these permanent redirects?
how to have full size images in my DH (dreamhost) gallery2?
View 2 Replies View Relatedwhat kind of bandwidth i need and what kind of space i need for a site that experiences about 25000 hits a month and file size of about 700mb. the site is purely content and images and correspondence is done by forms.
i dont want to go to big but also dont want to under size my customer as uptime and speed is important (im looking at dedicated servers)
I own a parenting site, mid-sized I think (1100 members). We were recently "fired" by our host for server load. Sooo, I'm in the market for a new host. I'm so gun shy right now, because everyone is reassuring me they can handle us, but then so did the company that we're currently with.
Specs:
Phpbb3 software
Bandwith - 17.7gb so far this month
Disk Space - 111.3 mb this month
There are an average of 100 members on line at a time. I've been told we need a dedicated server by some, though I don't think we're big enough at this venture for one, and it's out of our budget. I realize the things I listed above don't have much to do with server load, but I figured I'd share anyway.
I uploaded my file to web server(html, image file and css file), but strangely after uploaded it to server all file that I uploaded size 0 KB. I uploaded it using WS FTP.
Is there something wrong the way I uploaded it.
i think it's an apache problem, but whenever i download something from my server via http, i get unknown file size when downloading. it's not a big problem, but it's kind of annoying.
does anyone know why it's doing this?
how big I should set the cache size for eaccelerator?
Here's the information from the control.php
Caching enabled yes
Optimizer enabled yes
Memory usage 100.00% (16.00MB/ 16.00MB)
Free memory 0.00MB
Cached scripts 148
Removed scripts 0
Cached keys 0
I send an email and check size on Exim queue, is 5.3 Kb
When I receive on my client I check the size and is 11 Kb
There is a only 1 image that is linked (not embedded) and have a sike 8133 byte. Image is online.
11Kb-7,94Kb=3.06Kb
Size is different.. why ?
I have a database which is growing to have about 100 tables. These tables will grow in size and sometime I will need to use RAID 5, I am told by my server provider.
My questions are:-
1. if these other servers are mirrors, should I have the database stored on each server?
2. when one server gets too busy, does the RAID query a lesser-used server so as not to bog down the first one?
3. Or, do I need to have different content in each db on each server so a query gets what it needs form each?
Right now APC shm_size is set to30 and since I am only using about 20% of the RAM in VPS, I thought it would be best to increase it a bit. Now how do I go about doing that?
View 2 Replies View RelatedIs it possible to add another hard-drive and attach it to increase the size of the /home directory?
Beginning to run out of space.
I wanted to add a maximum file size limit of 10mb to all files uploaded via cpanel, php scripts or ftp.
I am currently running cpanel and whm on a linux server.
how i can do this. (i have root access)
I mounted sda2 as var and its size is 2GB. I wanna to increase its size to 4GB,which command should i run without umount and mount it again?
View 2 Replies View RelatedStable C2D Board - ANY size - Needs working lan
I need a stable C2D board that works with linux and lan. I was thinking of a Intel G965 board but I heard that chipset isn't supported in linux?
Building a mid tower for a colo.
Using Apache 2.0.52 + PHP 4.3.10 on Linux (Fedora Core 2), I get this
error message when accesing my PHP page:
---------------
Service Unavailable - Zero size object
The server is temporarily unable to service your request. Please try
again later.
Reference #15.21eaaad4.1173400585.294a7ed8
---------------
I fixed it by restarting Apache, but I'd like to know the reason of this error. Does anybody have any experience with this issue?