Need help with mysql database - ...before i tear out all of my hair

[Tony McC]

After more than a decade with the same web hosting provider, it seems that they have decided that customers are just a PITA that they should just hand over the money without expecting any level of service and support.

Today, they've stopped me adding any further content to the main site because it is over a pathetic quota (200Mb) and exceeds the storage limit of even their maximum non-managed product (which weighs-in at a less than impressive 500Mb) by a factor of 4. I have an alternative hosting company where I maintain websites for a number of contractors, small manufacturers, friends and colleagues, which provides unlimited webspace and bandwidth for around half of what I currently pay. The only reason I've never switched hosts is that the company that has hosted pavingexpert.com has, up until this summer, been absolutely wonderful in terms of support and service, and I've been happy enough to pay a premium for that. However, if that level of support and service is no longer available, then I fail to see why I should pay not just a premium, but a price hike that would make British Gas seem like piddling amateurs.

To move the whole site over to a new host is a considerable undertaking, but I'm reasonably confident of being able to do it. What I'm not good at is mySQL databases, the gubbins that runs The Brew Cabin, and all the paths and re-directs and permissions that are needed to prevent it falling over. So, if anyone out there thinks they;d be able to help me shift the Brew Cabin to a new home (and possibly try out the new decor that has been stuck on my hard drive for the past 6 months), I'd be incredibly grateful and even willing to pay a reasonable fee.

Anyone help?

[Dave_L]

I'd love to Tony, but I'm not that skilled. Shame, as I'd love to be involved with this.

[lutonlagerlout]

i am puter illiterate tony but i know our clan guys have just moved our website to a new host and its very reasonable
will enquire and find out
LLL

[IanMelb]

Tony, I've relocated a few fora/forums in my time - including all the MySQL stuff. Can help/advise if required

Ian

[GB_Groundworks]

i ve got a Bsc in computer science (networking) and spent 2 years working in munich for Sun working on unix servers and now i'm a groundworker haha, just love working outside.

i prefer phpbb over ikonboard

seems easy enough to move with phpmyadmin

http://forums.ikonforums.com/index.cgi?act=ST;f=13;t=176

[Tony McC]

I started working on a phpbb version of The Brew Cabin, but it was taking up so much of my limited time, that it got parked in a corner while I went back to ikonboard php, which didn't actually seem that much easier.

I think I've located a new home for the site. Their name was recommended by someone I respect, and the prices seem much more reasonable, backed up by a sort-of adequate tech s'port. The only downside is that tech s'port is email only, which means no instant answers on the phone (which is part of the reason why I stuck with the current host for so long).

amenworld.com - any opinions?

[lutonlagerlout]

i know most of these hosting companies like to do the talking via MIRC or MSN ,which is a pain but the lot we use seem pretty good
will pm you tony
LLL

[Mikey_C]

In the words of dragons den "to let you know were I am, I'm out". As I started reading this thread I was going to volunteer Ian, fortunately he that himself. However, if LLL does mind me imposing I can make the tea

[newbuyer17]

To transfer the data you use a utility called mysqldump. Search on internet for backing up and restoring mysql databases.
mysqldump should already be installed on the server and will dump out all the sql (commands) required to recreat the data in a new database.
So you'd:
dump out the database on your original server.
transfer the dump file to your new server
create a new database
run the dump file commands against your new database

This should in theory put you where you want to be. Its difficut to comment any more as I dont kow what permissions either hosting company have given you. The above is the simplest way to do it if you have full acccess on both servers.

Hope it helps a bit anyway.

[Dave_L]

There's far too much dumping going on in this thread for my liking.

[Tony McC]

...I think I might go for one while I try to work out what to do for the best.

Just got me head around PHP sendmail, so it'll take the weekend to recover, and then I can tackle the mysql.

[danensis]

Have you looked at 5quidhost?

http://www.5quidhost.co.uk/hosting.php

Not the £5 bit obviously, but my colleagues in BT (when I worked there) spoke very highly of their services.

John

[Tony McC]

I like the attitude of Mr 5 Quid, but the bandwidth available is a bit restrictive.

Someone, it might have been Ian Melb, put me on to your erstwhile employers, Jon, and I have to admit that what they offer leaves everyone else standing. However, I'm *still* waiting for a reply from their sales team, which does't augur well for that all-important Tech S'port.

Annoyingly, UK2 are current leaders. I had a site hosted with them years ago and it was nowt but trouble with a capital T, but over the past 4 days they've been recommended to me more times than all the other runners put together. Apparently it all new mannidgement and proper servers in place of the clockwork yokes they had back when I last used them.

So: who wants to take a look at the mysql database and advise on how best to crowbar it into place in its new home?

[IanMelb]

I don't mind having a look at the mysql database. In the past I've found that one of the easiest things to do to shrink it down is to clear the log entries (if it has any).

I've got access to a couple of MySQL servers where we can test to see if the data transfers OK, also would provide an interim offsite backup...