• Home
  • Learn Joomla
    • Roadmap for New Users
    • Joomla Lingo
    • Joomla Installation
    • Joomla Administration
    • Joomla Documentation
    • Tutorials
  • How-to Videos
    • Index to Videos
    • Site Basics Videos
    • FAQ Videos
  • How Do I?
  • Site Showcase
  • Blog
  • Contact

Where does Joomla keep the articles?

PDF | Print | E-mail

One question that is often asked is, “Where does Joomla keep the articles, pictures, links, and so on that I put into it?”

The short answer is “different places.” Joomla keeps information from the articles and pages that you create in two places. First of all, the text of the articles are keep as records in a database. All Joomla sites use a database to keep a lot of the information that helps manager the site, and your articles (and links, and contact items, etc.) are in that database. Generally, the database is provided by a database called mySQL that is provided as part of your web hosting service. Joomla manages getting articles in and out of this for you automatically.

So, you will not find a “file” on your website that contains the text of your articles. It is stored away in the Joomla mySQL database.

Now, photos, icons, graphics, and things like that are not stored in the database. They are actually stored as files in the file system of your Joomla installation.

Different types of files are stored in different locations. Generally, photos, graphics, and icons that you add to your site are stored in the /images/stories folder (and other sub-folders under that which you may create).

Other Joomla extensions may store their data differently. Many of them use the mySQL database, some use individual files put in various folders, and many use both.

So, if you decide to backup your Joomla based website (always a good idea) or move it to another location, you have to move both the files that make up your site, and the information in the database. Now, if you are moving your site from one folder on a server to another folder on the same server, then generally you just have to move the Joomla files to the new folder.

But moving from one server to another requires you to move both the files of your Joomla site, and the information in the database.

For more information on moving your Joomla site, see the article on that topic.

 
New? Start Here ...
  • Roadmap for New Users
  • Joomla Basics
  • How Do I Do This?
  • Free Templates
  • Joomla Tutorial Sites
  • Find the Joomla Documentation
  • Templates & Design Issues
  • FAQ Videos
  • Joomla Books
Quick Access
  • What's New / What's Hot
  • Recent Good Stuff
  • John's Joomla Toolbox
  • Template Sources
  • Recommended Joomla Tutorials
  • John's Real Job
  • Site Feedback / Contact
  • Site Credits
Recent "Good Stuff"
  • How to use the expanded user profiles in Joomla 1.7
  • A new template from JoomlaShine and an update to their slide show
  • 2 simple plug-ins for administrator approval of new users
  • A new version of the free template JA Purity - Wow!
  • A very nice, "lite" administrative template
  • A very easy way to keep your Joomla install up to date
  • Add new power to your administrative control panel
  • A couple of great modules for your site
  • A Great Free Template from JoomlaShack: Optimus
Featured Articles
  • Joomla Lingo
  • Why Should I Use Joomla?
  • How do I change the footer text in a template?
  • What is the difference between a component, a module and a mambot / plugin ?
Joomla 1.5 Featured Articles
Top "How Do I?" Articles
  • How do I create a quick "logout" button for users?
  • How do I "move" a Joomla website from one folder to another?
  • How to change the Joomla date format
  • Where does Joomla keep the articles?
  • Changing the text of messages in Joomla
  • Making GIMP look like Photoshop
  • How do I put a picture in an article?
  • How to I create a custom page for a user to see after they submit a "contact us" message
  • Module Installation for Dummies
  • Set up a demo site that allows many people to use the same login
home | site map | contact

Welcome to Joomla is an interesting side project by John Muehleisen.  Who is this guy, anyway?

The Joomla!® name is used under a limited license from Open Source Matters in the United States and other countries.
WelcomeToJoomla.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.