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

Working with your database using phpMyAdmin


This recipe will show you some basic commands and operations you may need from time to time.

Tip

I strongly suggest you setup a test Joomla! site and test database to learn these commands. That way if you break something, you won't damage your production site.

In this section we'll look at a few basic commands and scripts you may need from time to time.

Getting ready

You will need the passwords for:

  • FTP

  • cPanel

  • Possibly your database (this can be obtained from configuration.php)

Depending on your hosting you may need your username and password for the database. Some hosts require it once you get into their control panel system and others do not. GoDaddy.com®, for instance, requires you to enter a username and password to interact with your database. Other webhosts do not require it, once you are logged into cPanel.

You will need a copy of your database (see the preceding warning). You can use the previous chapter on creation of a database and the two previous...