how to import MYSQL database 's content in existing new working databse

  • Hi friends!
    I got the problem, i had two database DATABASE A and DATABASE B, DATABASE B is working from last 3 months and had 500+ posts, DATABASE A (contains 4000+ posts )is from my old WP Blog, Now I want to import the content from DB A to DB B. i use phpadmin but got error due to similar tables in both Database.

    I am not expert in mySQL try different methods by following W3 Schools and other SQL instructions sites . but every time got error.

    Please tell me easiest way to import DATA in Database B without error of similar table, already exist table, columns/rows exists,…. etc

    How I merge both DATABASES
    THANKS

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

  • Why not export the post from wp and import in your new WP?

    so, you want to import the posts and pages?

    if yes, use wordpress fiture, export and import on your admin dashboard tools (you need wp-import plugins). its more easy than use PMA (PHPMyAdmin)

    Thread Starter muqeetsoomro

    (@muqeetsoomro)

    yes! i want to get only posts and pages
    what is “wordpress fiture” I try found in plugins but not found it.

    Thread Starter muqeetsoomro

    (@muqeetsoomro)

    Why not export the post from wp and import in your new WP?

    because that server is fully crushed but server administrative send me backup of that WP Blog

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘how to import MYSQL database 's content in existing new working databse’ is closed to new replies.