Results 1 to 7 of 7

Thread: Help - Populating a WP blog from MYSQL dumps

  1. #1
    tautology is offline Unknown Net Builder
    Join Date
    Jul 2009
    Posts
    10
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Help - Populating a WP blog from MYSQL dumps

    Hello,

    I have a couple of databases in MYSQL dump format(.sql). Could anyone give me a step-by-step method or a tutorial regarding how to use the database to start a new blog. (like a recipe blog or a jokes blog)

    Do you have to use a plugin to do the same ? Or is it to be done from the site's cpanel.

    Any help would be very much appreciated. Thank you.

  2. #2
    MeetHere's Avatar
    MeetHere is offline Newbie Net Builder
    Join Date
    Dec 2008
    Posts
    430
    Blog Entries
    1
    Thanks
    66
    Thanked 27 Times in 24 Posts
    Go to phpmyadmin
    drop all the tables
    then export your new tables/sql

  3. #3
    tautology is offline Unknown Net Builder
    Join Date
    Jul 2009
    Posts
    10
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hmm. I;m having no luck. After dropping all default wordpress tables, i've "imported" a .sql file which has just one table.

    How do i publish content from that table when I don't have the wordpress db tables in the first place ?

    Any attempts to access domain, prompts me install WP first.

    Any help would be appreciated. Thank you.

  4. #4
    MeetHere's Avatar
    MeetHere is offline Newbie Net Builder
    Join Date
    Dec 2008
    Posts
    430
    Blog Entries
    1
    Thanks
    66
    Thanked 27 Times in 24 Posts

  5. #5
    tautology is offline Unknown Net Builder
    Join Date
    Jul 2009
    Posts
    10
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I just imported a small little quotes db I had.

    table imported is - fam_quotes

    fields are id, author & quote

    As you would have gathered by now, my problem is how do you separate each tuple of the table and post it as a new post on the WP platform.

    Thanks in advance.

  6. #6
    MeetHere's Avatar
    MeetHere is offline Newbie Net Builder
    Join Date
    Dec 2008
    Posts
    430
    Blog Entries
    1
    Thanks
    66
    Thanked 27 Times in 24 Posts
    you can only import mysql dump which is exported from a wordpress blog... not just any dump

  7. Thanked by:

    tautology (18 November, 2009)

  8. #7
    tautology is offline Unknown Net Builder
    Join Date
    Jul 2009
    Posts
    10
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Ah. That explains everything then. Thanks a lot.

    Cheers.

Similar Threads

  1. Replies: 4
    Last Post: 23 January, 2010, 09:52 AM
  2. How to merge 2 MySQL dbs
    By ProxySites.ca in forum Proxy List Support Forum
    Replies: 1
    Last Post: 14 September, 2009, 15:16 PM
  3. ASP + MySQL
    By dodolls in forum Databases
    Replies: 0
    Last Post: 6 September, 2009, 23:12 PM
  4. I Want Your PHP/MySQL Epiphanies!
    By zac439 in forum Programming
    Replies: 1
    Last Post: 30 April, 2009, 16:48 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •