transferring test site to client site

chrisinoz · Post by **chrisinoz** » Fri Dec 10, 2004 11:28 pm

Hi

I have finished my first cms site on our test site.

How do I get it to my client's isp intact :> ?

Cheers

Chris

Ted · Post by **Ted** » Sat Dec 11, 2004 12:16 am

Easiest thing to do is:

1. Use mysqldump to dump your whole database into a file in your document root (mysqldump -u cms_user -p cms > cms.sql)
2. Copy the whole thing to the prod server
3. Modify the config.php on the server with new paths and domain names
4. Restore the sql (mysql -u cms_user -p cms < cms.sql)
5. Bask in the glory of your new site

Hope that sets you in the right direction.

chrisinoz · Post by **chrisinoz** » Sat Dec 11, 2004 1:04 am

Thanks Wishy

I guess then I call use mysqldump to act also as a back up.

Once they pay me I will make a PayPal donation.

Cheers

Chris

chrisinoz · Post by **chrisinoz** » Sat Dec 11, 2004 1:08 am

I'll answer my own question

Yes

http://www.devarticles.com/c/a/MySQL/Ba ... MySQLDump/

Cheers

Ted · Post by **Ted** » Sat Dec 11, 2004 1:26 am

I actually use this script for backing up the cmsmadesimple server.

http://members.lycos.co.uk/wipe_out/automysqlbackup/

It's basically a smart wrapper around mysqldump, but automates the process a bit. If you're handling backing up more than one database, I highly recommend it.

Sounds like the deployment went smoothly, which is great to hear.

willow2007 · Post by **willow2007** » Tue Mar 29, 2005 5:20 am

wishy wrote: Easiest thing to do is:

1. Use mysqldump to dump your whole database into a file in your document root (mysqldump -u cms_user -p cms > cms.sql)
2. Copy the whole thing to the prod server
3. Modify the config.php on the server with new paths and domain names
4. Restore the sql (mysql -u cms_user -p cms < cms.sql)
5. Bask in the glory of your new site

Hope that sets you in the right direction.

I am trying to transfer a client's site from one server to another. I used the above instructions and get the following when I try to open the site on the new server.

"Warning: mysql_pconnect(): Can't connect to MySQL server on 'mysql25.secureserver.net' (110) in /home/wdbc4079/public_html/lib/adodb/drivers/adodb-mysql.inc.php on line 355

Fatal error: Smarty error: the $cache_dir '/home/content/w/d/b/wdbc4079/html/tmp/cache/' does not exist, or is not a directory. in /home/wdbc4079/public_html/lib/smarty/Smarty.class.php on line 1088"

The first statement tells me that it is still trying to read off the old database server (mysql25.secureserver.net) But I can't find a way to change this.

Any suggestions?

Thanks for an awesome project.

Ted · Post by **Ted** » Tue Mar 29, 2005 11:07 am

Update your config.php for the new host. It sounds like all the paths and database server name are wrong.

BamaRob · Post by **BamaRob** » Wed May 04, 2005 5:00 am

Hey gang!

I haven't posted in a while... I'm trying to transfer a cms site from my development box to a client site. I've followed the steps above, but realized after I had transferred the cms.sql file, that I don't know how to get mysql to import the sql file! I only have ftp access to the host, so I'm not sure how to get the data imported. I suppose I could write a PHP script to import data from the cms.sql file...

How do you guys handle this? Or, do all of you have terminal access (local, telnet, rlogin, ssh, etc.) on your host server?

Thanks,

BamaRob

Ted · Post by **Ted** » Wed May 04, 2005 9:44 am

Usually people at least have access to phpmyadmin if they don't have a shell of some kind. If you don't, I would try installing it and then copy/pasting the cms.sql file into that.

BamaRob · Post by **BamaRob** » Wed May 04, 2005 11:46 pm

The sysadmin gave me SSH access, so all is well. A little more tweaking to do, and I'll provide a link so you guys can check it out.

Thanks,

BR

Ted · Post by **Ted** » Thu May 05, 2005 1:33 am

Sweet. That's really the better way to do it...

BamaRob · Post by **BamaRob** » Fri May 06, 2005 4:03 pm

OK. I got the site all transferred and working (except for File Management, but I think (hope) that's just a permissions issue). It's running CMS 0.8.2, but I'd like to upgrade it soon to 0.9.2 so I can integrate Calendar-0.6. Can I go straight from 0.8.2 to 0.9.2? Or, do I have to go through the upgrades between the two versions?

Thanks,

Robert

P.S. If you want to check out what's there so far, it's at http://fayette.k12.al.us/fes . There's not a lot of content there yet. I've still got to get with the principal/staff for user training. Then, each principal, teacher, other staff member, etc. will be managing their own content. In order to make this easier, I created a custom page footer (thanks to a little help from wishy a while back) that is included on all content pages and includes

Code: Select all

global $gCms;
echo "<div align=\"right\"><a href=admin/editcontent.php?content_id=".$gCms->variables['page']." target=_new><img src=images/cms/edit.gif border=0></a></div>";

This provides a small image in the footer that, when clicked, takes the user to the login page and, after successful login, takes them straight into edit mode.

Ted · Post by **Ted** » Fri May 06, 2005 6:10 pm

Going straight from 0.8.2 to 0.9.2 should not cause any issues, as long as all the modules are up to the date with the new API.

Site is looking good so far!

BamaRob · Post by **BamaRob** » Fri May 06, 2005 9:31 pm

wishy wrote: Going straight from 0.8.2 to 0.9.2 should not cause any issues, as long as all the modules are up to the date with the new API.

How do I know whether the modules are up to date?

Robert

Ted · Post by **Ted** » Sat May 07, 2005 2:49 am

What are you using on your site currently? Anything that comes with CMS by default will be updated for 0.9+. It's just the 3rd party stuff that you need to worry about.

CMS Made Simple Forums