1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.
  2. Better Analytics for WordPress Get It Free

Need help moving Wordpress DB to new host

Discussion in 'MySQL' started by longroad, May 15, 2007.

  1. #1
    I bought a wordpress site off someone and Im having alot of trouble moving it to my host.

    He sent me the .sql file as well as the downloaded Wordpress files in a zip.

    So Ive uploaded the Wordpress files to my host but now need to restore the database.
    Ive looked at this site but this process isnt working for me.
    http://www.tamba2.org.uk/wordpress/restore/#two

    When I try to import the sql file i get this error:

    MySQL said: Documentation
    #1044 - Access denied for user 'user'@'localhost' to database 'db_wrdp1'

    (I changed the blog and username above).

    How do i import this database so that my site will be exactly like the one he had on his server?
     
    longroad, May 15, 2007 IP
  2. CodyRo

    CodyRo Peon

    Messages:
    365
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Does it have PHPMyAdmin? If so there is a "import" option where you can select the SQL file and it'll do the work for you.

    That error you specified means the information in "wp-config.php" is invalid (for the MySQL database)
     
    CodyRo, May 16, 2007 IP
  3. longroad

    longroad Peon

    Messages:
    1,645
    Likes Received:
    25
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Ive imported the database and the content is showing.

    But its not letting me login!
    I went into phpmyadmin and changed the admin password according to this tutorial:
    http://www.tamba2.org.uk/wordpress/phpmyadmin/

    But it still wont accept my login. And when I click Forgot Password and tell it to email it me it says my username or email is wrong!
    But the username and email is right there in the database.
    Why isnt it letting me login or resend a password? :(
     
    longroad, May 16, 2007 IP
  4. everypcneed

    everypcneed Peon

    Messages:
    238
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I can resolve this issue for you for a small fee. Let me know via PM if you are interested.
     
    everypcneed, May 16, 2007 IP
  5. jbroadbentshaw

    jbroadbentshaw Peon

    Messages:
    237
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #5
    it might just be that the name servers are taking a little while to update.
     
    jbroadbentshaw, May 17, 2007 IP