Having trouble restoring an sql backup via phpMyAdmin on a Bitnami stack install

  • mguise

    (@mguisemattguisecom)


    10 years, 5 months ago

    I successfully installed WordPress 4 locally on my Apple OS X 10.9.5 via Bitnami but now I am having trouble restoring a backup.

    I created a database with a name that is different than the one I used when I backed up the wordpress site with BackWPup. I did this because I am I am currently using that database name for another site. I was successfully able to import the sql file into the new database I created. For some reason I am unable to login to the WordPress site with a username and password. As far as I can tell I put the correct db_name, db_user, db_password, db_host, etc. in the config file.

    Could it be because I created a database with a different name?

    I thought I could try changing the database user and password so I can get into wordpress that way. I log into phpMyAdmin, click on my database, click on wp_users and I get the following message “MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 seconds.)”

    I would like to restore my backup but I don’t know what gives. Thanks for your help in advance.

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

  • In wp_options table in Database have you changed the home and siteurl?

    Because changing the name of database is not a problem as long as you update the database name in the wp-config.php file.

    Thread Starter mguise

    (@mguisemattguisecom)

    Thanks for replying CMSHelpLive Member.

    The site url looks ok.

    Correct me if I am wrong but when I put the following url in the browser, https://localhost:8080/wordpress/wp-admin/ and it directs me to the Wodpress Login, doesn’t that mean I successfully connected to the database? If that is the case, how can I a. retrieve my wordpress username and password or b. change the wordpress username and password so I can get in.

    I thought I could do this by changing the database user and password .

    However if I log into phpMyAdmin, click on my database, click on wp_users and I get the following message “MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 seconds.)”

    Thanks for your help.

    Thread Starter mguise

    (@mguisemattguisecom)

    I was able to figure this out by going here https://www.wpbeginner.com/wp-tutorials/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/

    I hope this helps someone who has the same problem.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Having trouble restoring an sql backup via phpMyAdmin on a Bitnami stack install’ is closed to new replies.