Import WP database from one server to another !

  • How can I import the database entries from 1 WP Installation to another.
    I want to move from one host to another, and I do have access info for both the host’s database server.
    Any Idea ?

Viewing 7 replies - 1 through 7 (of 7 total)

  • I would suggest using either phpMyAdmin or backup/restore

    https://wiki.www.ads-software.com/Database%20Backup
    is useful from the command line.

    https://wiki.www.ads-software.com/Restore%20Instructions
    and this.

    I just did this last night. Used the phpmyadmin faq, down at 6.4 and 6.5.
    I followed the instructions, downloaded the gzip’d file to my hard drive (which turned out to be a dumb thing since after that I just had to unzip it and upload the unzipped file). When I unzipped it, it asked me what sort of file I wanted it to be and I put .sql on the end.
    Then I deleted every single table in the database. You probably want to skip that step but I wanted to see if the restore would work. ??
    Then uploaded it using those instructions and it did it’s thing and recreated the database just like it was.
    Pretty nifty, really. I’m moving to a new host this week so I wanted to make sure it goes smoothly.
    Good luck!

    phpmyadmin supports uploading of gzip.
    databases can run in megs mate! compressed file makes it a lot convinient…

    Upload in gzip. Check. ??
    I tell you… there isn’t a container big enough to fit all the crap I don’t know. Thanks for the tip!

    Thread Starter sadish

    (@sadish)

    Thanks for the Input guys !
    I was able to import the entries. but when I try to login, it still went to the old website.
    I figured it was because it is stored in the table tableprefix_blogoptions table.
    I opened it using phpMyAdmin and changed to the new URL to make it work.
    To avoid this step, I could have opened the SQL in notepad and change this field, before doing the Import .
    I thought this should be logged somewhere.
    can somebody who understand what this is, post it on wiki somewhere.
    Thanks,
    Sadish
    https://www.alittleaway.com

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Import WP database from one server to another !’ is closed to new replies.