WordPress.org

Ready to get started?Download WordPress

Forums

Moving wordpress to a NEW database (2 posts)

  1. avespoli
    Member
    Posted 1 year ago #

    I have a development blog and a production blog, both have different databases but relatively the same files. I made some changes to the site theme and plugins on the development blog which I wanted to incorporate into the production blog. So I backed up the files of the production blog, and replaced the wp-config file from the development blog with the production blog's (in order to connect to the production database), and FTP'd in and uploaded the development blog files to the production blog's root. Shouldn't this be an easy way to transfer the site changes to the new database or am I missing something?
    When i went to the site it was just a blank page. So I had to undo everything and put the old production site back up until i can figure out the issue.

  2. W.P. Ginfo
    Member
    Posted 1 year ago #

    Step 1:
    NOTE Start by making a back-up to your PC!

    1. FTP: Make a backup of the files of your site, using FTP 'Filezilla' [free] or your own FTP-program.
      (see: http://codex.wordpress.org/Using_FileZilla )
    2. Make a backup of the CONTENT of the site
    3. dashboard > tools > export > all content > download exportfile
    4. If required: confirm installation of export tool and run the export

    You now have a fallback position, should things go wrong!

    Step 2:

    1. Create a new database
    2. upload a fresh version of WP
    3. browser: http://www.yourdomain.com
    4. The WP-install starts
    5. Point to the new database
    6. use the same PREFIX as used in the 'old' database
    7. You now have a standard 'empty' new wp-site

    Step 3:

      now transfer old to new

    1. !!VERY IMPORTANT!!
      make a copy of the wp-config.php of the NEW site
    2. Restoring files: FTP all files from the backup to the site, overwriting the files on the site.
    3. Re-upload the wp-config.php of the NEW site
    4. To transfer the content:
      Dashboard > Tools > Import > wordpress > choose the exportfile from your computer, and 'upload file and import
    5. If required: confirm installation of import tool and run the import

    You should now have a new site with the old content.

    !!!!!!!!!!!
    Content is NOT syncronized between old and new, just transferred!!
    !!!!!!!

Topic Closed

This topic has been closed to new replies.

About this Topic