Transfer Database Into WordPress Database. Help! How?

  • Hi
    I recently bought a recipe website – https://www.therecipeguide.com It has a database of recipes, 21,000.

    I am familiar with WordPress. I want to transfer these recipes into wordpress posts and categories.

    I did not make the intitial database. Nevertheless I have been supplied with the following information:

    – ingredients (table storing all ingredients)
    – id int(11) key
    – recipeid int(11)
    – ingredient varchar(255)
    – qty varchar(255)
    – measure varchar(255)
    – prepare varchar(255)
    – cardinal varchar(255)
    – grams varchar(255)

    – recent (used for storing all the recent searches)
    – id int(11) key
    – term varchar(70)

    – recipes (main recipe table)
    – id int(11) key
    – title varchar(255)
    – category varchar(255)
    – instructions blob
    – serves into(11)

    I have 3 questions.

    1
    I dont really know what all the above information means. How can I import database entries into wordpress?

    2
    I am far from being a MySQL expert but know how to import SQL with phpmyadmin, could I accomplish my mission through such a method?

    3
    Is wordpress incapable of holding such a large database?

Viewing 1 replies (of 1 total)

  • 1,2) Yes you can but it’s not a straightforward piece of work. You’ll need a set of (SQL) migration scripts to convert from the custom DB model to the WP DB model.

    Looking at the DB model that you’ve provided, it’s not going to be overly difficult but it will involve some work. It’ll probably be unlikely that someone will do this for free so you’ll probably to going to need to hire someone for this work.

    3) Yes.

Viewing 1 replies (of 1 total)
  • The topic ‘Transfer Database Into WordPress Database. Help! How?’ is closed to new replies.