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

[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

[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

[WarMace]

Thanks