Page 1 of 1

data doesn't the same after copied from staging to publishing server

Posted: Fri Dec 15, 2006 5:05 am
by icammy
Hi all,
I have a staging server and a publishing server.
All the modification are made in the staging server and I will copied the database data
from the staging to the publishing server in order to make their content the same.
I have a question to ask about this issue. Hope that you guys can give me a hand to solve this problem.
Thanks in advance.

I have copied all the database data from my staging server to the publishing server after I have made some changes.
Howerver, the new added parts do not appear in the publishing server.
I have chmod 770, chgrp mysql and chown mysql to the database data.
Does anybody can help is this issue? Thank you very much!!!

Re: data doesn't the same after copied from staging to publishing server

Posted: Fri Dec 15, 2006 5:34 am
by cyberman

Re: data doesn't the same after copied from staging to publishing server

Posted: Fri Dec 15, 2006 5:48 am
by icammy
Thank you for your quick reply!
Yeah! I have read this before.
I have copied the whole CMS system from the staging to the publushing machine before.
Actually my web in publishing server works fine.
I have just updated some content in the staging machine and I would like to sync these to the publishing server.
Is that everytime I made a change I have to copy not only the database data but also /var/www/cmsmadesimple in order to make all the thing appear?

Re: data doesn't the same after copied from staging to publishing server

Posted: Fri Dec 15, 2006 5:55 am
by cyberman
Are the paths on staging server and publishing server the same? Have you changed config.php to new values?

Re: data doesn't the same after copied from staging to publishing server

Posted: Fri Dec 15, 2006 6:11 am
by icammy
yeah~ all the paths are the same.
I have only copied the database data this time,
as the /var/www/cmsmadesimple directory has been copied last time, so I didn't change anything in the config.php.

Re: data doesn't the same after copied from staging to publishing server

Posted: Fri Dec 15, 2006 7:17 am
by cyberman
Hmm, have you tried to run install wizard (without creating tables and content)?

Re: data doesn't the same after copied from staging to publishing server

Posted: Fri Dec 15, 2006 7:26 am
by icammy
How can I do this?

Re: data doesn't the same after copied from staging to publishing server

Posted: Fri Dec 15, 2006 8:15 am
by cyberman
Be sure there's an install folder inside cmsms root. Empty config.php. If you than go to this website install procedure runs automatically. On one step (step 2 or 3) you can deactivate creating tables and content.

Re: data doesn't the same after copied from staging to publishing server

Posted: Fri Dec 15, 2006 11:51 am
by Dr.CSS