Database export for posts/threads from last month?

[Eikinskjaldi]

Originally Posted by dutchbb

Thank you, however how would I do the export to an sql file from that query?

What do you mean by "sql file"?

You can export it in tab delimted format in two ways.
WAY 1
1) Write the query into a file, lets call it latestposts.sql (make sure you terminate the line with a semi colon)
2) invoke mysql redictecting input from the above script and redirecting the output to a result file

mysql -uusername -ppassword mydatabase < latestsposts.sql > results.txt

WAY 2
use the into outfile syntax directly from within mysql
select * from post where unix_timestamp(now()) - dateline <= 2592000 into outfile '/path/to/directory/results.txt'

Alternatively, capture it in vbulletin/php

PHP Code:

$db->query_read("select * from post where unix_timestamp(now()) - dateline <= 2592000");
while ($rows = $db->fetchrows()) {
     //do something with the data
}