close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Moving from shared to VPS

Thread began 6/29/2012 10:16 am by bill3786 | Last modified 7/06/2012 12:24 pm by bill3786 | 1411 views | 13 replies |

bill3786

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

bill3786

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

Sign in to reply to this post

Jason ByrnesWebAssist

well, the MySQL Server name may change

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

Sign in to reply to this post

bill3786

Ah, thanks.

Will check the MySQL Server name.

Sign in to reply to this post

bill3786

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

Sign in to reply to this post

Jason ByrnesWebAssist

it may be, it changes from host to host.

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

Sign in to reply to this post

bill3786

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"

Sign in to reply to this post

bill3786

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"

Sign in to reply to this post

bill3786

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.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...