Cannot figure out how to restore using phpmyadmin (5 posts)

  1. rebmarmad
    Posted 6 years ago #

    I made the stupid mistake of thinking it would be easy to restore my blog from a WordPress backup. I made the backup and ended up with an sql.qz file. Later, I learned that I needed to install wp-phpmyadmin to restore, so I did. Now, I have no permissions to create a new database, nor do I have permission to restore the old one. When I try to restore, I get this error message:

    #1044 - Access denied for user 'yscr_bbaq0z'@'localhost' to database 'blog3'

    Who the heck is 'yscr_bbaq0z'@'localhost' and what do they have to do with my blog?

    I've spent a week looking online trying to find something that just walks me through the process step-by-step, but I cannot seem to find really simple instructions, such as "Go to this file and change this line" or "Go to this tab and in x field, type xxx."

    I am NOT a programmer and I wouldn't know sql from my elbow. I am about to despair that I will ever get my blog content back. I need phpadmin and restore instructions for dummies, please. I can't believe that after the fuss WP makes about backing up your files, there are no simple, clear instructions for a restore.

  2. esmi
    Forum Moderator
    Posted 6 years ago #

  3. rebmarmad
    Posted 6 years ago #

    Thanks. It's certainly worth a shot--these instructions look much clearer than anything else I've seen. I will follow them and let you know how it goes. My problem may also be that I'm running the plug-in WP-phpmyadmin, and it may be a little different. But we shall see. I used to think I was pretty good at sorting this stuff out.

  4. maerk
    Posted 6 years ago #

    Don't forget to get in touch with your host, they should be able restore databases from SQL files, or at least show you how.

    By the way, 'yscr_bbaq0z'@'localhost' is your database user -- you'll likely never need it, but it's basically the username your host assigned to you so that you can use the database.

  5. rebmarmad
    Posted 6 years ago #

    Tutorial didn't help. Sorry. It just told me how to create a new database.

Topic Closed

This topic has been closed to new replies.

About this Topic