Put MySql online

[huayangw]

I created a MySql database and try to use PHP to connect to the web site. At last, my provider, Eearlink, told me that they don't support MySql database. What shall I do? I really don't want to start it over again.
Thank you very much for your idea!

Eric

[Birdman]

Welcome yo Webmaster World!

What shall I do?

Simply get a different hosting provider which does support MySQL/PHP/PERL. You can find VERY CHEAP shared hosting these days. I know of one that costs less than a dollar a month!

Regards,
Birdman

[huayangw]

Thank for your reply!
Is it possible to transfer to another provider and stay the same domain name, because we have more than 1000 members.
Thanks again!

Eric

[storevalley]

Is it possible to transfer to another provider and stay the same domain name

This shouldn't be a problem if you own the domain.

[Birdman]

Yes, it's possible but before you do that, let me ask you:

Do they offer any kind of database options?

What server side languages can you use? (eg. PHP,ASP,PERL)

The reason I ask is because there is a possibility of slipping in the search engine rankings after making a move to another ip address. I think the consensus is, "it's safe" but I still would avoid it if possible. Of course there are times where you must make a move.

Another option is to get another host just for your MySQL database and connect to it from your original host.

[storevalley]

The reason I ask is because there is a possibility of slipping in the search engine rankings after making a move to another ip address.

There is?

I have moved a reasonable number of domains from host to host and seen no issues with any of them search engine wise.

Do you have solid evidence to the contrary, Birdman?

Not trying to be provocative here ... I am genuinely interested ...

[huayangw]

Thank you for your suggestions, Birdman!
I will use PHP to connect to the server.

Do you have any good ISP on thought?
If I change the provider, what shall I do to avoind search engine problem?

Thanks!

[Birdman]

No, I don't have any evidence.

I guess my point really was "If it isn't broke, don't fix it". I know I don't like the idea of moving any sites that enjoy good rankings and traffic.

I do believe it's safe to move domains if done properly but I don't want to test that theory unless it's absolutely needed.

Birdman

[storevalley]

I guess my point really was "If it isn't broke, don't fix it". I know I don't like the idea of moving any sites that enjoy good rankings and traffic

I understand where you are coming from, Birdman :)

huayangw ... moving the domain is pretty straightforward. This is the way I normally do it ...

• Request control of the domain via a service that allows you to manage its DNS settings (you may already have this sorted)

• Order your new web space from a hosting company (one that supports MySQL). Tell the new hosting company that the web space is for your existing domain ... this shouldn't be a problem.

• Upload your web site to your new domain and test that everything works (just use the domain's IP address to access it)

• Change the relevant DNS settings to point at your new web space, and check regularly over the next 72 hours that all is working OK.
  

Keep an eye on the logs for each domain ... over a period of 3 days or so, you should see traffic disappear from your old hosting account and appear at your new one.

I usually keep the old web space alive for a couple of weeks after transferring the hosting.

Note that there can be some disruption to email and web site access during propogation, but this is usually limited to a few hours.

[pgmason]

If you migrate to a new host, put an announcement that you will be doing so on your site a few days in advance - that way your members won't think you've just disappeared in the time you may have an outage. If you can, it may be an idea to do an email announcement.

Pete