Hope its in correct section.

A long story but will try keep it as brief as I can, I googled for answers but still unsure?

I run a forum with a bloated database of approx 135mb

Used to be with a host who oversold space which to often lost connection with DB.

Moved approx 3/4months ago, to what was a more stable host and uploaded ver 4 MySQL database, took an age to implement due to size

Mid part of last week I get 'cannot connect to database' error page.

Contact new host as no coding/database work had gone on before error occurred.

Error is still same after lengthy time delays an cryptic responses from support, I find out my server now only has ver 5 MySQL. They inform me as though its been same since account started.
My forums been connecting fine last three months and the account has option to create MySQL version 4 db??

Awaiting a response to pin them down on the played out mystery tour, but think I may need to upgrade to ver 5 MySQL.

Just in case it comes to this (lookin more an more like moving this fat database maybe on the cards again in near future), has anyone got basics or simple way to upgrade a version 4 database to v5?

What do you mean you have to upgrade to version 5?

What forum software are you using. For the most part MySQL 5 is backwards compatible with version 4.

Isn't there something about having to enable old style password support when you upgrade to MySQL 5 or was that upgrading to V4?

Its phpBB ver 2.0.23

This is last couple of ticket updates from support:

Support
Thank you for contacting Technical Support regarding this issue. In regards to the issue with this matter, as linux hosting accounts cannot use MySQL 4 due to the fact they are only enabled for MySQL 5 as they are using PHP 5. You would need to use a MySQL 5 database. Please let me know if you have any additional questions regarding this matter. Thank you for your continued partnership, we appreciate you working with us.

My reply
Hi,

The forum using MySQL version 4 has been running on the eNom server for approx three months until the latest server issue cause this problem.

There are two options on my account when starting a database on the server via control panel, one for DB version 4 and the other for DB version 5 (please check).

I thought it was accounts using windows server that only had version 5 available which is reason why I opened an account using linux?

This has gone on now for nearly a week and is still unresolved, can you check your information with your supervisor as it seems incorrect and please remedy this issue.

Thanks

Support
Thank you for contacting Technical Support regarding this issue. In regards to the issue with this matter, unfortunately as our linux hosting is not using PHP 4 you would be unable to use MySQL 4 with this hosting account. If you will notice by visiting http://z'''.org.uk/test/php/test.php that we are in fact using PHP 5 only on this web server. Also if you notice by visiting http://z'''.org.uk/mysqlcheck.php which I have created in your account, setup with a MySQL 5 database this is in fact connecting properly. Please let me know if you have any additional questions regarding this matter. Thank you for your continued partnership, we appreciate you working with us.

My reply
Hi,

Please can you explain a couple of things to me concerning the account.

Why is there an option to create a version 4 MySQL database in my control panel?

After I created the version 4 database on my server approx 3 months ago why was it working fine until last week?

Thanks

Have you tried connecting to your database from the MySQL command line client? If you try that and are getting errors, this tells you it's a server-side problem (possibly authentication, or user limits, or something similar) and your hosting company should be able to provide assistance assuming they're managing the database server. If that works fine, it's likely something that has changed on the client side in your forum software.

Does it give anymore info? And are you using pconnect or something? That may be disabled.

I know some basics with MySQL i.e. copying, uploading ;) and some varied PHPMyAdmin editing.

How would I check connection with command line client?

Just got this response from support:

Thank you for contacting Technical Support regarding this issue. In regards to the issue with this matter, this is due to the fact you have access to all of our MySQL databases. You can use these databases on other servers if you would like as they are not designed only to work with your hosting account. Please let me know if you have any additional questions regarding this matter. Thank you for your continued partnership, we appreciate you working with us.

Regards,

???

Well that would be in your script's connection code mysql_connect vs mysql_pconnect or do you get it in phpmyadmin too, that would indeed be weird. And that support reply seems besides the question. Is it a shared hosting account?

Did they recompile PHP to use the new MySQL libraries?

Yes, a shared account,

You'll have to give me some of these checks in a play by play mode, as I've not had need/experiance checkin this before

Had a brief look at mysql_connect vs mysql_pconnect via google and not sure what to make of it? The articles seem a bit dated, but one seems to overload server?

After your replys, just keyed this message to support:

Hi,

I'm sorry but you seem to have lost me a little on some response's? I have to try to understand? Are you saying I'm given the option to create a ver 4 mysql database on my account which you are now informing me is a privilege of use, not part of my account which I originally opted for due to having mysql 4 use included in account details when first purchasing?

Has something changed on the account/server since I opened account i.e. MySQL version 4 use has been withdrawn recently?

Has some sort of limit been imposed on the account since signing up i.e. limits on support or database size/use?

I've been informed version 5 is backward compatible and also asked to check if PHP has been recompiled to use the new MySQL libraries?

If this problem is due to database version being changed on the account, what is required to remedy the issue i.e. if database needs upgrading, what’s the company’s procedure/policy?

Thanks
Sean

Best to see what they say first I guess, if you can't connect to phpmyadmin I don't think it'll have much to do with the db though. The db selection comes after logging in, either in phpmyadmin and normal code. So the issue is probably on their side somewhere.

