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:
    72
    Likes Received:
    18
    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:
    596
    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