CMS Made Simple Forums

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

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.

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

I'll answer my own question

Yes

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

Cheers

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.

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.

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

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

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.

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

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

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 includesThis 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.

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!

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

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.