Moving wordpress

  • rdkilby

    (@rdkilby)


    14 years, 5 months ago

    I need to move a couple sites to a new server. I have backed up the database per the instructions in the codex. The problem is restoring the database on the new server. I get an access denied message. I have tried the same username/pw config that the old server had as well as different username/pw configs. In the codex about restoring the database it doesn’t mention a username and pw at all. My error is below.

    Error

    SQL query:

    —
    — Database: kilby_family_blog
    —
    CREATE DATABASE kilby_family_blog DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

    MySQL said: Documentation
    #1044 – Access denied for user ‘kilby_blogger’@’%’ to database ‘kilby_family_blog’

Viewing 3 replies - 1 through 3 (of 3 total)
  • wordprest

    (@wordprest)

    14 years, 5 months ago

    well,

    you have to specify new credentials for new db…

    Mark Ratledge

    (@songdogtech)

    14 years, 5 months ago

    Your database hasn’t been created. wp-config.php presents your database login and password, etc., but your database has to be created first. Ask your hosting company to be sure the “blank” database has been created; once it has been created, then WP can write the tables to it.

    imaginhost

    (@imaginhost)

    14 years, 5 months ago

    Hello, first you do have to enter your new database details in wp-config.php, but did you also make sure to set the new location for your WordPress installation under the “Settings” page before you exported the database? It’s a good idea to export the database before (as a backup, just in case) and after you change the location settings in your WordPress installation, then import your database at your new host and enter your new database details in wp-config.php. I hope that helps. Good luck with your site!

    [sig removed per forum rules]

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Moving wordpress’ is closed to new replies.