SQL Too Large
Apr 5, 2007
I'm having a lengthy issue where my databases are to large to import in phpmyadmin using plesk. Unfortunately I dont have direct access to phpmyadmin and can only access it by DB user through plesk.
I have tried to edit php.ini in the following locations:
upload_max_filesize = changed this to 64M
post_max_size = changed this to 32M
maximum_execution_time = changed this to 300
maximum_input_time = changed this to 300
Why am I still not able to import my DB's which are about 8MB each?
View 4 Replies
ADVERTISEMENT
Oct 2, 2009
what type of hosting do use big sites like Deviantart, or any kind of site with a lot of Gb or Tb. and how much it costs?
View 7 Replies
View Related
May 20, 2008
I have a website which has about 20K users, and now I am using VPS plan at LunarPages.
However, I have encountered a trouble of out-of-memory. Although I have configured my Apache and MySQL carefully, the 512M memory is not enough. Therefore, the users' expirence is not good these days because my site is very unstable.
I contacted Lunarpages, asking them whether I can upgrade my VPS to bigger RAM, but they said the ONLY way to get a RAM bigger than 512M is to upgrade to dedicated hosting plan.
The following are some stats of my website:
Total Members: 20k
Online at the same time: max 600, average 300
The Lunarpages VPS plan:
www[dot]lunarpages[dot]com/virtual-private-server/
disk space: 20G
RAM: 512M
price: $42 / mo
Now I am not sure whether to migrate to didicated hosting plan, because currently, the main problem is just the size of RAM. Other resources e.g (CPU, network etc. ) are not my bottleneck. So I think it seems not worthwhile for me to migrate to the dedicated hosting plan with a doubled price (even more, almost 3x if I need 1G RAM), just for a larger size of RAM.
Can you guys give some suggestions to choose a VPS provider for my site?
The factors taken into my consideration include:
* RAM size: at least (1G for peak, 768M garantee). The bigger, the better. Nice if can choose larger size when needed.
* price
* bandwidth: 1T/mon?
* easy to upgrade to dedicated host: just in case that one day I will have to use dedicated.
* whether there are coupons for a lower price.
View 9 Replies
View Related
May 22, 2007
I've been with zone.net for a couple months now, and I have a guaranteed 512MB of memory, which I seem to constantly be hitting, which seems to result in processes being killed and http access vanishing. Growing quite annoying.
I'm looking into moving onto a new provider that can provide more guaranteed RAM for about the same price.
Space isn't a huge deal, I'd do fine with a meager 5GB. Bandwidth I need at least 200GB, but wouldn't mind more.
I'd like to stay managed if possible, as I'm not as well versed in server workings as I should be. Also am in need of cPanel, which I know is a spendy sucker.
My budget is something around $70 a month, and I don't really want to go much higher than that. Still a poor college boy :/
Can anyone suggest such a provider? I've browsed around a lot of the VPS hosts but can't seem to find one that has as much RAM as I need for a decent price. All the ones that seem to have 512MB+ are pretty expensive, and offer a lot more other stuff (space/bandwidth) than I need.
As a final note, the line speed isn't that big of a deal. I'm currently on a 3mbit and am surviving, but going back to a higher speed line would be great
View 11 Replies
View Related
Jan 17, 2007
Just had a quick question about backing up a large MySQL DB. I have a database that is 50gb with about half a billion entries in it. One table itself is about 40gb, the other 10gb consists of smaller tables.
The problem is, I want to back the database up and be able to keep it LIVE at the same time (as it will fall behind quickly if it's pulled for more than a few hours, as there are somewhere in the area of a million entries an hour, plus other deletions and queries).
View 3 Replies
View Related
May 30, 2007
I'm currently using iptables to ban IP addresses from the servers, like:
Code:
iptables -A INPUT -s xxx.xxx.xxx.xxx -j DROP
I ran a "spam trap" for the last few months and now I have over 11000 IP addresses who were trying to spam on my website (guestbooks, phpBB and forms) and I want to ban them all (pretty sure bots run from them).
My question - is iptables the way to do it? I mean does banning such a large number of addresses have any significant performance or other issues I should be aware of (except of the fact I may be banning some legitimate traffic)? Is the -A INPUT the way to ban them all or is there a more appropriate way of baning such a number of addresses?
I'm on CentOS 4.5 i686, Apache/1.3.37, Pentium D 930, 2GB RAM.
View 11 Replies
View Related
Feb 2, 2008
I wasn't sure where to post this so here goes, I need to migrate a MySQL DB, in the past I have just created an SQL file and used that method (sometimes having to split the SQL file up) but now the DB is about 50 meg and 733,233 records.
Is there an easier way to migrate the Database from one server to another?
View 8 Replies
View Related
Apr 5, 2009
I'm trying to find a server that can offer about 7-8 TB with 6-8 GB of ram. Does anyone know a good provider?
View 14 Replies
View Related
Mar 28, 2009
any recommendation for a good e-mail service (IMAP) for large accounts? between 5 and 10GB each?
View 13 Replies
View Related
Mar 9, 2009
I'm selling downloads of music files. The zip files are quite large. I've had several people complain that they get a message that the server resets their connection before the download finishes.
What can I do to allow these large downloads?
I'm on IIS.
View 21 Replies
View Related
Jul 9, 2009
I have a large directory which I want to copy to another account on the same server. Its 1 folder which contains 20000+ files and its around 2GB in size.
I used:
Quote:
cp -r /home/useraccount/public_html/foldername /home/useraccount2/public_html
It worked but some of the files didn't transfer correctly,
View 11 Replies
View Related
Jul 1, 2009
Does anyone know any shared hosting or semi-private VPS hosting for a site with large MS SQL2005 DB? Our DB is currently 1GB already but could get up to 5-10GB when all is said and done. The site is a B2B networking platform with many users, company profiles, products, etc.
View 3 Replies
View Related
Feb 9, 2009
I have a website that is approx 50GB, that I essentially would like to take offline for a while. Obviously, while the site is offline, I don't want to be paying for my server.
Can anyone let me know of some options to "store" this mammoth of a site. Downloading it locally is not an option, so it needs to stay in the cloud for the lowest possible price.
View 7 Replies
View Related
Jun 18, 2009
to delete and reset the domlogs files from Apache server, as they have become too large, but I want to keep a record of the past few years website stats.
I could download the domlogs files (they look like MS-DOS applications) but once I have I am not sure how to read them, is there some off server application that could open these files? I currently view stats in awstats from cPanel, but the size of the files is causing problems with updating now.
The only thing I can think of doing is taking screenshots of the relevant stats that I want to keep, before deleting the files, but was thinking there must be a better solution than that.
View 5 Replies
View Related
Nov 7, 2008
Linux Fedora 6, Apache 2 with Mod Security, MySQL.
Our mod_sec logs get incredibly large very quickly. In the configuration for mod_security, we have specified logging options as
SecAuditEngine RelevantOnly
SecAuditLogRelevantStatus "^[45]"
but the mod_sec.log gets to almost 10 GB (in a matter of 5-6 days) before it is truncated to mod_sec.log.1 and a new one is created.
Is there a way we can specify that a max size of one log file is 1 GB, for example?
Or another question, how come it gets so huge so quickly? We thought that logging "RelevantOnly" will only display errors / requests that are deemed security risks.
View 2 Replies
View Related
Oct 6, 2008
I have a customer who wants to sell access to videos of conferences he runs.
Each flv vid is approx 1 - 1 1/2 hors long approx 380MB each and there will be about 12 videos per conference.
approx 4 - 8 conferences per year.
My customer suggests 10 - 20 people will buy access to watch each video.
Access to watch the videos will be through a password protected webpage.
issue - the current site hosting company only allow uploads up to 150MB per file.
Can I host the flash videos elsewhere and deliver them through the password protected web page without anyone else being able to see them via server they are hosted on?
This would also reduce the bandwidth going through his current site server.
View 14 Replies
View Related
Apr 4, 2008
I have several gigs worth of data which my programmer wants to put into MS SQL 2005. But the last time I check, MS SQL comes in blocks of only a few MB (eg 200MB for $25).
Now if I have 10GB of data, that yould cost me like...thousands?).
One solution is to use mysql which is free of course, but the website is done in ASP.NET. How will this affect performance?
Also, is there any other way which I can purchase SQL 2005 myself? If yes, how much for one domain name?
View 12 Replies
View Related
Aug 27, 2008
I would like to have around 100 Gb with room to expand if possible.
This will be hosting for a radio station, archival material.
I am unsure of where to look, the sites I have seen are pretty small in scale as far as capacity.
Further, I would also like to be able to re-sell this, instead of just setting up a straight account.
Further if at all possible I would like to bundled with some other small hosting packages (wordpress sites) on a reselling basis.
View 10 Replies
View Related
Jul 29, 2008
My client's website needs to hold files that are around 60 or 70 MB. The host only allows files up to 10 MB. Is that typical?
Right now I'm linking to a file storage but would rather make the files available from my site without going to a 3rd Party Site. He doesn't want to zip his files either - just to be a straight download.
View 7 Replies
View Related
Jul 7, 2008
I am trying to locate what large file are filling up the / on the server but I am having trouble using the find command to do this.
View 1 Replies
View Related
Oct 19, 2008
I couldn't find a suitable category for this topic, please feel free to move if I made a mistake.
I have a big website.
MySQL Size: 1 GB
Diskspace: 2 GB
It's over loading the server, so I am moving it to a dedicated server.
In the past, basically I would pause the live website (e.g. turn off forum). Move the data, turn everything back on in the new server and then change the nameservers.
But for this website, I don't want to pause the website nor I wish to loose any posts because of DNS propagation. (e.g. user might post data, which is stored in the current server. But then after propagation, the user won't see his post)
View 13 Replies
View Related
Jul 4, 2008
My server is running WHM 11.15.0 cPanel 11.18.6-S24739 /
REDHAT Enterprise 4 i686 on standard.
I am using EXIM.
Lately, users on my server have not been able to receive most attachments. E-mails with small attachments, such as an 11,000 byte file, show up just fine. An e-mail from the same person, but with a 560,000 byte attachment will simply never show up, and there is no returned "bounce" message to the sender. It is like the e-mail was never sent.
The odd thing is, e-mails sent to and from e-mail addresses hosted on my server have no trouble sending/receiving large attachments of any size (I have tested up to several megs in size). For example, tom@example.com and joe@another_example.com both have their domains hosted on my server. They can send each other large attachments with no trouble. But, if tom@yahoo.com or tom@gmail.com tries to send a larger attachment to tom@example.com, the e-mail and the attachment never show up.
Things to note:
1) The e-mail accounts are no-where near their storage limits.
2) message_size_limit is not set, so I assume the max attachment limit is the default 50mb.
View 0 Replies
View Related
Mar 28, 2008
I have a situation here.
I wanted to transfer a file (about 10GB) from one server to another server. Both server are on the same LAN.
Inside server1, I zipped a folder as file.tar.gz
From server2, I uses wget http://server1.com/file.tar.gz and it says "404 Not Found"
I suspect it won't allow me to download because the file is too big.
View 7 Replies
View Related
Jan 31, 2007
to transfer a MySQL database with way over 1 million rows to a different server.
What is the best way to do this without losing any data? I've tried using the export feature in phpMyAdmin but it doesn't seem to handle it very well.
There has to be a feature in WHM or cPanel,
View 2 Replies
View Related
Dec 5, 2007
I’ve to buy two new chassis for our redundant storage system. I decided to build my own system.
I looked around to find a good chassis which we can use for the next 3-5 years, the supermicro chassis seems to be the right one. I planed to use a 3Ware Raid Controller with 12x 500GB SATA-II drives in an Raid 6 Array, mirrored with DRBD to a second, identical, system. The System boots from an own Raid Array (Raid 5) with 3 x 120GB Discs on an separate 3Ware Raid Controller.
Now the question is, which chassis, I don’t know if it is better to fit the drives vertically or not.
Here the two chassis:
[url]
[url]
View 0 Replies
View Related
Jun 14, 2007
Does anyone know who has large space, or 15+ racks available in 55/56 Marietta?
View 10 Replies
View Related
May 23, 2008
We're considering deploying a large server that will have 8x 500GB drives in a RAID-10 config. I intend to use a 3ware 9650SE w/ BBU along with A/B power to each of the PSU's.
My question is... since this will return into a 2TB array/partition, in event of a crash (kernel panic, etc -- I expect a power outage will be very, very rare if at all) what do you guys think the fsck time would be? In my experience a RAID BBU significantly drops it, sometimes to the point of no manual fsck required, but in event of a manual fsck shouldn't the BBU be able to provide more consistent data (less errors) and therefore a much shorter fsck? Maybe just recovering the journal?
View 14 Replies
View Related
Jun 6, 2007
I started tracking and collecting information about every page load on my site, which made the DB grow very fast. In 24 hours I had over 1.4 million INSERTs, so the DB will grow by over 170MB/day. The inserts so far didnt affect the performance of the server (dual clovertown, 4gb ram, SCSI HD), but at this rate the DB will grow by over 5GB per month. Is it a good idea to let the DB grow to those sizes? Would it affect performance if a table had several 10s of millions of rows? Public doesnt run any SELECT/UPDATE queries on that table, only admin does (me).
View 14 Replies
View Related
May 23, 2007
to move a site to another server at another datacentre that have approx 100 GB of media files.
Typically for small sites i am able to use server to server ftp to move files.
However, when moving large site like this, ftp might be disconnected and lost track of which files are not transferred.
How can i transfer/move the files (server to server) and resume if disconnected?
View 12 Replies
View Related
Oct 3, 2007
I want to copy a 5GB mysql database, but don't want to dump and then import it again since it will take long time.
Alternatively, I am thinking of copying the directory of the database using the CP command.
First, I will close the forums from the control panel.. then I will use this command:
cp -rp /var/lib/mysql/mydatabase /var/lib/mysql/mydatabase_copy
View 11 Replies
View Related
Feb 20, 2007
Clients have been complaining that when they try to send large attachments they are not getting through.
They keep getting failure messages saying the server was interrupted and the message could not be sent.
Is there any settings that I can change to allow larger attachments go through?
Its a Cpanel server with Exim
View 3 Replies
View Related
