How do I delete all listings in my directory?

The quickest way to clear all listings in your directory is by running these SQL queries queries to your database:

TRUNCATE TABLE `jos_mt_cl`;
TRUNCATE TABLE `jos_mt_links`;
TRUNCATE TABLE `jos_mt_cfvalues`;
TRUNCATE TABLE `jos_mt_cfvalues_att`;
TRUNCATE TABLE `jos_mt_favourites`;
TRUNCATE TABLE `jos_mt_images`;
TRUNCATE TABLE `jos_mt_links_associations`;
TRUNCATE TABLE `jos_mt_reviews`;

The query above assume you have 'jos_' as your database table prefix. Replace it with your site's database table prefix before running the queries.

If your listings contain images or attachments, go to these directories on your server and delete all files:

Warning: Running the above SQL queries will remove all listings in your directory. Make sure you know what you're doing before running it.

Was this article helpful?