WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] URGENT wp-taxonomy deleted. How to add to tables??? (10 posts)

  1. mrkingid
    Member
    Posted 5 years ago #

    Long and stupid story on my part.

    wp_taxonomy got deleted from my database and the most recent backup I have is October.

    Neeadless to say I would rather just add it to my database than do a restore from the latest backup.

    What are the parameters of wp-taxonomy so I can add it to my database?

    name: wp_taxonomy
    number of fields: ????

    then:
    what are all the variables?

  2. mrkingid
    Member
    Posted 5 years ago #

    Please, Please, Please, Please, Please!!!!!!!!!!!!!

  3. iand
    Member
    Posted 5 years ago #

    Can you not read through your most recent database backup and find the section that creates the wp_taxonomy table?

    Copy that out and run it as an sql query through phpmyadmin or whatever you use to manage your database.

    Make sure you have a backup of your current database before you do it.

  4. mrkingid
    Member
    Posted 5 years ago #

    I have no idea if I can or not. i looked in the backup file and it is all greek to me.

    On top of that, for wathever reason, the backupfile is 18MB and phpmyadmin doesn't allow a file that size.

    Ugg

    Any WP gurus around?

  5. iand
    Member
    Posted 5 years ago #

    My clean install of 2.7 has no wp_taxonomy but I do have wp_term_taxonomy. Is that the one that you are missing or is wp_taxonomy the result of a plugin?

  6. mrkingid
    Member
    Posted 5 years ago #

    yes, term_taxonomy is the one I am looking for?

    any ideas?

  7. mrkingid
    Member
    Posted 5 years ago #

    OMG OMG OMG OMG. I was able to save myself from another WP install database.

    Phew... Thanks IAN your initial idea saved me.

    Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Now to find a decent backup plugin

  8. iand
    Member
    Posted 5 years ago #

    Trying to work out how to post sql code without it getting encoded...

  9. mrkingid
    Member
    Posted 5 years ago #

    No worries Ian. I was able to get it all working. Thanks for your time on this!!!!!

  10. iand
    Member
    Posted 5 years ago #

    Good to hear. If you can spare the time would you be so kind as to explain what you did?

    That way someone else with the same problem can get the benefit too.

Topic Closed

This topic has been closed to new replies.

About this Topic