Book Image

Joomla! 1.5 Cookbook

By : Tom Canavan
Book Image

Joomla! 1.5 Cookbook

By: Tom Canavan

Overview of this book

If you are a Joomla! site owner, you must already be aware of how this robust, easy to use, open source content management system can help you build a great looking site instantly. You must also be aware of the many problems that it can throw up from time to time. Find the solutions to all your basic and advanced Joomla! queries, so you don't have to wait for someone on the forums to help you out every time.The Joomla! 1.5 Cookbook will provide you with quick and direct solutions to the most common and uncommon problems faced by you, the Joomla! site owner, sidestepping all the theoretical fuss.Joomla! is the insanely popular, award winning content management system which helps you build professional looking websites, even if you don't have any HTML programming experience or design skills.Although, sometimes you might trip over some common pitfalls which would slow the progress of your website down. This book will help you find a direct and quick way through these common problems which can be easily avoided with a few tips and tricks. It starts of with solutions the most common queries that you might face during the installation and setup for Joomla! 1.5 moving on swiftly to guide you through Joomla! templates, modules, security, managing your users and much more. So the next time when things go wrong with your Joomla! site and you are wondering, for example, how to work with your site's database; just pick up this book and quickly find your way through this.
Table of Contents (18 chapters)
Joomla! 1.5 Cookbook
Credits
About the Author
About the Reviewer
Preface
Index

Removing a table from your database


Occasionally you might experience a Joomla! extension that does not uninstall properly. This can happen for many reasons and if it needs to be removed, it must be removed manually. Other instances might be where you uninstalled an extension, but it left behind its tables intentionally yet they need to be removed for any number of reasons.

Tip

This is an ADVANCED and DANGEROUS task. Using this command will result in the data in question being permanently removed from your database. BEFORE USING THESE COMMANDS BE SURE AND BACKUP (export) YOUR DATABASE

In this recipe we will look at the command line method to delete or remove a table. The term is 'drop' which means delete or remove. We will remove an imaginary extension table from our database called jos_Corn_Syrup. The situation is we have removed our extension called Corn Chart, used to track the corn fields for farmers. However, the programmer wrote our extension so that it purposely leaves behind the tables...