mySQL data dump/load

  • First, I am NOT a mySQL expert or even intermediate, so my apologies up front if this is a silly question. I was having a problem with my blog that I could not seem to fix, so I cleared all the WP tables out of mySQL after doing a data dump. I cleaned out everything else and did a clean install of WP. All seems great except I can’t insert the data back into the tables. I get a 1045 error, Access Denied (which I can’t find anything on, 1044 seems to be the popular one).
    I’m using PHPmyAdmin to administer. Any suggestions???
    Thanks in advance!

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

  • This might help:
    https://www.webmasterworld.com/forum23/3290.htm
    And of course the google search:
    https://www.google.com/search?q=1045+error

    Thread Starter tbubble

    (@tbubble)

    thanks for the advice. it turned out I had a different issue, so this may help someone else:
    if you do a mySQL data dump, you’ll end up with a file named ‘datadump.sql’ which is a text file. When you do a clean reinstall of WP, do NOT run the setup — once the tables are created in the database, the data file can’t read it. The data file will both create and fill the tables.
    If you deleted your database entirely, just insert the data.
    If you deleted your tables but not your database (like me), you will need to remove the line toward the top of the datadump.sql file that says
    CREATE database my_name
    because the file can’t create a database that’s already there.
    I did this through phpmyadmin, hope it helps.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘mySQL data dump/load’ is closed to new replies.