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

Introduction


In the first chapter and recipes, you were shown how to setup a database and establish users. The tool for driving this is called, phpMyAdmin.

phpMyAdmin is a popular, open-source tool that is a standard on most web hosts. Written in PHP, it enables you to handle all the administration of your MySQL database, keeping you from working in the command-line mode.

Here is an example of a command for setting up a new user:

CREATE USER 'jcookbookadmin'@'localhost' IDENTIFIED BY 'MyPassword';

or creating a database

CREATE DATABASE jbookdb;

or assigning privileges to it

GRANT ALL PRIVILEGES ON 'jbookdb' . * TO 'jcookbookadmin'@'localhost';

As you can see, attempting to remember all those commands is probably more than you want or need.

As Joomla! is primarily a database-powered system, from time to time you will need to know your way around phpMyAdmin for some of the tasks you may face.

One important item that phpMyAdmin can help you with is exporting your database. What this means is backing...