Page 1 of 1

Where is News stored in the MySQL DB? (Solved)

Posted: Tue Sep 28, 2010 3:41 pm
by WarMace
I'm trying to output all my news so I can play with the data, but can't find the data in MySQL.

I am using News v2.3.0.2
and
MySQL Workbench 5.2

Re: Where is News stored in the MySQL DB?

Posted: Tue Sep 28, 2010 4:01 pm
by Duketown
WarMace,

Have you tried the following in MySQL Workbench:

Code: Select all

SELECT * FROMĀ  `cms_module_news`
'cms' before '_module_news' is the prefix that is set for all the cmsms tables during installation (cms is the default, but could be something different as entered during the installation).

I you can't find it try phpMyAdmin if that is available.

Duketown

Re: Where is News stored in the MySQL DB? (Solved)

Posted: Tue Sep 28, 2010 5:44 pm
by WarMace
Thanks