I can see and open all versions of MySQL database's via phpmyadmin, in a mysql section via my control panel account there's two phpmyadmin options one for version 4 the other for 5.

Quickest response I've had to date from support :eek:

Thank you for contacting Technical Support regarding this issue. In regards to the issue with this matter, while PHP 5 may be backward compatible with PHP code, you will in fact need to use a MySQL 5 database for use with your website. In regards to previously using your MySQL 4 database, you may be able to backup this MySQL database using PHPMyAdmin then restoring this in a MySQL 5 database. Please let me know if you have any additional questions regarding this matter. Thank you for your continued partnership, we appreciate you working with us.

Alot of questions left unanswered, I don't believe there expecting me to reupload this size of database, took me two days last time!

You should ask them to do it for you, you can upload it a lot faster through command line. Though you could possibly copy it throughmysql itself, not sure if that works well between versions though.

I asked an this is reply I got:
Me asking:
Hi,

When I uploaded the database it took me three whole days due to time limits imposed on server when trying to upload large files, it had to be broken down into many segments.

If you switch off the limits imposed on server uploads I could attempt to do this again.

Otherwise its probably easier for this to be done via support, keeping the original version 4 database for now and make a copy into version 5 db using same password. If working ok I'll delete version 4 at a later date.

Thanks

Support decline:
Hello,

Thank you for contacting Technical Support regarding this issue. In regards to the issue with this matter, unfortunately there is no way for us to do this since these are on different database servers. The best way to do this would be for you to export and import the database. I apologize for the inconvenience, Please let me know if you have any additional questions regarding this matter. Thank you for your continued partnership, we appreciate you working with us.

Regards,

I'm not sure what support can and can't do via servers, but I would have thought this was no great task and achievable?

WHY haven't you switched hosts yet? It's obvious they're not going to help you here. Dump your databases, back up your files, and run. Any host worth anything will import your database via shell for you.
Kevin

Say "Wouldn't it be possible for the system admin to manually import it if I upload the sql file and send you the url to avoid extra work." Though I guess it may not do any good anymore. :/ kcackler may have a good point here I guess. :p Us poor nice webhosts seem to do the bad web hosts job in support. :/ Though I'm guessing this is either a reseller who doesn't know what to do, a support person that only knows the normal cases and doesn't have any further access or a very lazy person.

I agree with what your saying guys, trouble is I paid the next three month term just before this occured. I opened shared server account with eNom so its eNom support that are dealing with issue.

Thanks for the offer to upload file, I've just sent following if that don't get result I may offer your suggestion?
Hi,

I feel you/eNom should shoulder some of the blame concerning this issue.

My account had no mention that I could not use MySQL 4 database. Neither was I informed that MySQL 4 was no longer in use on my account.

My 600+ forum members have been without access to the community for well over a week now.

I think the least that can be done is to copy the database over to MySQL 5 on the other server. I feel certain a large company such as eNom would have the resources and infrastructure to do this medial task.

You're hosting with your domain registrar? There's your problem.

Look - Just write this down as an experience and a loss. Move to a reputable host who will go the extra mile to please you. Upload the SQL dump file to your webspace and contact support to import it for you (if you don't have shell access to do it yourself)

There is nothing any of us can do here. If enom won't help you, you're just wasting your time.

Kevin

Just realised I misunderstood your ealier suggestion :blush: :stickout:

Exporting db as I type, looks like move maybe most likely option way this has panned out.

Well I meant send that to them. :/ I'd upload for you if I could but only they can do it. But yes they've probably just hired people who know a few base responses and have some documents on the rest. They may not even know what SSH is. If you mention it maybe they will go bother someone though. But inded even if you stay you'll be stuck with that support, though you may not need it again. It's probably safer to just go somewhere safe and knowing though. When you look for a new one, make sure they aren't overselling and possibly ask them a few questions before signing up to make sure they know what they're doing.

Not long since host change which makes it harder accepting searching around for deals again :eek:

Appreciate all the advice guys even if wasn't all 100% understood by me ;) thanks for time !

Update:

Last desperate request from me:
Could you please give me eNoms CEO email address.

Then next couple of hours forum connects again via database ver 4 and is still working ???

Then this reply from support:
Thank you for contacting Technical Support regarding this issue. In regards to the issue with this matter, unfortunately I am unable to provide the information you have requested. Please let me know if you have any additional questions regarding this matter. Thank you for your continued partnership, we appreciate you working with us.

My reply:
Hi,

The forum came back online the other day via database ver 4 and is still online.

Unfortunately I've had to gain more info due to this issue via forum/s setup for hosting services on the net.

The care and service I got in this ticket has probably not helped eNoms shared account reputaion ?

Thanks

How do these guys get these jobs or manage to keep them???

With a large enough customer base the amount of customers they lose due to that doesn't beat how much they save on professionals. A lot of people just stick to basics and ask the same questions so :/. And about the email I'm not sure if you'll be able to contact him. Whois results give info2@enom.com, other contact info will get you back to support probably. Not sure if you can get higher without going through them, maybe someone else has an idea?