Wordpress Themes - WP Forum at BFA
Click here to register or to donate.
Auto self-registration is not available here - far too many spammers. This forum has many, many backlinks and because of that there is an intense desire among spammers to drop their links here.

Wordpress Themes - WP Forum at BFA » WordPress Themes » Atahualpa 3 Wordpress theme »

How to copy settings to another blog


  #1  
Old Jun 16, 2009, 04:04 AM
Ilovethistheme
 
1 posts · Jun 2009
I have customized the theme to suit my blog and now I want to copy the entire theme with all its settings to another blog. I copied the entire folder to the other blog, activated it, but seems there must be an extra step because it doesn't show all the customizations. Where are these stored? Must be somewhere in the database I am thinking? Please help!
  #2  
Old Jun 16, 2009, 05:42 AM
juggledad's Avatar
juggledad
 
23,598 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
The theme options are stored in the database. There is an export function (see http://forum.bytesforall.com/showthr...ghlight=export) but you manually have to enter the options
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support
  #3  
Old Jun 16, 2009, 02:35 PM
fromtheranks
 
149 posts · Apr 2009
Dev Env't: XP Pro SP3, IIS 5.1, MySQL 5.1, PHP 5.2.x, WP 2.7.1, Atahualpa 3.3.3, IE 7, FF 3.0.x
Interesting. I was wondering about this myself as I'm getting ready to move from my dev environment into production. I don't have a problem with re-entering Atahualpa config settings, I can have two browsers open (local and host) and bang those out pretty quickly -- dual monitors come in real handy at times.

Follow-up question: I assume the export includes all of the WP setup stuff? Like, all the plugins, settings, and so forth? I read the text in the Codex but have no experience with what works and what doesn't. It would be a flat out drag to have to do all the WP stuff too?

Thanks in advance.
  #4  
Old Jun 16, 2009, 05:03 PM
juggledad's Avatar
juggledad
 
23,598 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
The export.php only exports the Atahualpa options.

I'm testing a step by step way to dump the Atahualpa options from one site and import them into another. You need to have knowledge of phpMyAdmin. I'll post it when it's done, but I'll give a basic rundown.
(1) in phpMyAdmin of the database you want to copy the Atahulapa options from, you will do a 'select' and export the results.
(2) in the database you want to import to, you will
(a) in phpMyAdmin, do a 'delete' of all the existing Atahualpa options, then
(b) do an import of the file created in step (1)
and that should do it.

there are a couple possible inbetween steps, like making sure the table prefix is fixed up in the export if they are different (i.e. let's say the wordpress prefix is XX- in your test bed and it is WP- in the new location, the export has to be edited) and possible changing a url in the export file. If you need more info right away, send me a PM
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support

Last edited by juggledad; Feb 13, 2011 at 01:25 PM.
  #5  
Old Jun 18, 2009, 03:19 AM
fromtheranks
 
149 posts · Apr 2009
Dev Env't: XP Pro SP3, IIS 5.1, MySQL 5.1, PHP 5.2.x, WP 2.7.1, Atahualpa 3.3.3, IE 7, FF 3.0.x
Maybe because it's late (again) and I'm tired (again), but I'm a little bit confused.

I am literally in the middle of setting up my site on my host servers.

I've copied all of the folders under my wp directory to the new wp directory, and next I believe I need to get all the wp and atahualpa option settings into the new MySQL database (which matches the database name I have here locally, with the same file name extension as set up in wp-config.php here).

The last steps will be (should then be) pointing the virtual directory on the host site to the new wp folder and updating my DNS settings in GoDaddy.

Can't I just dump the MySQL database here and restore it there?

Or if I do the WP export, couldn't I just import that via wp-admin on the host server and do the same thing? Transferring all of the settings for WP and Atahualpa?

I saw this other thread but I don't know how that fits in, i.e. how selective it is: http://forum.bytesforall.com/showthr...xport+settings.

What am I missing?

Since we're on the subject, what would also be ideal is if I can write my posts here, load them into WP here to proof them and then somehow export them, lock stock and barrel over to the host. ?

Thanks in advance.
  #6  
Old Jun 18, 2009, 08:05 AM
juggledad's Avatar
juggledad
 
23,598 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
IF (and that is a BIG if) the settings in wp-config.php at your testbed match the settings on your host and you want to OVERLAY what exists on your host, then yes you should be able to do a MySQL export from your testbed and a MySql import at the host. You will have to go in and change the settings WP Dashboard->Settings->General Settings->WordPress address (URL) and Blog address (URL) to reflect the new addresses.

What I was trying to address is the case where you just want to move the Atahualpa settings from one site to another. Remenber a WordPress database contains lots of info: the Users, options for widgets, options for themes, extra tables a widget or plugin might use, comments people have written.

As for your last question, why not do what you want, write the posts, edit them and then when you want to move them over, just do a cut and paste?
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support
  #7  
Old Jun 18, 2009, 01:00 PM
fromtheranks
 
149 posts · Apr 2009
Dev Env't: XP Pro SP3, IIS 5.1, MySQL 5.1, PHP 5.2.x, WP 2.7.1, Atahualpa 3.3.3, IE 7, FF 3.0.x
Thank you, Juggledad, once again.

I think I've got it now. So a strategy would be:

1. for the very first time, since I'm not worried about stepping on users, existing widget options and so on, it would make sense to do a dump of MySQL, ftp it over and import it. A one time deal to get everything up and running. This presupposes, as you say, that the wp-config.php info is identical. Then I'll need to mod the General --> WordPress address and Blog address as noted.

2. For future changes to Atahualpa, use your approach for extracting just the ATO options. That won't step on anything else.

3. For new posts I can do a cut and paste -- Remote Desktop Control allows (should allow) me to do so. I'd just have to move any images over to the new upload folder first.

The only glitch here that I forsee is that when inserting images into a Post (or Page), I can use relative paths for the Link URL but not the Source path; ex: "http://localhost/fromtheranks/ftr-it/wp-content/uploads/image001-500x318.png" can't be (doesn't seem to be able to be) shortened to "wp-content/uploads/image001-500-318.png".

Hmmm ... if I do the cut-and-paste in HTML mode, could I edit the source link after copying it over but before doing an Update Post? That might work. Unless there is a better way?

Thanks in advance. I very much appreciate your help.

(another donation is on its way)
  #8  
Old Jun 18, 2009, 02:13 PM
juggledad's Avatar
juggledad
 
23,598 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
Quote:
Originally Posted by fromtheranks
The only glitch here that I forsee is that when inserting images into a Post (or Page), I can use relative paths for the Link URL but not the Source path; ex: "http://localhost/fromtheranks/ftr-it/wp-content/uploads/image001-500x318.png" can't be (doesn't seem to be able to be) shortened to "wp-content/uploads/image001-500-318.png".
try using './wp-content.....'

