How to import WP DB ?

Discussion in 'WordPress' started by SonnyCooL, Apr 14, 2009.

  1. #1
    How to import wp DB from one blog to another wp blog ???
    cause recently i just change my WP blog domain to another domain and i plan to import all old data to my new site (old site shutting down)....
    btw my old site have 8000++ post :)
    btw i use Direct Admin for my hosting.
    thanks
     
    SonnyCooL, Apr 14, 2009 IP
  2. deluxdon

    deluxdon Catch Me If You Can...!!!™ Staff

    Messages:
    25,481
    Likes Received:
    1,943
    Best Answers:
    32
    Trophy Points:
    480
    #2
    Do you have backup of your mysql DB (8000++ posts) ?? You can restore it at new hosting.

    DON.
     
    deluxdon, Apr 14, 2009 IP
  3. krishmk

    krishmk Well-Known Member

    Messages:
    1,376
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    185
    #3
    First you will have to generate the back up file through your old wordpress blog. There is an "export" function in Admin Control panel through which you could create a .wxr file (Wordpress Extended RSS file).

    After this step, you need to login to your new blog's Admin Control panel and select the "import" function and upload the .wxr file. It should take only few minutes. It would prompt you to map the authors or retain the original author's name. Also if you have any image in the old blogposts - you would be given the option to download it to the new blog or just point out the img link to the old domain.
     
    krishmk, Apr 14, 2009 IP
  4. SonnyCooL

    SonnyCooL Peon

    Messages:
    1,170
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #4
    ok ok ... thanks rep added :)
     
    SonnyCooL, Apr 14, 2009 IP
  5. SonnyCooL

    SonnyCooL Peon

    Messages:
    1,170
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #5
    unfortunately it won't work ....
    i just find no way to restore it :(
    basically i only have the old (8000) DB in gz files format ...
    any solution?
     
    SonnyCooL, Apr 14, 2009 IP
  6. armybase

    armybase Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    the easy way is, importing your DB through phpmyadmin and adjust your wp-config.php accordingly, that's it.
     
    armybase, Apr 14, 2009 IP
  7. SonnyCooL

    SonnyCooL Peon

    Messages:
    1,170
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #7

    i try but it ain't work on wp 2.7.1 :(
    finally i use wxr and split the db to 50 part then upload ....
    thanks everyone (sorry get a day ban cause of my porn signature, but i still not sure with signature is porn :()
     
    SonnyCooL, Apr 15, 2009 IP
  8. kumarsaran

    kumarsaran Peon

    Messages:
    145
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Use the following steps,

    1. Take a DB back up of your current blog.
    2. Import the database in the new host. mkae sure it works standard mysql command helps.
    3. Configure wp-config.php in current blog, and edit the DB host to new place.
    4. Take folder backup of your current blog
    5. Restore the file backup in new host.
    6. edit the wp-config.php to look for localhost


    Our Team has moved http://blogbloke.com/ using these steps. A well known blogges with about 2500 active posts. Without any down time we completed the activity.

    If your old host uses Cpanel, moving them will be easier with cpanel backup tools.
     
    kumarsaran, Apr 16, 2009 IP
  9. ~kev~

    ~kev~ Well-Known Member

    Messages:
    2,866
    Likes Received:
    194
    Best Answers:
    0
    Trophy Points:
    110
    #9
    You used the wordpress export feature in your old site, saved the export file, then went to the new site and tried to import the file?

    The import button is in the left hand column, under "Tools". When you click the import button, a new window will open. At the very bottom bottom of the "Import" page, wordpress is listed. Click "Wordpress".

    Click the browse button, go to where you saved the exported file on your computer and upload the file.

    If you have just a database, install wordpress on your web server and restore the database on the server. Then use the export feature of wordpress to create the export file.

    In other words, use the old database to recreate the site, and use the wordpress admin features to get your export file.
     
    ~kev~, Apr 16, 2009 IP
  10. SonnyCooL

    SonnyCooL Peon

    Messages:
    1,170
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #10
    yah this work but a lot headache due to upload limit :)
    but it won't work in changing config setup (
     
    SonnyCooL, Apr 16, 2009 IP