CMS Made Simple Forums

Hi,

I am trying to make a full copy of a site in a subdirectory so that the company that owns it canspend time doing a complete restucture of the copy site whilst the original is still viewablr online.  I am copying 0.13 and then am planning to upgrade the copy site as well.  I assumed that by using the database backup module, I could copy the original, then install a copy with a fresh database and then use the database backup to restore the copied database to the new copy, add in the images from the uploads directory and hey presto!  But following this method hasn't worked - in the new install, I still get the off the shelf page structure etc.

then i tried a straightforward sql dump in the original database and then ran it as an sql queory in the new one - again nothing!

So does anyone have any poiinters as to what I should do - i thought this would be a simple job (that was probably my mistake).

Thanks!

John.

copying site is almost the same as moving a site.

clear cache create full db backup, copy all files.

restore all files to new location, create new database and restore db, edit config.php to reflect changes, clear cache

if you want to use the same database for both installations you should edit the database dump and change the table prefix. (all text editors should have find and replace, so if you have cms_ as a prefix for your current site just do a find and replace "cms_" to "new_" and rememer to change this in config.php too)

after this you can upgrade the installation

hope this helps

ok - cool.  can i just clairy what you mean by 'clear cache' as that is the only difference with what you explain below and what i have done.  clear the browser cache?!?  or is this a cache I am not aware of?
thanks!

Clear CMSMS Cache: "Site Admin" => "Global Settings" => "Clear Cache" (deletes smarty cache files in tmp/cache)

Well - I have finally gotten back to this job - but no luck.

installed new cmsms copy (same version as original)

went to original, cleared cache, copied database

went to new, cleared cache, restored database from original site

still shows default install.

Anyone see what I am doing wrong here?

results of the restore pasted below...

