Copying wordpress database from one website to another

  • Resolved ukndoit

    (@ukndoit)


    8 years, 8 months ago

    I have a website with lots of posts, users, etc.

    I have a new website designed with new pages.

    I wanted to copy all of the pages, posts and users over from my old website to the new one.

    So I copied from the old one to the new one, using phpMyAdmin.
    I had it overwrite the users table.

    One problem is the old table names start with amwp_
    the new ones are wp_

    anyhow, I don’t know what caused it, but the number 1 user, the main one, when I login to wp-admin it says I don’t have sufficient privledges now.

    that was the only table I overwrote…

    I made sure that the tables had the same exact columns and column names, which they did.

    I even changed back user id 1 the username from what it was on the old site to what it was before on the new site.

    still, same thing.

    so I changed the email from the old site email to what it was before on the new one.

    same thing.

    What did I do wrong that broke it?

    Thanks,
    Richard

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter ukndoit

    (@ukndoit)

    8 years, 8 months ago

    Okay, I figured it out, the Admin was id 2

    so I logged in with that user.

    That worked. I went to users and I see a bunch of accounts, but nothing populated in any of them.

    How do I get those account setup right?

    -Richard

    Thread Starter ukndoit

    (@ukndoit)

    8 years, 8 months ago

    I figured it out on my own. was a pain, until I realized how to do it.

    export -> open in text editor -> find/replace -> save -> truncate new table -> import file with changes -> worked.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Copying wordpress database from one website to another’ is closed to new replies.