Just bought a wordpress site from flippa. Trouble with database transfer

Discussion in 'Databases' started by trident, Apr 22, 2011.

  1. #1
    Hey everyone. SO I just bought a wordpress site from flippa and basically went through the procedure for transferring the wordpress files and database over to my host.
    I created a new database, assigned a new user and password to it, edited the wp_config.php file to reflect the new database info. Then i created a new subfolder under my public htlm, uploaded the wordpress files and extracted them.

    Then I went to phpmyadmin and uploaded the sql database file but got the following error -

    SQL query:

    INSERT INTO `wp_options` (`option_id`, `blog_id`, `option_name`, `option_value`, `autoload`) VALUES (4207, 0, '_transient_feed_ba689deb49370c4081cd11c8a4bac1ba', 'a:4:{s:5:"child";a:1:{s:0:"";a:1:{s:3:"rss";a:1:{i:0;a:6:{s:4:"data";s:3:"\n \n";s:7:"attribs";a:1:{s:0:"";a:1:{s:7:"version";s:3:"2.0";}}s:8:"xml_base";s:0:"";s:17:"xml_base_explicit";b:0;s:8:"xml_lang";s:0:"";s:5:"child";a:1:{s:0:"";a:1:{s:7:"channel";a:1:{i:0;a:6:{s:4:"data";s:117:"\n \n \n \n \n \n \n \n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n ";s:7:"attribs";a:0:{}s:8:"xml_base";s:0:"";s:17:"xml_base_explicit";b:0;s:8:"xml_lang";s:0:"";s:5:"child";a:2:{s:0:"";a:7:{s:5:"title";a:1:{i:0;a:5:{s:4:"data";s:54:"WordPress › Support » Tag: lightword - Recent Posts";s:7:"attribs";a:0:{}s:8:"xml_base";s:0:"";s:17:"xml_base_explicit";b:0;s:8:"xml_lang";s:0:"";}}s:4:"link";a:1:{i:0;a:5:{s:4:"data";s:35:"http://wordpress.org/tags/lightwo[...]

    MySQL said: Documentation
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'This link will take you to the URL http://validator.w3.org/check?verbose=1&#' at line 2

    My questions are

    1) I dont know anything about sql, can anyone tell me what I can do about this error?

    2) If in case, I cannot restore the database for any reason, can i manually just recreate the site? ie.e I havnt yet changed the nameservers on it so the site is still up on the old owners host. There are about 40-50 posts on the blog. Can I just do a fresh wordpress install on my host using simplescripts and then copy paste all the posts over making sure the links stay the same and then finally change the nameservers? Will that have any effect on page rank?

    3) This person has sold some links on fiverr. Some of the posts on the blog have are created by people who have paid him five bucks to have their links on there. Can I just blow those out since I own the blog now (if its a post, that i think does not fit with the theme of the blog?)

    thanks a bunch
     
    trident, Apr 22, 2011 IP