Moving from shared to VPS

We were just at the point of going live with the 1&1 business shared hosting package when something cropped up with the clients old hosting which meant we needed a fixed ip address.

This has meant taking out a 1&1 Virtual Private Server package with 1&1.

Can you forsee any potential problems with moving the site to the VPS?

Is it as simple as changing the site defintion in dreamweaver and uploading the site folders and files and then importing the database using phpmyadmin?

Any help would be appreciated.

I dont foresee any problems with this.

like you said, you'll need to change the site definition, also change the database connection.

1 & 1 should be able to transfer the database for you, or you can export it then import it to the new MySQL server using PHPMyAdmin

I had assumed the database connection would stay the same if the database name, username and password were unchanged.

Could you explain why the database connection needs changing.

Thanks

well, the MySQL Server name may change

if not, then i guess you wouldn't need to edit the connection

Ah, thanks.

Will check the MySQL Server name.

Is the MySQL Server name the same as the ip address?

it may be, it changes from host to host.

log into the hosts PHPMyAdmin, it will show the mysql server address near the top.

Ok, found it, it shows localhost.3306

There is only "localhost" in the site definition so is .3306 required?

Having a problem with the DFP on the product update and insert pages after moving from a 1&1 shared hosting to 1&1 VPS.

DFP worked perfectly on the update and insert for the product images on the shared hosting where the path to the upload folder was ../images/productimages

On the VPS the DFP causes the image name to be deleted in the database.

Tried a number of different paths combinations with no luck.

Also noticed that on opening the update server behaviour a window appears stating "SQL type not recognised"

Managed to get the DFP working on the update and insert product pages. It turned out to be a permission problem on the images folder.

Still got the server behaviour problem mentioned earlier.

If I double click on the update record server behavior I get the error "sql type not recognised: "

If I ok the error three times I get the update record general configuration screen displayed but the table field shows "No table found" and if I test the mysql connection under the define button I get an error "An undefined error has occured"

Been checking a lot in the forum and it seems this problem could be due to the setup or lack of a testing server. I'm not using a local testing server.

Lots of people seem to have problems with this feature.

I have set up a testing server and it seems to have cured the problem but would like an explanation of what is causing the problem and the correct way to set up a testing server.