Adding wp-database from web host to local host

  • turbonostics

    (@turbonostics)


    15 years, 1 month 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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Samuel B

    (@samboll)

    15 years, 1 month 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

    phyllisgrover

    (@phyllisgrover)

    15 years, 1 month 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

    Thread Starter turbonostics

    (@turbonostics)

    15 years, 1 month 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

    jonniboo

    (@jonniboo)

    14 years, 4 months 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.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Adding wp-database from web host to local host’ is closed to new replies.