copying sql database to new wp – issue with compatibility?

  • piriet

    (@piriet)


    14 years, 11 months ago

    I have just re-installed WP and want to upload a back up SQL file to restore my site — doing it as per Codex instruction with phpMyAdmin in iPage and this is the error msg i get:
    Error

    SQL query:

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

    /*!40101 SET NAMES utf8 */;

    —
    — Create and use the backed up database
    —
    CREATE DATABASE wrd_an3flcgj6o;

    MySQL said:

    #1044 – Access denied for user ‘wrdVK8X75jK’@’10.%’ to database ‘wrd_an3flcgj6o’

Viewing 6 replies - 1 through 6 (of 6 total)
  • psampaio

    (@psampaio)

    14 years, 11 months ago

    It seems to be a problem with permissions, can you check what are the permissions for this user?

    Are you using phpmyadmin, mysql from console, or another mysql client?

    Thread Starter piriet

    (@piriet)

    14 years, 11 months ago

    ummmm… there is one user for that database: wrdVK8X75jK and “set privileges” radio buttons are all set to yes.

    i thought i was using phpmyadmin … i go from the control panel in iPage to MySQL beta and from there access phpmyadmin.. does that answer the question?

    maoski

    (@maoski)

    14 years, 11 months ago

    Hi, if creating a new database, did you delete the old database first? if importing into an existing database did you delete all the existing tables first?

    Thread Starter piriet

    (@piriet)

    14 years, 11 months ago

    no:( i didn’t delete anything.

    realized about an hour ago the database i was trying to upload into another database (it took me a while to realize this was silly) already existed. so.. i changed the details in the wp-config file to match the database I thought i was already uploading only to find that it didn’t change anything at all… weird.

    i have since opened the sql file with text edit and found a lot of my content intact there so I don’t know if i should just try and cut and past that back into the new WP or keep trying to sort out the upload.

    when i realized the database i was trying to upload already existed and tried to point the site to it (and found it to be not helpful) i deleted it, thinking i could re-create it using the backup but iPage won’t let me because it says it already exists.

    any suggestions?

    maoski

    (@maoski)

    14 years, 11 months ago

    can you create a new blank database in myphpadmin, rstoring a databse from backup requires a blank database (no tables). You can name the databse whatever you want as long as you put that new name in wp-config file.

    Thread Starter piriet

    (@piriet)

    14 years, 11 months ago

    maoski and psampaio i really appreciate the help. I think I need to start fresh, there is something else going on here as well as this back up, i think something has damaged a lot of files or something because every new version of WP locks me out with fatal error messages as soon as i add anything from a past version.

    thanks!!

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

The topic ‘copying sql database to new wp – issue with compatibility?’ is closed to new replies.

Tags