1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need Help Converting SQL database into CSV

Discussion in 'Black Hat SEO Tools' started by Hollaatu, Jan 19, 2012.

  1. Hollaatu

    Hollaatu Registered Member

    Joined:
    Feb 25, 2009
    Messages:
    62
    Likes Received:
    17
    Can anyone guide me on how to do this?
    I need to convert thi SQL dump to something that I can import into wordpress as posts. Any suggestions would be really appreciated.
     
  2. ijof9

    ijof9 Power Member

    Joined:
    Mar 27, 2010
    Messages:
    536
    Likes Received:
    594
    Occupation:
    CTO
    Location:
    Western Europe
    1. get WP here
    2. install a WAMP package locally (EasyPHP is a good choice)
    3. create a new db & import the sql dump into MySQL
    4. copy wp-config-sample.php and rename it to wp-config
    5. edit wp-config.php - DB_NAME, DB_USER, DB_PASSWORD & DB_HOST (
    6. add into wp-config.php
    Code:
    define('WP_HOME','http://'.$_SERVER['HTTP_HOST']);
    	define('WP_SITEURL','http://'.$_SERVER['HTTP_HOST']);
    7. access http://localhost/wp-admin, login (reset your password if necessary; table wp_users - replace password with MD5(new password))
    8. Tools -> Export
    9. Rep + Thanks