WordPress.org

Ready to get started?Download WordPress

Forums

Adding wp-database from web host to local host (5 posts)

  1. turbonostics
    Member
    Posted 5 years ago #

    Hi There,

    I'd like to redesign my blog on local host, but can I import my exisiting database that is online, to my local host version? If so how?

    I've tried copying my online blog on to local host, but it is getting the database to communicate with wordpress.

    Please assist,

    James

  2. Samuel B
    moderator
    Posted 5 years ago #

    the easiest would be with the native import/export function
    export online blog - import to localhost blog
    admin - tools - import/export

    alternately if you have phpmyadmin installed locally - export db - import db dump

  3. phyllisgrover
    Member
    Posted 5 years ago #

    hello

    i am trying to do the reverse, and when i try to import the database file in phpmyadmin, it always times out. can you tell me where the "native import/export function" you are referring to is located?

    thanks

  4. turbonostics
    Member
    Posted 5 years ago #

    Hi There,

    I've got the wp-database plugin installed, and the I've placed this onto my blog, however, MyPHPadmin says I need to drop the wpcomments table.

    This case I get the infamous "Error connecting to database".

    The second thing I've tried is creating a new database and uploading the wp-database from your online into this new database.

    I get a white screen when I load it locally.

    One of my mates is a database designer and he said ensure that the languages from the SQL is the same from your hosting to the local host. I'll give that a try.

    I've also tried copying the entire online blog into localhost. And just says error connecting to the database.

    Thanks

  5. jonniboo
    Member
    Posted 4 years ago #

    Hi there,

    I've managed to export the individual tables from an online wordpress database, (wp_posts etc), and imported them into my local wp database (delete the existing local database tables first).

    The links to each page/post are also updated automatically.

    I originally tried exporting/importing the whole database but the links stayed as the online version.

    Hope this helps anyone who is currently trying this out.

Topic Closed

This topic has been closed to new replies.

About this Topic