Site Hosting Server Change

Monday 30 August 2010 4:57:21 am

Hi

We are working on http://www.oceanview-house.com/ which runs on ezPublish and is currently hosted in Apton server. We want the same to transfer to another server which gives the environment for ezPublish to be installed. But we are unable to do this because we are not understanding how to transfer the existing content and database to the new server.

A quick help will be highly appreciated. This is very urgent, will wait for an answer.

Regards

suvadeep

Monday 30 August 2010 6:04:27 am

Hi Ivo

Thanks for replying. I have the Admin access to the EzPublish CPanel. I also have the Admin access to the new Hetzner server.

Wednesday 01 September 2010 2:54:25 pm

Hi,

You can do mysqldump current database and then import it to the new.

export database: 
mysqldump -uUSER -p -hADDRES_IP_WHERE_IS_YOUR_DATABASE -B NAME_YOUR_DATABASE >backup_database.sql

import database:
mysql -uUSER -p -hADDRES_IP_WHERE_IS_YOUR_NEW_DATABASE -B NAME_YOUR_DATABASE <backup_database.sql

Then you need to change the files in siteaccess for database settings and the base url.

settings/siteacces/eng/site.ini.append.php

[DatabaseSettings]
DatabaseImplementation=ezmysql
Server=hostname your new database server
Port=
User=user new database server
Password=password this user
Database=name of new database

SiteURL=new site url

AdditionalLoginFormActionURL=new url user/login

You must also clear the entire cache, language files, ini, codepages, content, ezmutex, override, public, template, template-block, trans, translation, user-info and then copy all the ez publish a new server.

Best regards,

Lukasz