how to import local (offline) data into existing wp installation?

  • oneafrikan

    (@oneafrikan)


    19 years, 1 month ago

    Hey guys

    I’ve got two versions of wp running – one live at http://www.oneafrikan.com and one on my local machine at home.

    At the moment, I’m still trying to get to grips with 1.5 and all the content I was going to add to the site.

    So, my strategy is build and play with the site offline, and then upload it all when it’s done – to avoid SE and user problems with content appearing / disappearing.

    Question:
    How would you add the new data from the offline database to the online database?

    One way is just to stop posting for a few days, but that’s second place IMHO. Another way would be to use something like phpmyadmin to manually run a sql script to copy the new data to the tables, but there are possibilities of screwing up there. Obviously I would back up before doing anything major.

    Any ideas would be welcome? I’ll also post the final method if it’s more than a 5 min job.

    Thanks in advance y’all
    gareth

Viewing 2 replies - 1 through 2 (of 2 total)
  • Mark (podz)

    (@podz)

    19 years, 1 month ago

    Trying to mix / combine the databases will very probably cause problems that cannot be solved. The inter-relationships between the tables and the data they contain is very complex.
    Unless you copy/paste everything from one into the other, I do not see how you can combine them successfully.

    Thread Starter oneafrikan

    (@oneafrikan)

    19 years, 1 month ago

    Yea, thanks Podz – that’s what I was thinking.
    It’s easy enough doing the layout offline on a local machine, but the content is a different story…

    I wrote something here:
    http://www.oneafrikan.com/archives/2004/12/11/upgrading-adding-data-from-a-b2-installation-to-a-new-wordpress-installation/
    that talks about importing B2 posts to a wordpress db, and I reckon I may be able to import using a similiar method?

    Method (at point of adding new data):
    NB stop posting to blog during this process

    1. backup live db 😉
    2. install live db on local machine
    3. open up MS access
    4. insert the posts from the local db (with the new content) into the live db on the local machine, making sure the posts are referenced in all the right places and tables
    5. reset the local version of wordpress to use the now updated live db, to test the new content works
    6. if everything works fine, then upload the now updated db and check to see that it all works
    7. if it works, great, if not, back to the drawing board.

    The only problem I can se with this is the .htaccess file not being updated with the new “page” posts??

    What do you think?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘how to import local (offline) data into existing wp installation?’ is closed to new replies.