OK to directly delete faqdata rows using other tool?

[anroy]

Hi, newbie here.

First of all, thanks for your great work in providing this product.

Now for the problem. 8)

We have a business process where we need to regularly delete and add large numbers of records. (The reasons are complicated).

I do not see a way to do a bulk delete of many (or all) FAQ records. It seems I need to open each one, and press the delete button. Given the size of our FAQ data this would take insanely long.

Would it be OK to do a bulk delete of many (or all) rows from the faqdata table, using another tool like phpMyAdmin, or the MySQL command line, etc?

phpMyFAQ seems to have a very large number of tables. It is not clear what they all do, or the relationships between them and with the main faqdata table. Needless to say I do not want to damage anything!

[anroy]

Hi, does anyone have the answer to this?

[Thorsten]

Hi,

here are all related DELETE queries: https://github.com/thorsten/phpMyFAQ/bl ... q.php#L871

bye
Thorsten

[anroy]

OK thanks. That is exactly the info I needed!

[anroy]

In case it helps anybody, here is a script that I am using to completely empty an FAQ database using external tools like phpMyAdmin.

Code: Select all

DELETE FROM faqchanges;
DELETE FROM faqcategoryrelations;
DELETE FROM faqdata;
DELETE FROM faqdata_revisions;
DELETE FROM faqvisits;
DELETE FROM faqdata_user;
DELETE FROM faqdata_group;
DELETE FROM faqdata_tags;
DELETE FROM faqcomments;
DELETE FROM faqvoting;