Exporting Database

Hi. I’m kind of new here so my apologies if this isn’t the right place to post this. I would like to export the site’s product database so I can create a product feed. The only thing I can find about exporting is exporting to static html which seems like big-time overkill since I just want the database. I don’t need the server sitting there hammering out a static version of every page. When I connect via FTP and try digging around, many folders have an index file that says "Unauthorized access You’re not allowed to access file folder" which is absurd. My user is an administrator. The question then ends up being kind of two-parted. 1. How do I export / copy the database without hammering the server with a request to build the entire site as static html? and 2. Why can’t I access everything via FTP? We’ve got 0.9.6.3. Thanks.

As a rule, you can’t use FTP to access the database. The database is at some level a series of files, but you never access it directly as such. MODx does supply a tool to dump the database as ganeshXL pointed out. You can also use other GUI tools such as phpMyAdmin or the mysqldump command line tool. I prefer the latter because it doesn’t suffer from the same memory restrictions that a web-based tool does.

The reason that many web apps include seemingly pointless index.php files is not just to torque you off: sometimes webservers are configured to list directory contents if there isn’t a valid index file, e.g. http://yoursite.com/some/folder/no/doc/specified/ (note the trailing slash identifies that as a folder). Most servers will serve the index file as the default page, but some of them will show the directory contents if they don’t have an index file (i.e. the server "indexes" the directory for you), and THAT can be a bad security breach. Make sense? It has nothing to do with your user role.

Lastly: UPGRADE THY VERSION.