Can't find WordPress database in phpMyAdmin

  • Sinaasappel

    (@sinaasappel)


    10 years, 10 months ago

    I’m currently trying to move the live version of my website to local using XAMPP and the Codex instructions. It’s the first time I’ve ever done something similar and it takes me a lot of time to complete each step because of how long it takes before I even understand them. I’ve successfully set up XAMPP and opened phpMyAdmin, but now the instructions are telling me:
    Choose the name of your WordPress database.
    From the tags at the top of the screen, choose Export.

    I can’t find what they mean with the WordPress database? There are a few databases under the database tab but none of them seem to contain anything WordPress-related. I’ve tried opening phpMyAdmin through cpanel and by typing localhost/phpmyadmin. Did I forget a step? What is the database usually called?

    This is probably a pretty silly question, but I just can’t seem to figure it out!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Krishna

    (@1nexus)

    10 years, 10 months ago

    Can you locate your wp-config.php file? If yes, look for the database name there. And look for the same name to open your database using phpMyAdmin.

    Thread Starter Sinaasappel

    (@sinaasappel)

    10 years, 10 months ago

    I found it! Thank you 🙂
    I now have the problem that I’m being sent to the XAMPP homepage whenever I try to login at localhost/folder/wp-login.php but I’ll try solving that myself before opening another topic, haha 🙁

    2ninerniner2

    (@2ninerniner2)

    10 years, 10 months ago

    I’ve successfully set up XAMPP and opened phpMyAdmin, but now the instructions are telling me:
    Choose the name of your WordPress database.
    From the tags at the top of the screen, choose Export.

    From the above, it would seem you are at the incorrect spot in the instructions, as what you want to be doing now from within the phpMyAdmin of your XAMPP is to IMPORT the database file that you EXPORTED from your live site 🙂 This is why you are not seeing any WP databases.

    From here, you want to select Create Database, enter a name (the value in your wp-config file mentioned above), then Create. Once that is done, select that database (left pane list) and then select the IMPORT tab. Choose the .SQL file that you downloaded from the live site and click GO.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Can't find WordPress database in phpMyAdmin’ is closed to new replies.