Cannot figure out how to restore using phpmyadmin

  • rebmarmad

    (@rebmarmad)


    15 years, 11 months 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.

Viewing 4 replies - 1 through 4 (of 4 total)
  • esmi

    (@esmi)

    15 years, 11 months ago

    http://www.reg.ca/faq/PhpMyAdminTutorial.html

    Thread Starter rebmarmad

    (@rebmarmad)

    15 years, 11 months 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.

    maerk

    (@maerk)

    15 years, 11 months 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.

    Thread Starter rebmarmad

    (@rebmarmad)

    15 years, 11 months ago

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

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

The topic ‘Cannot figure out how to restore using phpmyadmin’ is closed to new replies.