Support » Installing WordPress » Where do I place a copied WP database file to?

  • Resolved chrisboggs

    (@chrisboggs)


    What I hope is a simple question:

    I have copied a WP install from another server before successfully. The old administrator of the site I am moving this time zipped up all old files and placed the DB into a seperate folder.

    I need to know where (in the typical WP file structure) I should place those mydb.sql files? In a site’s root folder? Once I know where to do this I will go ahead with usuall wp-config.php update and table fin-and-replace tasks.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Thread Starter chrisboggs

    (@chrisboggs)

    I have figured this out.

    New problem:

    I log in as “admin” but do not have admin priveledges, just subscriber. Where do I correct this and how?

    Thanks again! -c-

    Thread Starter chrisboggs

    (@chrisboggs)

    Thanks Esmi but nothing is mentioned in that post about my “New problem” mentioned in my previous post. Thanks you, -c-

    That’s because your second post was caught in the spam bin. I was answering your first post.

    Did you login with the original admin’s login credentials?

    Thread Starter chrisboggs

    (@chrisboggs)

    Oh, sorry Esmi. Sure did! I’m only being allowed to see a “subscriber’s” dashboard features. I imagine I could correct this problem somehow with phpMyAdmin in the database somewhere but I do not know how 🙁

    You need to look in the wp_usermeta table for the meta_key wp_capabilities where the user_id = 1. Change the meta_value for this record to

    a:1:{s:13:"administrator";b:1;}

    Thread Starter chrisboggs

    (@chrisboggs)

    okay, did that and now I recieve “You do not have sufficient permissions to access this page.” Perhaps I did it incorrectly? I will look for posts that offer solutions to this output. Thanks, -c-

    Thread Starter chrisboggs

    (@chrisboggs)

    Nevermind! It’s fixed by following your advice to the letter. I’m tired and I copied your code from an email and, of course, supplied etra text garbage but didn’t realize it. I went back and did it correctly and it worked. Thanks again Esmi!

    You’re welcome. 🙂

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Where do I place a copied WP database file to?’ is closed to new replies.