Cannot change server - Please help!

Okay, this may be pretty drawn out so I will only post a summary and if any kind member takes up the gauntlet and asks questions I'll answer and explain further

(Saves me typing out a novel for nothing )

Right, we set up a forum etc. on a shared server and now want to move it to a dedicated server. We have a server setup and ready to go.

The sql database is currently held on our hosts 'sql server' and is different to the shared server that we have our website on.

I ftp'd the htdocs down from shared server.

I backed up the sql database using mysql administrator on my pc.

On the dedicated server (DS) I setup up a database and a user etc.
I also set up a user account and gave it a website.

I ftp'd the site up to this users htdocs and it seems fine.
I restored with mysql administrator the backup from the Shared server (SS) to the DS.

If I run http://<ip-address>/info.php it returns a page of info.
If I run http://<ip-address>/index.php it returns the website on the SS (config.php unchanged at this point)

From the above I take it that the website bit is in the right place and functioning.

When I edit config.php to point to the DS database I get a VB error page that says Databse error...The <domain> database has encountered an error.

I have checked with putty that there are indeed files pertaining to a sql database, I have even managed to issue a show tables sql command through my sql administrator and got back a list of tables which makes me think that the database is ok.

Any help or pointers that you can give will be gratefully received! !

[livethedream]

I appreciate what you say but how is flashchat causing the problem? It works fine on the current setup and all backups were taken after flashchat was installed.

Can you explain further what is going wrong? I'd like to understand before I try removing things.

Thanks very much for your assistance.

[R1lover]

Originally Posted by livethedream

I appreciate what you say but how is flashchat causing the problem? It works fine on the current setup and all backups were taken after flashchat was installed.

Can you explain further what is going wrong? I'd like to understand before I try removing things.

Thanks very much for your assistance.

It's BLACK & WHITE!

MySQL Error : Table 'databasename,sameonbothservers.flashchat_connectio ns' doesn't exist

You database is telling you that this flashchat connection does not exist.

[livethedream]

Thanks for that...

Following your post about settings in admincp I realised that could probably still get into them. I did and changed any refernce to the domain name .co.uk to the new servers IP...

I now get the same error screen BUT the bit about flashchat is visible in a scollable box ...
Why would the move screw the flashchat link?

[R1lover]

Try disabling flashchat and then see if vBulletin is ok... One step at a time.

[livethedream]

I'll have a go tomorrow, got to go to bed. 1AM don't ya know

I'll post back tomorrow.

Thanks ever so much

--------------- Added at 22:55 ---------------

Thanks for all your help, your support helped nudge me in the right direction and the problem (well, the current one ) is solved.

The problem was the sql backup. Flashchat had been installed after we had setup the backup job in mysql administrator. The backup job didn't include the tables for flashchat. Simple as that!

One fresh, modified, backup and restore and up came the homepage...

Thanks again.