New posts w/tags via MySQL – bypass WordPress

  • I have a database with 100 pieces of content I want to use to create 100 posts. It would take a long time to cut and paste the content into the New Post window and then manually key in the keywords.

    Is there a way to use MySQL to create new posts using a series of SQL commands? With keywords? Post-dated, if I wished for 4 new posts to appear daily?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter aaron1728

    (@aaron1728)

    Hope no one minds my bumping this, since no replies in 3 months.

    I have a database with 100 pieces of content I want to use to create 100 posts. It would take a long time to cut and paste the content into the New Post window and then manually key in the keywords.

    Is there a way to use MySQL to create new posts using a series of SQL commands? With keywords? Post-dated, if I wished for 4 new posts to appear daily?

    emphasis mine.

    thats quicker than just pasting the content out of an sql dump? No.

    How do you expect MySQL to pick out keywords without you providing input?

    Thread Starter aaron1728

    (@aaron1728)

    I’d be willing to enter my own keywords. But I’d like to understand the data structure so that all the tables still link together properly.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘New posts w/tags via MySQL – bypass WordPress’ is closed to new replies.