Quote:
Originally Posted by fromtheranks
Hmmm ... if I do the cut-and-paste in HTML mode, could I edit the source link after copying it over but before doing an Update Post? That might work. Unless there is a better way?
Copy the HTML, Paste in a text editor - make the change, copy from the text editor - paste in new WordPress

One of the issues that you can run into when trying to export from one db and import in another, is if anything has 'happened' in between. Many of the tables have keys that may or may not be used in the other database.

for instance, the wp_options table (where the Atahualpa options are kept) in one person's database, the first Atahualpa option key might be 103, in another person's database it might be 234. If you export the entire row (all the columns) for an Atahualpa option and then try to import it into another database, it might fail because the 'key' might already be in the second database. Or it might be able to insert it, but if that option exsisted with another key, you would now have two different values for the same option. Just guess how that might cause problems.
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support
  #9  
Old Jun 18, 2009, 02:47 PM
fromtheranks
 
149 posts · Apr 2009
Dev Env't: XP Pro SP3, IIS 5.1, MySQL 5.1, PHP 5.2.x, WP 2.7.1, Atahualpa 3.3.3, IE 7, FF 3.0.x
Juggledad,

Quote:
try using './wp-content.....'
I tried "./wp-cont/..." with some interesting results. The image "disappears" from the visual editor -- although the anchors are left in place -- but it does show up in the post itself. If I try "../wp-content/..." it shows up in the visual editor but not in the post.

After you email arrived, I did some research on WordPress (http://wordpress.org/support/topic/263962) to understand how relative paths are set (./ vs ../ etc.) and they aren't recommending it.

I don't seem to have the access issue they refer to because I use excerpts in categories, archives, etc.; a visitor has to click on the post link to go to the actual post page. So, aside from the non-display in the visual editor, relative pathing seems to be working. (Well, not sure about Feeds as these aren't turned on yet ... but then again I'm only planning on sending excerpts here too so I don't think whatever the WP folks are concerned about is an issue for me.)

Or. Am I once again missing something. ?

Quote:
Copy the HTML, Paste in a text editor - make the change, copy from the text editor - paste in new WordPress
Makes sense. Thanks.

Quote:
... it might fail because the 'key' might already be in the second database. Or it might be able to insert it, but if that option exsisted with another key, you would now have two different values for the same option. Just guess how that might cause problems.
I could see this as an issue ... unless (?) ... there is only one person setting options? And I start out with identical copies of the database via the dump method? ... If there were two or more admins (shudder at the thought) this could definitely be an issue. Yes/no?

Thanks in advance.
  #10  
Old Jun 18, 2009, 04:16 PM
juggledad's Avatar
juggledad
 
23,598 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
Each time you activate/deactivate/update a plugin it's possible to change rows in the wp_options table so unless your sure you will replicate you moves (hmmm, did I do steps A, B, D, C or A, C, B, D?? Is that a B or an 8 I wrote there??) you could get into trouble, but hey then you do have a backup, RIGHT?
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support
  #11  
Old Jun 18, 2009, 05:01 PM
fromtheranks
 
149 posts · Apr 2009
Dev Env't: XP Pro SP3, IIS 5.1, MySQL 5.1, PHP 5.2.x, WP 2.7.1, Atahualpa 3.3.3, IE 7, FF 3.0.x
Jugglehead,

Point taken. I think I'll stick to having my local copy on one monitor and my hosted copy on another and just update ATO manually.

As for relative paths, I'm thinking that maybe I should avoid using that "feature" altogether and do as you suggested for moving the post, just edit in the new URL in a text editor (Frontpage, etc.) then copy and paste into the Host. And if I miss one, I can always use the Post HTML editor to fix it.

Thanks again.

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
TIP: how to copy settings of Atahualpa from one site to another gesman New Versions, & Updating 41 Apr 18, 2010 10:15 AM
Body copy starting half way down the page - why?! tobywinn Atahualpa 3 Wordpress theme 2 Jun 8, 2009 03:42 PM
[SOLVED] How to move old CSS settings to new blog location WebWeaver New Versions, & Updating 4 May 30, 2009 05:59 PM
How to Copy an Existing Theme Layout to a New Blog Site SenorD Forum How-To 1 May 10, 2009 03:16 PM
How to copy a complete setting of options hgrinb Header configuration & styling 1 Mar 11, 2009 09:36 PM


All times are GMT -6. The time now is 02:24 PM.


Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.