milkyway_thumbnail.pngThe sample content in Joomla is handy to have while previewing templates in the early stages of development, but once the site is being spidered by search engines it's good to make sure no sample content is published or it could hurt SEO.

To make things less cluttered the sample content can be moved to the Joomla trash.

* Categories cannot be deleted until all Articles within are emptied from Trash (permanently deleted).

* Sections cannot be deleted until all Categories within are deleted.


When deleting content:

  • delete Articles first
  • then delete Categories
  • delete Sections last
Other sample content to delete:
  • Banner sample content ( Components > Banner > [Banners, Clients, Categories] )
  • News Feeds sample content ( Components > News Feeds )
  • Polls sample content ( Components > Polls )
  • Web Links sample content ( Components > Web Links )

 


SQL statements to remove all Joomla 1.5 sample content in one step

!
Be careful with this. Backup the entire database first.

! Don't use this method if you have added content you want to keep as this will delete that as well. Use the manual method above.


This would be used in phpMyAdmin (in cPanel) or similar database management utility.

DELETE FROM `jos_banner`;
DELETE FROM `jos_bannerclient`;
DELETE FROM `jos_bannertrack`;
DELETE FROM `jos_categories`;
DELETE FROM `jos_content`;
DELETE FROM `jos_content_frontpage`;
DELETE FROM `jos_newsfeeds`;
DELETE FROM `jos_polls`;
DELETE FROM `jos_poll_data`;
DELETE FROM `jos_poll_date`;
DELETE FROM `jos_sections`;
DELETE FROM `jos_weblinks`;

screen capture from phpMyAdmin
Screen capture of the SQL statement to delete all sample content in Joomla 1.5

proudly-canadian-flag.gif
Best Canadian Web Host for Joomla



Joomla Web Hosting Canada RSS Feed