copying wordpress database to a new server

  • Resolved simon.ker

    (@simonker)


    12 years, 5 months ago

    Ok hopefully I am missing something very simple but I am having trouble copying my WP database from Strato to Godaddy. (i am having speed issues on godaddy so i want to compare the two before i ditch godaddy and upgrade my strato account).

    using phpMyAdmin i have made a backup of my strato DB and using the instructions found here i am trying to upload this database to godaddy.

    When i click go at point 8 it pauses for a minute or so and then gives me this error message…

    “MySQL said:
    #1044 – Access denied for user ‘u876876876’@’%’ to database ‘DB876876876’ “

    Am i right in thinking that i need to make sure the username and password on the godaddy server match those on the existing strato server? – If so i have the following problem..

    Strato forces the UN to be uppercase (U876876876) and Godaddy forces it to be lowercase (u876876876) would this account for the error above and if so is there a way that i can change the UN in either of the databases to fix this?(maybe using phpMyAdmin?)

    Sorry if this has been posted elsewhere… I had a look but couldn’t find anything. And thanks in advance.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Brad Markle

    (@imh_brad)

    12 years, 5 months ago

    “MySQL said:
    #1044 – Access denied for user ‘u876876876’@’%’ to database ‘DB876876876’ “

    The 1044 Access denied error sounds as if your database user may not have privileges set for your database.

    When working with databases, you generally need to have these 4 things set:
    1. A database needs to have been created
    2. A database user needs to have been created
    3. Your database user needs to have been assigned with specific privileges to the database (for example, the user needs to be able to “SELECT” and “UPDATE” the database.

    Am i right in thinking that i need to make sure the username and password on the godaddy server match those on the existing strato server?

    The database username and password do not need to be identical.

    If they are not identical, you’ll need to update your wp-config file with the new database username and password.

    Go Daddy

    (@gdhosting)

    12 years, 5 months ago

    I suspect that the database export you created with phpMyAdmin has two lines in it that prevent an import to a database with a different name. As an example, these lines are in a database of mine that I just exported:

    CREATE DATABASE MY_DATABASE_NAME DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    USE MY_DATABASE_NAME;

    When you try to import the database, you’re asking to import the data into a database using that name, and since the name is different, the import fails. Luckily, all you have to do is remove those two lines (for me, lines 21 and 22) from the .sql file, and the import should work just fine.

    So here’s my recommendation. First, make a backup of your backup (just in case). Then erase those two lines completely and save the file. Try the import again. Report back on the results.

    Thread Starter simon.ker

    (@simonker)

    12 years, 4 months ago

    Thanks @go Daddy … That worked a treat…

    Unfortunately, however, after uploading the database from strato to go daddy I have found that the same site runs about half the speed on go daddy which is a bit annoying. I will have to take it up with customer support i guess.

    Thanks for your help

    Go Daddy

    (@gdhosting)

    12 years, 4 months ago

    Well, I’m happy to hear that we got you past the importing issue 🙂 Thanks for coming back to let us know.

    As for the speed, is there any chance you’re on a Windows hosting plan? If so, I’d recommend switching over to Linux for the best possible PHP performance (here’s how – http://x.co/bUpr ). If that’s not it, it’s possible there has been a load spike or some other condition that temporarily slowed things down. I agree, though, that contacting our Support staff is the best way to proceed.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘copying wordpress database to a new server’ is closed to new replies.