Database Backup
Restoring database ...
Clearing int01additional_htmlblob_users
Restoring int01additional_htmlblob_users... Inserted 0 rows.
Clearing int01additional_htmlblobs_users_seq
Restoring int01additional_htmlblobs_users_seq... Inserted 1 rows.
Clearing int01additional_users
Restoring int01additional_users... Inserted 1 rows.
Clearing int01additional_users_seq
Restoring int01additional_users_seq... Inserted 1 rows.
Clearing int01admin_bookmarks
Restoring int01admin_bookmarks... Inserted 0 rows.
Clearing int01admin_bookmarks_seq
Restoring int01admin_bookmarks_seq... Inserted 1 rows.
Clearing int01admin_recent_pages
Restoring int01admin_recent_pages... Inserted 0 rows.
Clearing int01admin_recent_pages_seq
Restoring int01admin_recent_pages_seq... Inserted 1 rows.
Clearing int01adminlog
Restoring int01adminlog... Inserted 386 rows.
Clearing int01content
Restoring int01content... Inserted 29 rows.
Clearing int01content_props
Restoring int01content_props... Inserted 42 rows.
Clearing int01content_props_seq
Restoring int01content_props_seq... Inserted 1 rows.
Clearing int01content_seq
Restoring int01content_seq... Inserted 1 rows.
Clearing int01css
Restoring int01css... Inserted 21 rows.
Clearing int01css_assoc
Restoring int01css_assoc... Inserted 28 rows.
Clearing int01css_seq
Restoring int01css_seq... Inserted 1 rows.
Clearing int01group_perms
Restoring int01group_perms... Inserted 58 rows.
Clearing int01group_perms_seq
Restoring int01group_perms_seq... Inserted 1 rows.
Clearing int01groups
Restoring int01groups... Inserted 3 rows.
Clearing int01groups_seq
Restoring int01groups_seq... Inserted 1 rows.
Clearing int01htmlblobs
Restoring int01htmlblobs... Inserted 1 rows.
Clearing int01htmlblobs_seq
Restoring int01htmlblobs_seq... Inserted 1 rows.
Clearing int01module_FCKX
Restoring int01module_FCKX... Inserted 2 rows.
Clearing int01module_album_albums
Restoring int01module_album_albums... Inserted 0 rows.
Clearing int01module_album_albums_seq
Restoring int01module_album_albums_seq... Inserted 1 rows.
Clearing int01module_album_pictures
Restoring int01module_album_pictures... Inserted 0 rows.
Clearing int01module_album_pictures_seq
Restoring int01module_album_pictures_seq... Inserted 1 rows.
Clearing int01module_deps
Restoring int01module_deps... Inserted 4 rows.
Clearing int01module_feedback_config
Restoring int01module_feedback_config... Inserted 1 rows.
Clearing int01module_feedback_field
Restoring int01module_feedback_field... Inserted 7 rows.
Clearing int01module_feedback_field_seq
Restoring int01module_feedback_field_seq... Inserted 1 rows.
Clearing int01module_feedback_flock
Restoring int01module_feedback_flock... Inserted 0 rows.
Clearing int01module_feedback_form
Restoring int01module_feedback_form... Inserted 3 rows.
Clearing int01module_feedback_form_seq
Restoring int01module_feedback_form_seq... Inserted 1 rows.
Clearing int01module_feedback_option
Restoring int01module_feedback_option... Inserted 19 rows.
Clearing int01module_feedback_option_seq
Restoring int01module_feedback_option_seq... Inserted 1 rows.
Clearing int01module_feusers_belongs
Restoring int01module_feusers_belongs... Inserted 1 rows.
Clearing int01module_feusers_dropdowns
Restoring int01module_feusers_dropdowns... Inserted 0 rows.
Clearing int01module_feusers_grouppropmap
Restoring int01module_feusers_grouppropmap... Inserted 7 rows.
Clearing int01module_feusers_groups
Restoring int01module_feusers_groups... Inserted 3 rows.
Clearing int01module_feusers_groups_seq
Restoring int01module_feusers_groups_seq... Inserted 1 rows.
Clearing int01module_feusers_loggedin
Restoring int01module_feusers_loggedin... Inserted 0 rows.
Clearing int01module_feusers_propdefn
Restoring int01module_feusers_propdefn... Inserted 3 rows.
Clearing int01module_feusers_properties
Restoring int01module_feusers_properties... Inserted 1 rows.
Clearing int01module_feusers_properties_seq
Restoring int01module_feusers_properties_seq... Inserted 1 rows.
Clearing int01module_feusers_tempcode
Restoring int01module_feusers_tempcode... Inserted 0 rows.
Clearing int01module_feusers_users
Restoring int01module_feusers_users... Inserted 1 rows.
Clearing int01module_feusers_users_seq
Restoring int01module_feusers_users_seq... Inserted 1 rows.
Clearing int01module_news
Restoring int01module_news... Inserted 1 rows.
Clearing int01module_news_categories
Restoring int01module_news_categories... Inserted 1 rows.
Clearing int01module_news_categories_seq
Restoring int01module_news_categories_seq... Inserted 1 rows.
Clearing int01module_news_seq
Restoring int01module_news_seq... Inserted 1 rows.
Clearing int01module_selfreg_properties
Restoring int01module_selfreg_properties... Inserted 3 rows.
Clearing int01module_selfreg_properties_seq
Restoring int01module_selfreg_properties_seq... Inserted 1 rows.
Clearing int01module_selfreg_users
Restoring int01module_selfreg_users... Inserted 1 rows.
Clearing int01module_selfreg_users_seq
Restoring int01module_selfreg_users_seq... Inserted 1 rows.
Clearing int01module_templates
Restoring int01module_templates... Inserted 20 rows.
Clearing int01modules
Restoring int01modules... Inserted 13 rows.
Clearing int01permissions
Restoring int01permissions... Inserted 38 rows.
Clearing int01permissions_seq
Restoring int01permissions_seq... Inserted 1 rows.
Clearing int01siteprefs
Restoring int01siteprefs... Inserted 62 rows.
Clearing int01templates
Restoring int01templates... Inserted 4 rows.
Clearing int01templates_seq
Restoring int01templates_seq... Inserted 1 rows.
Clearing int01user_groups
Restoring int01user_groups... Inserted 4 rows.
Clearing int01userplugins
Restoring int01userplugins... Inserted 1 rows.
Clearing int01userplugins_seq
Restoring int01userplugins_seq... Inserted 1 rows.
Clearing int01userprefs
Restoring int01userprefs... Inserted 29 rows.
Clearing int01users
Restoring int01users... Inserted 4 rows.
Clearing int01users_seq
Restoring int01users_seq... Inserted 1 rows.
Clearing int01version
Restoring int01version... Inserted 1 rows.

Done

ok - further to the previous mail I have gone into mysql because I wsas getting irritated with the database backup (even though I am sure it was me) and have done the following...

dropped all tables from the new dbase

run an sql from the original Dbase

Now in mysql I can see all the correct tables etc (e.g content now shows all the pages)

However I have buggered something as if I navigate to the website itself I am getting a 404not found error eventhough the page I am pointing to is on the server etc.  I guess I need to change something in the config - anyone any ideas?

To be honest I prefer doing it this way rather than using the CMSMC backup as it seems to actually do what I want - if I can just get someone to tell me what to do in order to re-connect the pages to the updated dbase?

has anyone else had this much grief trying to create a simple copy?  I didn't think I was crap - but I guess I must be!

When you installed the backup on the new site... went to new, cleared cache, restored database from original site ...

If you had done it in reverse order," restored database from original site, cleared cache" you would have had what you needed, you may still get what you need by clearing the CMSMS cache...

New install has info on pages, CSS, menu structure, etc. stored in the cache to serve to visitors so it runs faster, untill you clear the cache it will continue to try and serve from there, clearing it makes it generate all new info...