I can never remember how to do this, so leaving this here:
select post_title, post_content from wp_posts order by post_date asc into outfile '/var/lib/mysql-files/yourfile.txt';
Also see:
Articles, notes and random thoughts on Software Development and Technology
I can never remember how to do this, so leaving this here:
select post_title, post_content from wp_posts order by post_date asc into outfile '/var/lib/mysql-files/yourfile.txt';
Also see: