Where Does All Information Stored In Joomla?
January 1, 2010 under FAQ
For example I’m going into the modules or static content! And create an article and than save it and do what ever! Or lets say some other people create articles and faq’s or any type of information where does it get saved? Can I access it through ftp on my server and look at it without going to joomla admin or website? can I edit anything without joomla administration?
Search more about Where Does All Information Stored In Joomla?:
The data gets stored into a database on your host. You can access that information through the myPHP admin. To find it, goto your Database section of the hosting service control panel and select edit on the Joomla database. From there, you login using the database username and password and goto the jos_content table. Click on browse and you will see the various articles of the website.
If you are looking to modify this information it is much easier to do it from the installation.
The articles go into the mysql database you created on startup.
You could use a php admin tool such as phpMyAdmin via your web browser to access the database or several of many tools.http://www.phpmyadmin.net/http://www.mysql.com/
If you are on linux, you could do something like this:
>> echo “SELECT foo FROM bar” | mysql -h sql.server -uUserName -pPassword Database > foo.bar
This would output the query to a text file.
There is probably a way to do this from a command line in Windows also. (with mysql installed.)