phpBBModders.net

* Are you on a shared host - Yes

* Are you using the MX record check/blacklist in the ACP - I've not changed the defaults but on checking the settings in Security it is set to Check e-mail domain for valid MX record: = Yes

* What type of search mechanism do you have active - Again the defaults Full text native with Enable fulltext updating set to Yes

Thanks

Option 2 (nothing special via phpmyadmin) or use mysqldumper (google for it).

FWIW, I don't think you need a dedicated server, a VPS should do.

Cheers

Yeah I need to have a think really. Pro's and Con's for both. The dedicated one I'm looking at costs a bit more than a VPS but its simplified so a lot of it is on-rails and nice user interfaces and they take care of all security updates etc etc which I like.

You can get root access if you want but then your own your own.

The VPS option is slightly cheaper but a lot more flexible, root access and everything that comes with it, but I'd have to keep on top of my own updates etc... so.

It needs more thought but the forum side of it sounds easy enough to migrate thanks for that. :thumbup:

So, how's it going? Any update?

I started logging each time it happens and sent that in to support on the 17th as it was happening all the time that day, they acknowledged the fault and said they were looking at it. Its only happened once since. I will chase them again in a few days and keep monitoring. Fingers crossed.

Well I've not seen the errors for a while but the forum is pretty slow sometimes so I'm looking into an VPS further. Could I ask you another question?

According to my forum Board Stat's I'm using:- MySQL(i) 5.0.68-percona-3-log

What do I need to look out for when I get a new VPS, does the version of MySQL have to be the same or higher for it to work? Also it looks like I'm using MySQLi does that matter, will a backup and a restore using phpMyadmin just "sort that out" for me, I don't have to worry about that side of things?

Sorry to ask, I'm getting more confident with the forum side of things but I'm weak on the database side

TIA

I've checked with the VPS people I'm looking to go with and asked about the MySQL version that comes pre-installed and they have stated they use this:-

mysql Ver 14.12 Distrib 5.0.22, for pc-linux-gnu (i486) using readline 5.1

Do you forsee any problems with backing up the old via phpAdmin and restoring to the new based on those versions?

No I don't see that you would have any problems. A Mysqli database is very similar to MySql. MySQLi supports some things that the old MySQL extension doesn't. Things like prepared statements, multiple statements, and transactions off the top of my head.

Thanks its good to have a bit of reassurance, I mean the main reason for going to VPS would be to improve the forum speed etc, and if I found I couldn't port it easy or had to start again from scratch (losing all posts & users) it would be a bit of nightmare really.

You should be fine and if you get stuck just holler.