WordPress.org

Forums

SQL tab in MyPHPadmin not like examples (7 posts)

  1. janetm
    Member
    Posted 8 years ago #

    I've downloaded my databases from my host server for use on a local installation of WordPress. Got WordPress running locally (with WAMP5 1.6.5) but I can't figure out how to get it to connect with my SQL databases. Instructions on WordPress.org and elsewhere talk about clicking the SQL tab in myPHPadmin, but all I get there is a window for writing a SQL query, rather than having a box for selecting (and uploading) the database. Help, please, before all my hair turns white.

  2. MichaelH
    Member
    Posted 8 years ago #

    It will be interesting to see if you get responses at http://www.wampserver.com/phorum/read.php?f=2&i=13564&t=13564

  3. janetm
    Member
    Posted 8 years ago #

    It'll be interesting to see if I get any responses anywhere! :)

  4. MichaelH
    Member
    Posted 8 years ago #

    Just for grins, paste a screenshot of your phpMyAdmin screen somewhere (e.g. photobucket).

  5. janetm
    Member
    Posted 8 years ago #

  6. MichaelH
    Member
    Posted 8 years ago #

    Actually looks okay to me. And it looks like your WordPress tables are there. You can click on any of the database tables to the left to maintain them if necessary or click on the link Database: foodperson to see all the tables listed.

    In you wp-config.php your DB_HOST will be 'localhost' your DB_NAME will be 'foodperson'.

    The DB_USER and DB_PASSWORD are whatever you assign somewhere in your WAMP installation I guess. On my xampp, the DB_USER is 'root' and no password (DB_PASSWORD is '').

    Your $table_prefix is 'wp_'

  7. janetm
    Member
    Posted 8 years ago #

    Thanks, Michael. It's all confusing, as the directions I find never seem to be of exactly the same versions of things as what I'm working with. I attemped xampp, too, but got confused there as well.

    As you say, I think my databases are there, but WordPress doesn't seem to see them. I'm obviously doing something wrong here. My suspicion is that I have them in the wrong folder.

    Anyway, I appreciate your help. I'll review your suggestions again tomorrow when I'm fresh, and if they don't help, I'm just going to go ahead and fiddle without using the databases I downloaded from my site. The local installation seems able to add posts etc. to wherever it's storing things, so I should be able to work on the theme one way or the other.

    Thanks again.

Topic Closed

This topic has been closed to new replies.

About this Topic