Thank you, I have shell access so I will give that a go.
Do you happen to know a way I can get it into CSV or some format that people can read easily?
--------------- Added [DATE]1362962204[/DATE] at [TIME]1362962204[/TIME] ---------------
I've managed to get it into .csv format, thank you for your help with the SQL.
If anyone else comes across this and needs to know the same thing, I used this command from the mysql prompt
Code:
SELECT * from post where username='billybob' INTO OUTFILE '/tmp/billybob.csv';