Nucleus Support Forum Index

Find on the forum:
any terms  all terms  Advanced Search

RSS 2.0
Browse posts: Unanswered | Mark all read

« »
Loading Nucleus FAQ ticker...
Post new topic Reply to topic
Author Message
shillog
Nucleus Disciple


Joined: 03 Nov 2008
Posts: 133

Post Posted: Thu Feb 26, 2009 7:51 am   Post subject: [SOLVED] switching databases
Reply with quote

i have two N sites.
site 1 is running. site 2 is kept for code/design testing (just for me).
the idea is to publish site 2 (after completion) as the running site
taking all the contents from site 1 and make site 1 disappear.

i realize this means a database switching. how to do it properly?
and, more important, is this possible from within the N files?
i am a bit nervous about fiddling with myphpadmin Smile

Back to top

View user's profile Send private message
ftruscot
Nucleus Guru
Nucleus Guru


Joined: 22 Feb 2006
Posts: 7449
Location: Massachusetts

Post Posted: Thu Feb 26, 2009 1:25 pm   Post subject:
Reply with quote

First make backups of both dbs.

Let me try to restate what I think you might be trying to do.

From site 1, you want to use the following:

Folder structure and path inncluding core nucleus files
Blog, item, comment, config, member tables from db

From site 2, you want to use the following:

Skins, media, and nucleus plugins folders.
Parts of db that controls skins, templates, plugins.

Is that correct?

_________________
Is your question not solved yet?
Search our FAQ,
read the Documentation, or
browse the list of available plugins.

Check out my plugins

Back to top

View user's profile Send private message Visit poster's website
shillog
Nucleus Disciple


Joined: 03 Nov 2008
Posts: 133

Post Posted: Thu Feb 26, 2009 2:13 pm   Post subject:
Reply with quote

franks, let me put it another way.

right now both sites use the same skin (say, myskin) under the same name. but they look different (that means programs like style.php, header.inc, etc of site 2 are modified).

i want site 2 to run exactly like site 1 though with a different look.
site 1 members should be able to login to site 2 with no re-registration.
all the blogs (with all the posts and comments) of site 1 will be there.

i think it would suffice if install myskin of site 2 to site 1
in such way that myskin of site 1 will be overwritten.

changing the name of myskin of site 2 to another name (say, yourskin) could have solved the problem. but, in response to another posting of mine, you had already pointed out that it's very complicated work.

Back to top

View user's profile Send private message
ftruscot
Nucleus Guru
Nucleus Guru


Joined: 22 Feb 2006
Posts: 7449
Location: Massachusetts

Post Posted: Thu Feb 26, 2009 2:29 pm   Post subject:
Reply with quote

You're just swapping skins?

The easiest thing would be to export your skin (be sure to check the templates being used) from site 1. Take the resulting skinbackup.xml file and put it with a backup copy of the skins/yourskinname folder for site 1.

Do the same for site 2.

Now in the blog settings for the main site (site 1), change the skin the blog uses to one of the other skins for now (so that you can remove your skin and so that your visitors will at least see something during the swap.

Now, in site 1, go to the Skins page and delete your skin. Then go to the Templates page and delete those templates associated with your skin.

In the file manager, remove your skins/yourskinname folder from site 1. Then copy the skins/yourskinname folder from site 2 to site 1.

Finally, in the admin for site 1, import your new skin, then in the blog settings set site 1 to use that skin.

_________________
Is your question not solved yet?
Search our FAQ,
read the Documentation, or
browse the list of available plugins.

Check out my plugins

Back to top

View user's profile Send private message Visit poster's website
shillog
Nucleus Disciple


Joined: 03 Nov 2008
Posts: 133

Post Posted: Thu Feb 26, 2009 3:40 pm   Post subject:
Reply with quote

ok it's a bit confusing. Smile
now a related question.

i do a new installtion of N, with an old one working.
what would happen if we make the new site point to the mysql database of the old one?
will it work like the old site, granted that both sites use the same skin?

if it works, is it possible to make the necessary change from within N?

Back to top

View user's profile Send private message
ftruscot
Nucleus Guru
Nucleus Guru


Joined: 22 Feb 2006
Posts: 7449
Location: Massachusetts

Post Posted: Thu Feb 26, 2009 5:51 pm   Post subject:
Reply with quote

You can do this, but you will need to make some changes to the nucleus_config table of teh database. You should be able to make those changes from the Configuration page of the admin area.

You will also need to be sure that the skin files you need are in the new installation, as well as any media files and plugin files.

You would point the new installation to the old db after the installation by modifying the settings in the config.php file. Be sure to backup your db before doing anything.

_________________
Is your question not solved yet?
Search our FAQ,
read the Documentation, or
browse the list of available plugins.

Check out my plugins

Back to top

View user's profile Send private message Visit poster's website
shillog
Nucleus Disciple


Joined: 03 Nov 2008
Posts: 133

Post Posted: Thu Feb 26, 2009 6:10 pm   Post subject:
Reply with quote

ok, frank, i will try.
my old installation is as good as lost
(as i mentioned under my post 'site lost).
just taking a chance.

if it doen't work with the new installtion
i can deletee it.

Back to top

View user's profile Send private message
shillog
Nucleus Disciple


Joined: 03 Nov 2008
Posts: 133

Post Posted: Thu Feb 26, 2009 7:09 pm   Post subject:
Reply with quote

followed your instructions at http://maythil.in/journals .
it looks like excatly like the old running site http://maythil.in/n
that's no skin is graphically loaded. texts (contents) are shown.

Back to top

View user's profile Send private message
shillog
Nucleus Disciple


Joined: 03 Nov 2008
Posts: 133

Post Posted: Sat Feb 28, 2009 6:18 am   Post subject:
Reply with quote

the problem is solved.
while sorting it out, i badly needed one option at admin --
the option to override all the individual blog skin settings
and make all follow the global skin setting.

Back to top

View user's profile Send private message
Post new topic Reply to topic
Display posts from previous:   

Page 1 of 1

All times are GMT + 1 Hour

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2002 phpBB Group