Hostgator And InnoDB
Sep 27, 2008
I finally found a shopping cart that I think will fit my needs. I registered a hosting account with Hostgator a couple months ago so that I'm now out of the refund period. It's great for my Wordpress site, but I got an error when I tried to install LiveCart. It said that I need InnoDB. I contacted Hostgator's support, and they said that they don't support InnoDB. Is that true? I don't want to have to move hosts and be out my year of hosting fees.
View 6 Replies
ADVERTISEMENT
Jun 3, 2009
I would like something similar to the business package located here:
http://www.hostgator.com/shared.shtml
But I do NOT want HG, too many bad experiences.
My only requirements are...
-No more than $15/mo
-Unlimited domains
-At least 100GB of bandwidth a month
-Supports PHP
-Some type of control panel (preferably cpanel)
Any suggestions are GREATLY appreciated.
View 14 Replies
View Related
Jun 29, 2009
how to enable innodb
use this command in mysql ....
View 4 Replies
View Related
Feb 11, 2008
What is more suitable for shared web hosting?
View 8 Replies
View Related
Jun 5, 2007
Question for people who have moved to InnoDB: I wonder if it is worthwhile?
I don't care about ACID compliance, my only interest is in the row level locking which I do not get with large MYISAM tables which do table locking and clog up everything. I have a huge database that needs frequent updates, like 50,000 per hour. I also don't care about InnoDB's large size of indexes and such, I have lots of hard disk to throw at it.
My fear is with the backup of InnoDB tables, and the fact that it is not as simple to "fire up" the tables when I restart the database. MySQL manual suggests something like a query to "Warm up" the tables.
Any thoughts would be great, and if possible, any help with what settings you use. FYI, I am on a 4GB RAM machine with dual Core2Duo procs. When I tried the following in my.cnf for the InnoDB stuff ---
Code:
#skip-innodb
innodb_buffer_pool_size=1G
# Set the log file size to about 25% of the buffer pool size
innodb_log_file_size=250M
innodb_log_buffer_size=8M
innodb_data_file_path=/idbdata1:200M:autoextend
innodb_additional_mem_pool_size=20M
innodb_log_group_home_dir = /iblogs
innodb_log_files_in_group = 2
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=10
--- the MySQLD wouldn't start! Question about the stuff in red: what're those paths for?
Do I need to create those paths?
View 6 Replies
View Related
Feb 25, 2008
It was recommended by my software vendor that I use MyISAM and stay away from InnoDB.
InnoDB is the default storage engine on my box, but I have no InnoDB's at this time.
Everything says MyISAM (in phpMyAdmin). Could I just reinstall SQL (with MyISAM) from scratch? Or will I need to backup and reload from dump?
View 6 Replies
View Related
Jun 12, 2008
I'm getting ready to setup a dedicated server for a site that is database intensive that mostly uses mysql innodb databases.
What is the best setup for me that would allow regular database backups of my innodb databases the easiest way possible. I basically want to be able to backup my database at a regular interval (probably weekly) without having to think too much (and without having to shut down my server each time or stop my database).
I'm not too tech savvy with database management so am after tips on:
- Best server setup (second drive just for bakups?)
- I Don't fully understand RAID 1 setups and how they would benefit me
- Explain to me the backup process for any solution you suggest
View 9 Replies
View Related
Jan 6, 2007
MySQL didn't work well on my server so I had a look at the err file. It indicates that MySQL is getting started and stopped all the time. After it has started it will stop and then start again etc:
070106 14:40:25 InnoDB: Started; log sequence number 5 959534492
/usr/sbin/mysqld: ready for connections.
Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Communi$
A mysqld process already exists at Sat Jan 6 14:40:28 CST 2007
070106 14:40:38 [Note] /usr/sbin/mysqld: Normal shutdown
070106 14:40:38 [ERROR] /usr/sbin/mysqld: Sort aborted
070106 14:40:40 InnoDB: Starting shutdown...
070106 14:40:41 InnoDB: Shutdown completed; log sequence number 5 959534492
070106 14:40:41 [Note] /usr/sbin/mysqld: Shutdown complete
070106 14:40:42 mysqld ended
070106 14:40:42 mysqld started
070106 14:40:42 InnoDB: Started; log sequence number 5 959534492
View 4 Replies
View Related
Sep 18, 2014
I've been with my Strato VServer and it installed Plesk on Linux a big problem.
I coming no longer in the Plesk Dashboard and the following code appears:
Syntax error or access violation: 1286 Unknown table engine 'InnoDB'
Here are the contents of my my.cnf
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
[Code] .....
View 8 Replies
View Related
Nov 2, 2014
I am using Parallels Plesk Panel v. 11.0.9 on a V-Server provided by Strato (Germany), the OS is Ubuntu 10.04 LTS. Established and running under Plesk is a MySQL-Database, administered via Plesk by PHPMyAdmin 3.5.8.1. PHPMyAdmin offers the following information:
Datenbank-Server
Server: Localhost via UNIX socket
Software: MySQL
Software-Version: 5.1.41-3ubuntu12.10 - (Ubuntu)
Protokoll-Version: 10
Benutzer: admin@localhost
Server Zeichensatz: UTF-8 Unicode (utf8)
Webserver
sw-cp-server
Datenbank-Client Version: libmysql - mysqlnd 5.0.8-dev - 20102224 - $Id: 731e5b87ba42146a687c29995d2dfd8b4e40b325 $
PHP-Erweiterung: mysql
Click to expand...
View 3 Replies
View Related
Sep 3, 2008
At work, at home, and a couple of associates are with Hostgator on their reseller plans.
My employer's account with Hostgator... in about two years we only ever had one major problem. We wanted to change the primary domain and so the support boys and girls at HG did that for us. We then had a huge problem with propagation, and some of the packages didn't transfer over. That saga took about five days or so to fix but was pleased with the eventual outcome.
We had a mediocre problem about a year back when all of the websites under our reseller had crappy response times for about a week... something about a dictionary attack on the server I think. After that was fixed everything was fine.
A few times Hostgator support helped me out when they didn't have to... many many times they went a little further to help me solve a problem, and a couple of times very promptly helped me fix a problem I'd created which would have got me fired had it not been done fast.
Some people complain about Hostgator response times to support tickets. I simply did not have a problem with that... they always got back to me within 2-6 hours. When I couldn't wait that long (which only happened a handful of times), I submitted a ticket by email, then got on the phone or live chat, and they very helpfully escalated the priority.
I haven't had any memorable problems with my personal reseller account with them the whole time I've been at Hostgator.
Their support is very very good... Brent seems to be the driving force behind the desire to be the best, and the fact that he's very well off yet still goes on to the support forums and is actively involved semi-frequently goes to the ethic of the company as a whole.
They DO go over and above - at least they have for me.
Recently, I was banned from their support forums permanently.. you can read about my side of the story at ryanpaul.ca.
Even after what I think was a unfair ban from their forum, I'm still perfectly happy to keep my business with them, as well as my employer's... and will still be referring people to them. Why? Because their service is undeniably splendid.
View 14 Replies
View Related
Jun 22, 2006
I am posting looking for anyone who is or has hosted with hostgator.com.
I am looking to move a site to their service that handles around 150,000 pageviews a month and was hoping I could get some input from actual users of hostgator.com. I want to do the basic shared hosting plan.
View 8 Replies
View Related
Feb 22, 2009
I experienced a problem with Hostgator servers where IE6 seems to cause problems and the response from Hostgator was sort of "They don't care and people must upgrade to IE7"
The problem is that on other servers several installations of a particular hosting BILLING system works 100% fine but with two separate installations on separate Hostgator servers the following happens.
With IE6
1) Get a BLANK page regardless whether file in public or admin was called and the page only show if you click GO in url bar.
2) Refresh page don't help and page stays blank until click on Go (in other words you can click refresh till you are blue in the face, the page stays blank. You MUST every time click on GO for a page to be displayed - All links or submit buttons gives a blank page)
3) With such blank pages the "View Source" option however give the complete and correct page up to the last </html>
View 14 Replies
View Related
Nov 1, 2009
is hostgator start a vps planes?
View 6 Replies
View Related
Apr 12, 2008
Do you guys like hostgator.com and are there similar or better options?
View 14 Replies
View Related
Apr 20, 2008
I was messing around today and found this:
host-gator.com (see http://whois.domaintools.com/host-gator.com for whois information)
This is a complete rip of HostGator's site and appears to be done by HostMonster. Anyone else notice this?
View 14 Replies
View Related
Feb 23, 2008
HostGator's website publishes $7.95 for the Baby plan; but on the order page this is $9.95. Is this what others are experiencing as well?
View 12 Replies
View Related
Jul 13, 2005
I'm a newbie and trying to figure out which host to use. I'm going to have about 20 different sites all with different names. I think i've narrowed it down to either 1and1 for $9.99/mo(2gis/50gigs) or Hostgator for $9.95(5gigs/75gigs) both with no setup fee.
Does anyone have experience whem either??or other recommendations.
View 19 Replies
View Related
Jan 1, 2009
See folks I want to run a forum and I have decided to either use Hostgator or 1and1 hosting.
Which was is better if I want to host a forum with members no more of 1000 or so?
What is there MySqL Database limit?
View 14 Replies
View Related
Jan 15, 2008
My opinion: Do NOT EVEN CONSIDER using HOSTGATOR.
My experience:
I signed up for their hosting on Sunday morning and completed payment for the first month using hostgators online payment system and paypal.
The payment was accepted and confirmed. An email was sent some time later confirming the account had been set up.
The email specified a user ID for cpanel as well as nameservers which I used to point two of my domains at the new hostgator account.
I used cpanel and FTP to set up the add-on domain, create some email accounts and upload content for the two domains (the same content as on the old servers which should now be shown k-free.co.uk and offshoreharry.com).
All appeared to work fine with no problems. I could use outlook to access email and the web sites were available on the new server (the old server was down).
A day and a half later, I WAS HORRIFIED TO SEE
- the emails accounts could not be accessed
- the cpanel user did not work
- Hostgator did not email me or attempt to contact me in any way to tell me there was an issue. (they had my valid mobile phone number - there are no unidentified calls in the period concerned).
- the web sites that had been pointed at hoistgator were showing a suspended message and spammy hostgator context ads. My non-spam mostly non-ads content had been uploaded to the hostgator account.
One of those domains is freeware software on a site with ZERO ADS that has never been moneterised and sometimes gets 100's of uniques a day.
HOSTGATOR WAS STEALING TRAFFIC FROM MY ad free unmonetized site and showing a nasty spammy ad page.
Not only was I rather angry but also amazed that any company would ever do this. Just think how you would feel if all your sites - pages were hijacked and showing some of the nasty ad pages.
My opinion: Do NOT EVEN CONSIDER using HOSTGATOR.
Checking my yahoo email, there was no email from hostgator saying my account had been suspended (if I hadn't checked it they would have continued stealing the traffic until I noticed).
The only email from hostgator was a request for a copy of my passport or utility bill! I am left wondering if they are really a front for an identity theft scam? I am rather unhappy that they have even my name - address - tel no - paypal email.
I obviously immediately changed the nameservers on the two domains back to the old servers. But since nameserver changes take upto 72 hours to fully propogator, hostgator could still be stealing some of my traffic now. The two sites contain nothing that any T+C I have ever seen would have any reason whatsoever to see as a problem. The two sites are k-free.co.uk and offshoreharry.com for anyone here who wishes to verify this claim.
Hostgator COULD be showing my content instead of their spammy ads - I uploaded it.
Hostgator was mentioned by a few on here and I thought them to be a big company who have a reputation to protect. Are you guys really comfortable with a company who behaves like this. Will they suddenly suspend your sites tomorrow and steal your traffic until you happen to notice?
I have requested to them that they provide access TO MY PERSONAL AND BUSINESS EMAILS on the email accounts I set up. I would also like any log data that was collected. I will report back here what the response to that (politely worded) request is. Giving me access to any email and log data that they have effectively kidnapped-stolen hardly makes amends for the wrong they have already done. Like any other victim of a common thief I may just have to accept that I lost something and will not see it again.
Additionally, search engine robots may have visited the sites and got 404s, any users who dropped by will certainly not be back, the damage caused is ongoing and difficult to fully quantify.
Hostgator did not email me or attempt to contact me (they had my valid mobile phone number). They did not tell me why the account was suspended and the trafic STOLEN. I have had web sites for 4-5 years and have never been involved in anything remotely dubious on the web. You can judge for yourself if there is any reason for them to do this [sites offshoreharry.com, k-free.co.uk]. I had sent at most 10 emails whilst testing the 3 or 4 email accounts I was creating.
Obviously I will never use hostgator or any related company.
My opinion: Do NOT EVEN CONSIDER using HOSTGATOR ... EVER.
View 21 Replies
View Related