How to add some questions to qa_posts in the phpMyAdmin

Question

Hello

I did write a number of questions in the .txt file about 500 question, to post its later to my website.

How I can add these questions once to the Table: qa_posts in the phpMyAdmin without post its one by one to the website

Thank you.

Answer 1

It's not easy to do as the database format is quite complex. What I would do is make a CSV file in Excel/LibreOffice that follows the structure of the table ie the same 32 columns like postid, type, parentid, ...

Most of the columns can be left blank. But make sure that questions and answers are linked together correctly, so each answer has a parentid which is the postid of the question.

Save it to a CSV, then you should be able to import it into phpMyAdmin.