Help!

Hello;

Is there a script (PHP or CGI) to export the contents of a MySQL database to a text file? I want to crontab a script that will dump the contents of the database into something accessable, because:

My site is powered by Mambo site server. This has an index.php page, and calls a MySQL for content on it. In other words, if you were to look at the index.php file with a text editor, you would not see any of the content of my site; just the template for where it goes.

I also have a search script that spiders my site and stores (in another MySQL database) every word found on the site.

What this means is my search script has a massive database of every word in the templates--no content.

Is there any hope?

Thanks,
Louis Gabriel
webmaster@66thcadets.com

Use a different search script? This isn't meant to be rude, but seriously use another search script. You are looking for a method to hack up a search script to do something it wasn't designed to do. There are search scripts out there that handle dynamic data just fine...

If you do want to dump the contents of your table to a text file though, just open up a file with fopen(). Then, query your data base with mysql_query and associated commands. Then loop through the results and write them to the text file with fputs()...

Ah, good point.

You wouldn't happen to have a URL where I could download a good script to search a MySQL database?

Thanks a million,
Louis

Try this:

http://codewalkers.com/seecode/171.html